Package nz.co.transparent.client.controller

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

37
38
39
40
41
42
43
44
45
46
47
48
  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
74
75
76
77
78
79
80
81
82
83
84
85
    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
103
104
105
106
107
108
109
110
111
112
113
114
    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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
  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
170
171
172
173
174
175
176
177
178
179
180
181
182
  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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.