前言
Mybatis和Mybatis-plus 是项目中和数据访问层交互的主流,但是有时候用原生的JdbcTemplate
还是比较方便,快捷,简洁,会更顺手一点
方法讲解
单个的增删改查带预编译的语法:
JdbcTemplate.update(sql,@Nullable Object... args)
String insertSql = "insert into table_user(create_time,version,name,phone) values(?,?,?,?)";
JdbcTemplate.update(insertSql,createTime,version,name,phone);
String updateSql = "update table_user set update_time =?,phone=?,version=version+1 where id =?";
JdbcTemplate.update(updateSql,updateTime,phone,id);
String deleteSql="delete from table_user where id = ?";
JdbcTemplate.update(deleteSql,id);
String selectSql = "select * from table_user where id =?";
JdbcTemplate.update(selectSql,id);
提升性能 批量增删改查待预编译的语法:
JdbcTemplate.batchUpdate(String sql, List<Object[]> batchArgs)
example:批量删除
List<Object[]> ids = new ArrayList<>();
List<Integer> idCollection = Arrays.asList(1, 2, 3, 4, 5, 6);
idCollection.forEach(id->ids.add(new Object[]{id}));
String deleteSql="delete from table_user where id = ?";
JdbcTemplate.batchUpdate(String deleteSql, ids)
抛转引玉 钻研和兴趣才是王道