SSH2三大框架SQL查询

       /** * 查询省份名称 * @author YHD * @return * @see */@SuppressWarnings("unchecked")@Overridepublic List<Province> findProvince() {List<Province> proList = new ArrayList<Province>();StringBuffer sb = new StringBuffer();sb.append("SELECT ");sb.append("t.province_code,");sb.append("t.province_name,");sb.append("FROM ");sb.append("t_province_tab t ");sb.append("order by t.province_code ");SQLQuery query = getSession().createSQLQuery(sb.toString());List<Object[]> list = query.list();if(null != list && list.size() > 0){Province pro = null;for(Object[] obj:list){pro = new Province();pro.setProvinceCode(null==obj[0]? "":obj[0].toString());pro.setProvinceCode(null==obj[1]? "":obj[1].toString());proList.add(pro);}}return proList;}