class OrganizationsInDB {
Connection db;
OrganizationsInDB() {
Class.forName("org.postgresql.Driver");
db =
DriverManager.getConnection(
"jdbc:postgresql://myhost/ConferenceDB",
"PaulChan",
"myP@ssword");
}
void addOrganization(Organization o) {
PreparedStatement st =
db.prepareStatement(
"INSERT INTO organizations VALUES (?,?,?,?,?,?,?,?,?,?,)");
try {
st.setString(1, o.getId());
st.setString(2, o.getEName());
st.setString(3, o.getCName());
...
st.executeUpdate();
} finally {
st.close();
}
}
}