String sql = "select * from t_document where rownum<40"; List data = jdbcTemplate.queryForList(sql); String json = JsonUtil.Encode(data); 转出来是大写的key那,这个怎么破?
这样写 用as
public List findSupplierBaseByName(String suppliername){
if(null != suppliername && !"".equals(suppliername.trim())){
String sql="select * from (select id as \"id\",suppliername,linkman,email,telephone,mobilephone,score from supplier where suppliername like ? ) where rownum <=10 ";
return jdbcTemplate.queryForList(sql, new Object[]{"%"+suppliername.trim()+"%"});
}
return null;
}