|
Sick of typing jdbc/sql calls everywhere in your servlets or jsps or whatever? Try this method on for size:
usage:
int rows_updated = executeUpdate("insert into something (a, b, c) values (?, ?, ?)",
new String [ ] {var_a, var_b, var_c});
public int executeUpdate(String query, String [ ] params) {
//get your connection from a database pool.
Connection dbconn = getConnection();
PreparedStatement stmt = null;
int r = -1;
try {
stmt = dbconn.prepareStatement(query);
for (int i = 1; i <= params.length; i++) {
stmt.setString(i, params[i - 1]);
}
r = stmt.executeUpdate();
}
catch(Exception e) {
e.printStackTrace(System.err);
}
finally {
try {
if (stmt != null)
stmt.close();
}
catch(SQLException e) {
e.printStackTrace(System.out);
}
//return your connection
setConnection(dbconn);
}
return r;
}
|
| |