JDBCTemplate增删改查（简单实现）-蒲公英云

JDBCTemplate增删改查（简单实现）

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
@Service
public class DataService {
    @Autowired
    @Qualifier("jdbcTemplate")
    private JdbcTemplate jdbcTemplate;
    //插入
    public void insert() {
        String sql = "INSERT INTO `test` (id,name,age) VALUES (?, ?, ?)";
        Object[] objects = new Object[]{"123","张珊","18"};
        jdbcTemplate.update(sqlTime,objects);
    }
    //修改
    public void update() {
        String sql = "UPDATE `test` set name=? where id=?";
        Object[] objects = new Object[]{"张丽","123"};
        jdbcTemplate.update(sql,objects);
    }
    //删除
    public void delete() {
        String sql = "delete from `test` where id = ?";
        jdbcTemplate.update(sql,"123");
    }
    //查询一条记录
    public void query() {
        String sql = "select * from `test` where id=?";
        Map<String, Object> map =jdbcTemplate.queryForMap(sql,"123");
    }
    //查询多条记录
    public void queryList() {
        String sql = "select * from `test`  where age=?";
        List<Map<String, Object>>  mapList= jdbcTemplate.queryForList(sql, "18");
    }
    //批量保存或修改（根据主键无则插入有则修改）
    public void insertOrUpdate() {
        String sql = "INSERT INTO `test` (id,name,age) VALUES (?, ?, ?) ON DUPLICATE KEY 
 UPDATE id=?,name=?,age=?";
        List<Object[]> listo = new ArrayList<Object[]>();
        for (Map<String, Object> map:list) {
            Object[] objects = new Object[]{"123","张珊","18","12345","李思","28"};
            listo.add(objects);
        }
        jdbcTemplate.batchUpdate(sql, listo);
    }
    //调用无返回存储过程
     public void queryList(String name) {
        Map<String,Object> map =jdbcTemplate.queryForMap("call tb_cunchuguocheng'"+name+"')");
     }
}