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);
}
