JdbcTemplate+Mysql：新增数据后，返回自增ID

**JdbcTemplate+Mysql：新增数据后，返回自增ID**
//亲测有效
	public int insertSchoolData(final String provinceAdd, final String orgName,
		final String type, final String cityId, final String countryId, final String provinceId,
		final String code) {
	try{
	    final String sql="insert into public_org_school(NAME,TYPE,PROVINCE_ADD,CITY_ID,COUNTY_ID,PROVINCE_ID,CODE) "
			+ "values (?,?,?,?,?,?,?)";
		KeyHolder keyHolder = new GeneratedKeyHolder(); 
		this.getJdbcTemplate().update(new PreparedStatementCreator() {
		@Override
		public PreparedStatement createPreparedStatement(java.sql.Connection con) throws SQLException {
			PreparedStatement ps= con.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
			ps.setString(1, orgName);
			ps.setString(2, type);
			ps.setString(3, provinceAdd);
			ps.setString(4, cityId);
			ps.setString(5, countryId);
			ps.setString(6, provinceId);
			ps.setString(7, code);
			return ps;
		}}, keyHolder);
		
		return keyHolder.getKey().intValue(); //返回自动增加的id号
	}catch(Exception e){
		logger.error(e.getMessage(), e);
		return 0;
	}
}