public java.lang.String[] getMenuItems2Enable(java.lang.String logiName) { java.sql.ResultSet rsetArray; java.lang.String[] menus2enable = null; java.sql.Array menuListArray = null; java.util.Vector menuVector = new java.util.Vector(1, 1); try { java.sql.Statement stmtDB = connDB.createStatement(); java.sql.ResultSet rSet = stmtDB.executeQuery( "SELECT menu_list FROM secure_menu_access WHERE login_name ='" + logiName + "' AND sys_name = 'hospital_hr'"); while (rSet.next()) { menuListArray = rSet.getArray(1); menus2enable = (java.lang.String[]) menuListArray.getArray(); } } catch (java.sql.SQLException sqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), sqlExec.getLocalizedMessage()); } System.out.println("These are items to enable \n"); for (int k = 0; k < menus2enable.length; k++) { // System.out.println(menus2enable[k]); } return menus2enable; }
/** * Takes an int[] contained in a java.sql.Array and returns the default String representation. * * @param object to format. * @return String represenetation of the int[]. * @throws IllegalArgumentException if the object is not an int[]; */ @Override public String format(Object object) { if (object == null) return ""; if (object instanceof java.sql.Array) { try { java.sql.Array array = (java.sql.Array) object; object = array.getArray(); } catch (SQLException e) { throw new IllegalArgumentException( "Error accessing array data for " + object.getClass().getCanonicalName(), e); } } if (object instanceof int[]) return toString((int[]) object); if (object instanceof Integer[]) return toString((Integer[]) object); throw new IllegalArgumentException(object.getClass().getCanonicalName() + " not supported."); }