/** * 查询省份名称 * @author YHD * @return * @see */ @SuppressWarnings("unchecked") @Override public 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; }