springJDBC

 返回一个字符串列表

String sql="select colname from TB_DATA_TEMPLATE_FIELD where tablename='"+tablename+"'";
List<String> list = jdbcTemplate.queryForList(sql, String.class);

 返回一个数字

long count = jdbcTemplate.queryForObject(countQuery+sb.toString(), long.class);

 

 

返回一个对象列表

 List<Version> versionList = jdbcTemplate.query(sql,new BeanPropertyRowMapper<Version>(Version.class));

 

 

返回一个对象

DataTemplateField dataTemplateField = jdbcTemplate.queryForObject(sql2, new BeanPropertyRowMapper<DataTemplateField>(DataTemplateField.class));

 

返回一个List<Map<String,Object>>

List<Map<String, Object>> maps = jdbcTemplate.queryForList(sb.toString());