public static void main(String[] args) { try { inclusiveExceptionThrown(); } catch (IOException | SQLException e) { System.err.println(e.getClass()); } }
public viewSchedules() { super("View Schedules", "Total Schedule", "Group Schedule", "Team Schedule", "Final Schedule"); EXIT_OPTION = EXIT_VALUE; try { mmgr = new MatchManager(); tmgr = new TeamManager(); gmgr = new GroupManager(); } catch (IOException | SQLException ex) { System.out.println("ERROR - " + ex.getMessage()); } }
public Object executeFunction(CommandLine line) { if (!line.hasOption("name")) { ShellEnvironment.println("Required argument --name is missing."); return null; } try { String name = line.getOptionValue("name"); migrateCheckConstraint(name); } catch (IOException | SQLException | InterruptedException ex) { ex.printStackTrace(); } return null; }
public boolean insert_update(Personas_avatar pa, String dml) throws SQLException { Boolean control = false; try { con = new Conexion(); ps = con.getConnection().prepareStatement("select f_personas_avatar(?,?,?);"); ps.setString(1, dml); ps.setLong(2, pa.getCedula()); if (pa.getFoto() != null) { FileInputStream fis = new FileInputStream(pa.getFoto()); ps.setBinaryStream(3, fis, (int) pa.getFoto().length()); } else { ps.setNull(3, java.sql.Types.ARRAY); } control = ps.execute(); ps.close(); } catch (IOException | SQLException e) { e.printStackTrace(); System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } finally { con.close(); } return control; }
public byte[] select(Long cedula) throws SQLException { byte[] foto = null; try { con = new Conexion(); ps = con.getConnection() .prepareStatement("select foto from f_personas_avatar('select',?,null);"); ps.setLong(1, cedula); try (ResultSet rs = ps.executeQuery()) { while (rs.next()) { foto = rs.getBytes("foto"); } rs.close(); } ps.close(); } catch (IOException | SQLException e) { e.printStackTrace(); System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } finally { con.close(); } return foto; }
private void openFile() { try { String[] client = global .root .getHeaderRootPanel1() .getClientComboBox() .getSelectedItem() .toString() .split(", "); String matterName = global .root .headerRootPanel1 .getMatterComboBox() .getSelectedItem() .toString() .substring( 0, global .root .headerRootPanel1 .getMatterComboBox() .getSelectedItem() .toString() .length() - 13); Desktop desktop = Desktop.getDesktop(); global.MattersRS.first(); File openFile = new File( global.archivePath + client[0].trim() + " " + client[1].trim() + "_" + global.ClientIDRS.getInt("ClientID") + "\\" + matterName + "_" + global.ActivityDetailRS.getInt("MatterID") + "\\" + global.ActivityDetailRS.getString("File")); if (openFile.exists()) { desktop.open(openFile); } else { WebOptionPane.showMessageDialog( global.root, "Sorry, unable to locate file", "Error", WebOptionPane.ERROR_MESSAGE); } } catch (IOException | SQLException ex) { StringWriter error = new StringWriter(); ex.printStackTrace(new PrintWriter(error)); SystemCrashDialog crash = new SystemCrashDialog( global.root, true, global, global.root.getHeaderRootPanel1().getClientComboBox().getSelectedItem().toString(), global.root.getHeaderRootPanel1().getMatterComboBox().getSelectedItem().toString(), "Err0222", error.toString()); } }