Esempio n. 1
0
 /*  36:    */
 /*  37:    */ public ResultSet getPersonnelForReport(Long personnelId) /*  38:    */ {
   /*  39: 41 */ Connection conn = JDBCUtility.getConnection();
   /*  40: 42 */ String sql = "{call DBPK_HRM_PERSONNEL_REPORT.get_Personnel_For_Report(?,?)}";
   /*  41:    */ try
   /*  42:    */ {
     /*  43: 45 */ CallableStatement cstmt = conn.prepareCall(sql);
     /*  44: 46 */ cstmt.registerOutParameter(1, -10);
     /*  45: 48 */ if (personnelId.longValue() == -1L) {
       /*  46: 48 */ cstmt.setString(2, null);
       /*  47:    */ } else {
       /*  48: 49 */ cstmt.setString(2, personnelId.toString());
       /*  49:    */ }
     /*  50: 51 */ cstmt.execute();
     /*  51: 52 */ return (ResultSet) cstmt.getObject(1);
     /*  52:    */ }
   /*  53:    */ catch (Exception e)
   /*  54:    */ {
     /*  55: 55 */ e.printStackTrace();
     /*  56: 56 */ this.logger.log(Priority.ERROR, e.getMessage());
     /*  57:    */ }
   /*  58: 57 */ return null;
   /*  59:    */ }