From: Hendrik <nh...@us...> - 2009-07-05 20:51:16
|
Update of /cvsroot/arianne/marauroa/src/marauroa/server/db In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv17051/src/marauroa/server/db Modified Files: DBTransaction.java Log Message: added new methods execute and query Index: DBTransaction.java =================================================================== RCS file: /cvsroot/arianne/marauroa/src/marauroa/server/db/DBTransaction.java,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** DBTransaction.java 5 Jul 2009 15:43:50 -0000 1.6 --- DBTransaction.java 5 Jul 2009 20:51:14 -0000 1.7 *************** *** 1,4 **** --- 1,5 ---- package marauroa.server.db; + import java.sql.ResultSet; import java.sql.SQLException; import java.util.Map; *************** *** 114,117 **** } return res.toString(); ! } } --- 115,143 ---- } return res.toString(); ! } ! ! /** ! * executes an SQL statement with parameter substituion ! * ! * @param query SQL statement ! * @param params parameter values ! * @throws SQLException in case of an database error ! */ ! public void execute(String query, Map<String, Object> params) throws SQLException { ! String sql = subst(query, params); ! databaseAdapter.execute(sql); ! } ! ! ! /** ! * queries the database ! * ! * @param query SQL statement ! * @param params parameter values ! * @throws SQLException in case of an database error ! */ ! public ResultSet query(String query, Map<String, Object> params) throws SQLException { ! String sql = subst(query, params); ! return databaseAdapter.query(sql); ! } } |