public static NavData[] getAll() { Connection con = null; PreparedStatement ps; ResultSet rs; ArrayList<NavData> alfaq = new ArrayList<NavData>(); try { con = Db.getConnection(); String ssql = "select * from navdata order by navdataid desc"; ps = con.prepareStatement(ssql, Statement.RETURN_GENERATED_KEYS); rs = ps.executeQuery(); while (rs.next()) { NavData faq = new NavData(); faq.fromResultSet(rs); alfaq.add(faq); } rs.close(); ps.close(); } catch (Exception e) { log.error("", e); } finally { Db.releaseConnection(con); } NavData[] ret = new NavData[alfaq.size()]; alfaq.toArray(ret); return (ret); }
public void main() throws Exception { Connection c = db.getConnection(); // c.setAutoCommit(false); int count = 1 + r.nextInt(9); for (int i = 0; i < count; i++) { c.createStatement().execute("NOTIFY mail_raw, '" + i + "';"); } // c.commit(); log.info("NOTIFY performed, count={}", count); c.close(); }
public int insert() { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; java.sql.Date d = new java.sql.Date(new Date().getTime()); try { con = Db.getConnection(); String ssql = "insert into navdata (" + "name," + "address," + "na," + "phone," + "fax," + "na2," + "ein_number," + "financial_score," + "acct_n_transparency," + "overall," + "score_graph," + "program_expenses," + "admin_expenses," + "fundraising_expenses," + "primary_revenue_growth," + "program_expnse_growth," + "wrkng_capital_ratio," + "mission," + "year_fye," + "cont_gifts_grants," + "federated_campaigns," + "related_orgs," + "govt_grants," + "total_contributions," + "program_service_reven," + "total_primary_revenue," + "other_revenue," + "total_revenue," + "program_expense," + "admin_expense," + "fundraising_expense," + "total_func_expenses," + "payments_affiliates," + "excessordeficit_year," + "net_assets," + "board_leadership," + "ceo," + "email," + "website" + " ) values " + "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; ps = con.prepareStatement(ssql, Statement.RETURN_GENERATED_KEYS); ps.setString(1, name); ps.setString(2, address); ps.setString(3, na); ps.setString(4, phone); ps.setString(5, fax); ps.setString(6, na2); ps.setString(7, ein_number); ps.setString(8, financial_score); ps.setString(9, acct_n_transparency); ps.setString(10, overall); ps.setString(11, score_graph); ps.setString(12, program_expenses); ps.setString(13, admin_expenses); ps.setString(14, fundraising_expenses); ps.setString(15, primary_revenue_growth); ps.setString(16, program_expnse_growth); ps.setString(17, wrkng_capital_ratio); ps.setString(18, mission); ps.setString(19, year_fye); ps.setString(20, cont_gifts_grants); ps.setString(21, federated_campaigns); ps.setString(22, related_orgs); ps.setString(23, govt_grants); ps.setString(24, total_contributions); ps.setString(25, program_service_reven); ps.setString(26, total_primary_revenue); ps.setString(27, other_revenue); ps.setString(28, total_revenue); ps.setString(29, program_expense); ps.setString(30, admin_expense); ps.setString(31, fundraising_expense); ps.setString(32, total_func_expenses); ps.setString(33, payments_affiliates); ps.setString(34, excessordeficit_year); ps.setString(35, net_assets); ps.setString(36, board_leadership); ps.setString(37, ceo); ps.setString(38, email); ps.setString(39, website); ps.executeUpdate(); rs = ps.getGeneratedKeys(); rs.next(); navdataid = rs.getInt(1); log.debug("Added encryption " + navdataid); rs.close(); ps.close(); Db.releaseConnection(con); } catch (Exception e) { log.error("", e); navdataid = 0; Db.releaseConnection(con); } return (navdataid); }