jdbcTemplate常见用法整理。

返回list类型String sql = "select * from " + Constant.WEBDBNAME +".coninfo_classification where userid = ?";List<ConnClassification> list = jdbcTemplate.query(sql, new Object[]{userid},ParameterizedBeanPropertyRowMapper.newInstance(ConnClassification.class));插入返回插入自增主键idpublic 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; }