Examples of nz.co.transparent.client.controller.GenericTransactionController

Package nz.co.transparent.client.controller

Examples of nz.co.transparent.client.controller.GenericTransactionController

nz.co.transparent.client.controller.GenericTransactionController
Handles generic function for a table: - query list of records - query specific reord - add record - update record - delete record Use this class to chain several methods into a transaction In case of 1 method only, use class GenericController in stead as it will handle the transaction. Client is responsible for: - commit or rollback of transaction - closing connection A final attempt will be made to close connection in finalize() method, but client must not rely on this ! @author John Zoetebier

  public void findWhere() {
    
    Map columnMap = null;
    try {
      Connection conn = DataSourceHandler.getDataSource().getConnection();
      GenericTransactionController controller = new GenericTransactionController(conn);
      columnMap = controller.findWhere("title", "title_code = 'Mrs'");
      DbUtils.close(conn);
    } catch (FinderException ce) {
      System.out.println(ce.getMessage());
      return;
    } catch (ControllerException ce) {

View Full Code Here

    columnMap.put("date_updated", null);
    columnMap.put("updater_person_id", new Integer(3));
    
    try {
      Connection conn = DataSourceHandler.getDataSource().getConnection();
      GenericTransactionController controller = new GenericTransactionController(conn);
      if (controller.insertRecord("title", "title_id", columnMap) == 0) {
        conn.rollback();
      } else {
        conn.commit();
      }
      DbUtils.close(conn);

View Full Code Here

    columnMap.put("date_updated", null);
    columnMap.put("updater_person_id", new Integer(3));
    
    try {
      Connection conn = DataSourceHandler.getDataSource().getConnection();
      GenericTransactionController controller = new GenericTransactionController(conn);
      int result = controller.insertRecord("role", "role_code", columnMap);
      System.out.println("Number of records affected = " + result);
      conn.commit();
      DbUtils.close(conn);
    } catch (ControllerException ce) {
      System.out.println(ce.getMessage());

View Full Code Here


  public void updateRecord() {
    
    try {
      Connection conn = DataSourceHandler.getDataSource().getConnection();
      GenericTransactionController controller = new GenericTransactionController(conn);
      Map columnMap = controller.findWhere("role", "role_code='A'");
      columnMap.put("role", "Test title is changed");
//      columnMap.put("role_code", "B");
//      columnMap.put("date_created", new Date());
//      columnMap.put("date_updated", new Date());
//      columnMap.put("updater_person_id", new Integer(3));
      
      controller.updateRecord("role", "role_code", columnMap);
      conn.commit();
      DbUtils.close(conn);
    } catch (FinderException ce) {
      System.out.println("FinderException: " + ce.getMessage());
      return;

View Full Code Here


  public void deleteRecord() {
    
    try {
      Connection conn = DataSourceHandler.getDataSource().getConnection();
      GenericTransactionController controller = new GenericTransactionController(conn);


      int result = controller.deleteRecord("role", "role_code='A'");
      System.out.println("Number of records affected = " + result);
      conn.commit();
      
      DbUtils.close(conn);
    } catch (ControllerException ce) {

View Full Code Here

TOP

Related Classes of nz.co.transparent.client.controller.GenericTransactionController

org.apache.commons.dbutils.handlers.MapHandler

org.apache.commons.dbutils.handlers.MapListHandler

org.apache.commons.dbutils.QueryRunner

org.apache.commons.dbutils.ResultSetHandler

test.TestGenericTransactionController

nz.co.transparent.client.db.FinderException

java.util.Map

java.util.ArrayList

java.util.Date

nz.co.transparent.client.db.UpdaterException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.