public RELabelSetupMainDetails loadLabelSetupMainDetails(String setupSeqId) throws Exception { String FETCH_QRY = "SELECT ID,SCREEN_ID,DESCRIPTION,JSP_NAME,VO_CLASS,HANDLER_CLASS, REMARKS, STATUS FROM SOFTWARE_SERVICES WHERE ID=?"; String LABEL_QUERY = "SELECT LF.ID,LF.FIELD_ID, LF.LABEL_TYPE, LF.VO_FIELD_TYPE, LF.REMARKS, LF.STATUS, LF.VO_FIELD_NAME, " + "(SELECT T4.SHORTCUT_KEY FROM LABEL_FIELDS_SHORTCUTKEYS T4 WHERE T4.FIELD_ID = LF.ID AND ROWNUM = 1) SHORTCUT_KEY " + "FROM LABEL_FIELDS LF WHERE LF.SERVICE_ID=?"; Connection con = null; PreparedStatement pstmt = null; PreparedStatement labelpstmt = null; ResultSet rs = null; ResultSet labelRs = null; RELabelSetupMainDetails mainDetails = null; RELabelFields labelFields = null; List<RELabelFields> labelList = null; try { con = TagLibConnectionUtil.getConnection(); labelFields = new RELabelFields(); mainDetails = new RELabelSetupMainDetails(); mainDetails.setLang("ENGLISH"); pstmt = con.prepareStatement(FETCH_QRY); labelpstmt = con.prepareStatement(LABEL_QUERY); pstmt.setString(1, setupSeqId); rs = pstmt.executeQuery(); if (rs.next()) { mainDetails.setSeqId(rs.getLong("ID")); mainDetails.setScrnId(rs.getString("SCREEN_ID")); mainDetails.setDesc(rs.getString("DESCRIPTION")); mainDetails.setJspName(rs.getString("JSP_NAME")); mainDetails.setVoClass(rs.getString("VO_CLASS")); mainDetails.setHandlerClass(rs.getString("HANDLER_CLASS")); mainDetails.setRemarks(rs.getString("REMARKS")); mainDetails.setStatus(rs.getString("STATUS")); labelpstmt.setString(1, setupSeqId); labelRs = labelpstmt.executeQuery(); labelList = new ArrayList<RELabelFields>(); while (labelRs.next()) { labelFields = new RELabelFields(); labelFields.setLabelSeqId(labelRs.getLong("ID")); labelFields.setLabelId(labelRs.getString("FIELD_ID")); labelFields.setLabelType(labelRs.getString("LABEL_TYPE")); labelFields.setVoFieldName(labelRs.getString("VO_FIELD_NAME")); labelFields.setVoFieldType(labelRs.getString("VO_FIELD_TYPE")); labelFields.setShortCutKey(labelRs.getString("SHORTCUT_KEY")); labelFields.setLabelType(labelRs.getString("LABEL_TYPE")); ; labelFields.setStatus(labelRs.getString("STATUS")); labelFields.setRemarks(labelRs.getString("REMARKS")); labelList.add(labelFields); } if (CollectionUtils.isNullEmpty(labelList)) { labelFields = new RELabelFields(); labelList.add(labelFields); } mainDetails.setFieldsList(labelList); mainDetails.setLangWiseFieldDescMap(getLangWiseFieldDescMap(mainDetails.getSeqId(), con)); } } finally { TagLibConnectionUtil.closePreparedStatement(pstmt, rs); TagLibConnectionUtil.closePreparedStatement(labelpstmt, labelRs); TagLibConnectionUtil.closeConnection(con); } return mainDetails; }