rs通过oneFieldValues的方法生成Collection结果集
public Collection<String> findItems() throws SQLException{
String userName = Tools.toString(paramMap.get("userName"));String sql = "select item_id from shzh.v_com_item where factory=?" ;
Result rs = new Result();
rs.queryMapColl(sql,userName);
Collection<String> coll = rs.oneFieldValues(1);
return coll;
}