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));





插入返回插入自增主键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;

	 }