JDBCTemplate增删改查（简单实现）

爱被打了一巴掌 2023-01-10 10:22 210阅读 0赞

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+"')");
         }
    
    }