内控一些方法
<p>转list<String>
public List<String> querySupplyMoneyDepProQualified(Session session) {
StringBuilder sql = new StringBuilder("select t.dep_pro_code")
.append(" from quota_monetary t")
.append(" left join quota_pay_project t1 on t.dep_pro_code = t1.pro_code ")
.append(" where t.year = ? and t.quota_level = 2 ")
.append(" AND t.dep_pro_code IS NOT null ");
sql.append(" group by t.dep_pro_code, t.dep_pro_name ");
sql.append(" HAVING sum(t.prepared_funds)>0 ");
return baseDAO.queryForList(sql.toString(), new Object[]{session.getBusiYear()},new RowMapper<String>(){
public String mapRow(ResultSet rs, int rowNum)
throws SQLException {
return rs.getString(1);
}
});
}</p>