Spring JDBC

 jar包

基础入门

public class JdbcTemplateDemo1 {
    public static void main(String[] args) {
        //导入jar包
        //创建JdbcTemplate对象
        JdbcTemplate jdbcTemplate = new JdbcTemplate(JdbcPollutils.getDataSource());
        //调用方法
        String sql="update info set address='湖南'where id=?";
        int update = jdbcTemplate.update(sql,1);
        System.out.println(update);
    }
}

 单元测试

public class JdbcTemplateDemo2 {
     private JdbcTemplate jdbcTemplate = new JdbcTemplate(JdbcPollutils.getDataSource());
    //单元测试
    //更新一条数据
    @Test
    public void test1() {
        //获取JdbcTemplate对象
        String sql = "update info set name='你好' where id=1";
        int update = jdbcTemplate.update(sql);
        System.out.println(update);
    }
    //插入一条数据
    @Test
    public void test2(){
        String sql="insert into info (name,address) values(?,?)";
        int update = jdbcTemplate.update(sql, "lisa", "北京");
        System.out.println(update);
    }
    //删除添加的数据
    @Test
    public void test3(){
        String sql="delete from info where id=?";
        int update = jdbcTemplate.update(sql, 3);
        System.out.println(update);
    }
    //查询id=1的记录，将其封装为Map集合
    @Test
    public void test4(){
        String sql="select * from info where id=?";
        Map<String, Object> stringObjectMap = jdbcTemplate.queryForMap(sql, 1);
        System.out.println(stringObjectMap);
        //{id=1, name=你好, gender=男, address=湖南}
    }
    //查询所有记录 将其封装为list集合
    @Test
    public void test5(){
        String sql="select * from info ";
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
        //iter迭代器
        for (Map<String,Object> stringObjectMap:maps
             ) {
            System.out.println(stringObjectMap);
        }
    }
    //查询所有结果 将其封装为Info对象的list集合
    @Test
    public void test6() {
        String sql = "select * from info ";
        List<Info> list = jdbcTemplate.query(sql, new RowMapper<Info>() {

            @Override
            public Info mapRow(ResultSet resultSet, int i) throws SQLException {
                Info info = new Info();
                int id=resultSet.getInt("id");
                String name=resultSet.getString("name");
                String gender=resultSet.getString("gender");
                String address=resultSet.getString("address");
                info.setId(id);
                info.setName(name);
                info.setGender(gender);
                info.setAddress(address);
                return info;
            }
        });
        for (Info info : list) {
            System.out.println(info);

        }
    }
    //重要
    @Test
    public void test6_2() {
        String sql = "select * from info ";
        List<Info> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Info>(Info.class));
        for (Info info : list) {
            System.out.println(info);

        }
    }
}