JDBCTemplate

JDBCTemplate的使用

1. JDBCTemplate的注入

@AuoWired
private JdbcTemplate jdbcTemplate;

2. JDBCTemplate的增删改查

2.1 增加s数据

1. 增加一条数据

    //增加一条数据
    @Test
    public void test03() {
        String sql = "insert into demo02(name,email) values(?,?)";
        jdbcTemplate.update(sql,"小黄","145@163.com");
    }

2. 增加多条数据

    //批量插入
    @Test
    public void test05() {
        String sql = "insert into demo02(name,email) values(?,?)";
        ArrayList<Object[]> bathArgs = new ArrayList<>();
        bathArgs.add(new Object[]{"小黄","111@qq.com"});
        bathArgs.add(new Object[]{"小绿","222@qq.com"});
        bathArgs.add(new Object[]{"小红","333@qq.com"});
        jdbcTemplate.batchUpdate(sql, bathArgs);
    }

2.2 删除一条数据

    //删除一条数据
    @Test
    public void test04() {
        String sql = "delete from demo02 where id = ?";
        jdbcTemplate.update(sql,5);
    }

2.3 更新一条数据

    //更新一条数据
    @Test
    public void test06() {
        String sql = "update demo02 set name = ? where id = ?";
        jdbcTemplate.update(sql,"小橙",8);
    }

2.4 查询数据

1. 查询单个数据

    //查询单个用户
    @Test
    public void test02() {
        String sql = "select * from demo02 where id = ?";
        User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);
        System.out.println(user);
    }

2. 查询多个数据

    //查询全部的用户
    @Test
    public void test01() {
        String sql = "select * from demo02";
        List<User> userList = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
        for(User user : userList) {
            System.out.println(user);
        }
    }

环环无敌大可爱💘