6869707172737475767778
con = dbc.getDBConnection(); return simpleSelect( con, bean, properties); } finally { dbc.closeDBConnection( con ); } } public SimpleBean simpleSelect( SimpleBean bean, Map<String,String> properties) throws Exception {
8384858687888990919293
con = dbc.getDBConnection(); return simpleSelect( con, bean, properties ); } finally { dbc.closeDBConnection( con ); } } /** * Get the data from the database based on the bean you pass * in and return the fully populated bean. This method
260261262263264265266267268269270
con = dbc.getDBConnection(); return simpleSelectList( con, bean, columns); } finally { dbc.closeDBConnection(con); } } /** * Same as above except with a Map of columns to use
376377378379380381382383384385386
con = dbc.getDBConnection(); return simpleSelectList( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } /** * Insert data into the database based on columns introspected from the bean
405406407408409410411412413414415
con = dbc.getDBConnection(); simpleInsert( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } public void simpleInsert( SimpleBean bean, Map<String,String> properties ) throws Exception {
420421422423424425426427428429430
con = dbc.getDBConnection(); simpleInsert( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } /** * Creates and executes a SQL INSERT statement against the passed in Connection object.
483484485486487488489490491492493
con = dbc.getDBConnection(); simpleUpdate( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } /** * Creates and runs a SQL UPDATE statement against the passed database connection object.
530531532533534535536537538539540
con = dbc.getDBConnection(); simpleUpdate( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } /** *
559560561562563564565566567568569
con = dbc.getDBConnection(); simpleDelete( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } /** * Creates and executes a SQL DELETE statement against the Connection parameter.
605606607608609610611612613614615
con = dbc.getDBConnection(); simpleDelete( con, bean, properties ); } finally { dbc.closeDBConnection(con); } } private String buildSelectSQL( SimpleBean bean, Map<String,String> columns, ArrayList<BoundVariable> bindVariables ) throws Exception {