1.jdbcTemplate.queryForObject 返回的单行单列的数据。相当于查询数据有多少列。
String Sql=select count(*) count from S_JFLHHMD jflhndcsid=?
String forObject = jdbcTemplate.queryForObject(Sql, String.class(Integer,class), jflhndcsid);
2.jdbcTemplate.query() 返回list集合,带泛型,泛型是自定义对象。
List<ExamManager> query = jdbcTemplate.query("select * from k_ksgl", new BeanPropertyRowMapper(ExamManager.class));
3.Clob类型存储
final LobHandler lobHandler=new DefaultLobHandler();
final String newjson= JSON.toJSONString(obj);//newjson 就是要存储的内容,内容很大。
String sql = "UPDATE P_GRXX grxx SET grxxhz=? where grxx.id="+grxxId+" and grxx.jflhndcsid="+ndId;
jdbcTemplate.execute(sql,new AbstractLobCreatingPreparedStatementCallback(lobHandler){
protected void setValues(PreparedStatement ps,
LobCreator lobCreator) throws SQLException {
lobCreator.setClobAsString(ps, 1, newjson);
}
});