(十五)JdbcTemplate--update
public int update(java.lang.String sql, //sql语句
@Nullable
java.lang.Object... args //sql中参数列表
)
throws DataAccessException
//返回值是影响的数据库行数
针对单条数据的操作,可以使用update方法,这个方法是用来支持insert,update,delete操作的,实例如下:
例子1--插入:
public void create(String name, Integer age) {
String insertQuery = "insert into Student (name, age) values (?, ?)";
jdbcTemplateObject.update(insertQuery, name, age);
System.out.println("Created Record Name = " + name + " Age = " + age);
return;
}
例子2--更新:
public void update(Integer id, Integer age) {
String SQL = "update Student set age = ? where id = ?";
jdbcTemplateObject.update(SQL, age, id);
System.out.println("Updated Record with ID = " + id);
return;
}
例子3--删除:
public void delete(Integer id) {
String SQL = "delete from Student where id = ?";
jdbcTemplateObject.update(SQL, id);
System.out.println("Deleted Record with ID = " + id);
return;
}
针对多条数据 batchUpdate
List<Object[]> args = new ArrayList<>();
Object[] arg1 = new Object[]{"lmw", "hz", "19"};
Object[] arg2 = new Object[]{"lmr", "hz", "16"};
args.add(arg1);
args.add(arg2);
jdbcTemplate.batchUpdate("insert into user(username, address, age) values(?, ?, ?)", args);
参考:https://www.yiibai.com/springjdbc