SpringBoot集成JdbcTemplate实现：增、删、改、查

1、Maven依赖

<!-- jdbcTemplate 依赖 -->
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mysql 依赖 -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
</dependency>

2、插入

//调用jdbcTemplate对象中的方法实现操作
String sql = "insert into user value(?,?,?)";
//表结构：id（int、自增）,name(varchar 100),age(int 10)
int rows = jdbcTemplate.update(sql, null, "Tom", 35);

3、删除

String updateSql = "delete from user where user_id= ?";
if(jdbcTemplate.update(updateSql,"445668552") > 0) {
}

4、更新

String updateSql = "update user set age = ? where user_id= ?";
if(jdbcTemplate.update(updateSql,55,‘445668552’) > 0) {
}

5、查询返回一个对象

String sql = "select * from user where name = ?";
//新建MyRowMapper类实现RowMapper接口，重写mapRow方法，指定返回User对象
User user = jdbcTemplate.queryForObject(sql, new UserRowMapper(), "Tom");
System.out.println(user);

UserRowMapper 实现

public class UserRowMapper implements RowMapper<User>{
    @Override
    public User mapRow(ResultSet resultSet, int i) throws SQLException {
		//获取结果集中的数据
        String name = resultSet.getString("name");
        String age = resultSet.getString("age");
		//把数据封装成User对象
        User user = new User();
        user.setName(name);
        user.setAge(age);
        return user;
    }
}

6、查询返回对象集合

String sql = "select * from user";
//第三个参数可以省略
List<User> users = jdbcTemplate.query(sql, new UserRowMapper ());
System.out.println(users);

7、查询返回一个值

String sql = "select count(*) from user";
int count = jdbcTemplate.queryForObject(sql, Integer.class);
 System.out.println("数据总数：" + count);