返回list类型
String sql = "select * from " + Constant.WEBDBNAME +".coninfo_classification where userid = ?";
List<ConnClassification> list = jdbcTemplate.query(sql, new Object[]{userid},
ParameterizedBeanPropertyRowMapper.newInstance(ConnClassification.class));
插入返回插入自增主键id
public int createFolder(int userid,String foldername,String usercomefrom){
String ctime = Util.dateFormat2(new Date());
String sql ="insert into " + Constant.WEBDBNAME +".coninfo_classification(userid,name,usercomefrom,createtime) VALUES(?,?,?,?);";
KeyHolder keyHolder = new GeneratedKeyHolder();
int id =0;
try {
jdbcTemplate.update(new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection arg0) throws SQLException {
PreparedStatement ps = arg0.prepareStatement(sql);
ps.setInt(1,userid );
ps.setString(2,foldername);
ps.setString(3,usercomefrom);
ps.setString(4,ctime);
return ps;
}
}, keyHolder);
id = keyHolder.getKey().intValue();
} catch (Exception e) {
e.printStackTrace();
}
return id;
}
同时修改,插入多条信息(只执行一次sql)
/**
* 批量随机更新资源库成果需求配图
* @author shen.guoliang
* @version 1.0, 2017年7月3日
* @param piclist 参数说明
* @see [类,类#方法,类#成员]
* @since [产品/模块版本] 表示从那个版本开始就有这个方法
*/
public int updatePic(List<ProjectModel> prilist){
String sql = "update " + Constant.WEBDBNAME + ".technical_info set imgname =? where id = ? and project_type_id =?";
List<Object[]> args = new ArrayList<>();
if (prilist != null && prilist.size() > 0) {
for (int i = 0; i < prilist.size(); i++) {
ProjectModel pic = prilist.get(i);
Object[] obj = new Object[Constant.NUM_3];
obj[0] = pic.getImgname();
obj[1] = pic.getId();
obj[2] = pic.getProjectTypeId();
args.add(obj);
}
int[] ret = jdbcTemplate.batchUpdate(sql, args);
args = null;
return ret.length;
}
return 0;
}
jdbcTemplate常见用法整理。
最新推荐文章于 2024-06-27 08:00:00 发布