JDBC ResultSet

public List<GrpGroup> getGroupByIndustryId(int industryId, int pageNo, int pageSize) {
        List<GrpGroup> list = new ArrayList<GrpGroup>();
        String sql = "SELECT * FROM GRP_GROUP G WHERE JOINTYPE=1 AND ISDISPLAY=1 AND (INDUSTRYTYPE REGEXP '^([0-9]+,)*" + industryId + "(,[0-9]+)*$') ORDER BY G.MEMBERCNT DESC, ACTIVEBYMONTH DESC";
        Session sess = getSession(true);
        Connection conn = sess.connection();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                GrpGroup group = new GrpGroup();
                group.setId(rs.getInt(1));
                group.setUserid(rs.getInt(2));
                group.setGroupname(rs.getString(3));
                group.setGroupdescr(rs.getString(4));
                group.setLogo(rs.getString(5));
                group.setMembercnt(rs.getInt(7));
                group.setFlag(rs.getShort(10));
                group.setCatid(rs.getInt(12));
                group.setCreatetime(rs.getDate(14));
                group.setModifytime(rs.getDate(15));
                group.setDomain(rs.getString(16));
                group.setDomainModifyCnt(rs.getInt(17));
                list.add(group);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pstmt != null) {
                    pstmt.close();
                }
                // musn't close conn, because Hibernate will handle connection pool, so just colse session instead
                if (sess != null) {
                    sess.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        int totalNum = list.size();
        int fromIndex = pageSize * (pageNo - 1);
        int toIndex = pageSize * pageNo;
        toIndex = toIndex <= totalNum ? toIndex : totalNum;
        list = new ArrayList<GrpGroup>(list.subList(fromIndex, toIndex));
        return list;
    }