Package org.apache.commons.dbutils.handlers

Examples of org.apache.commons.dbutils.handlers.MapHandler

40
41
42
43
44
45
46
47
48
49
50
  public void updateRecord(String tableName, String primaryKeyName, Map columnMap) 
  throws ControllerException  {
   
    Connection conn = null;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      conn = dataSource.getConnection();
      conn.setAutoCommit(false);  // Start transaction
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
      System.out.println(se.getMessage());
      return;
    }
   
    QueryRunner runner = new QueryRunner();
    ResultSetHandler rsh = new MapHandler();
    String sql = "select * from Client where (ClientID=1)";
    Map clientMap = null;
    try {
      clientMap = (Map) runner.query(conn, sql, null, rsh);
    } catch (SQLException se) {
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    } else {
      sql += " set acount unlock";
    }
     
    QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
    ResultSetHandler rsh = new MapHandler();
    try {
      queryRunner.update(sql);
    } catch (SQLException se) {
      log.warning("SystemDBController: " + se.getMessage());
      throw new ControllerException(se);
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
    if (groupList != null) {
      sql += " set groups '" + groupList +"'";
    }
   
    QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
    ResultSetHandler rsh = new MapHandler();
    try {
      queryRunner.update(sql);
    } catch (SQLException se) {
      log.warning("SystemDBController: " + se.getMessage());
      throw new ControllerException(se);
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
   
    // Create user in system database as well.
    String sql = "select * from SYS_INFO.sUSRPassword";
    sql += " where (UserName='" + userName + "')";
    QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
    ResultSetHandler rsh = new MapHandler();

    try {
      return (Map) queryRunner.query(sql, rsh);
    } catch (SQLException se) {
      log.warning("SystemDBController: " + se.getMessage());
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
   */
  public Map findWhere(String tableName, String whereClause)
    throws ControllerException, FinderException {

    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      sql = "SELECT * FROM " + tableName;

View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
    String whereClause,
    Object[] params)
    throws ControllerException {

    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      sql = "SELECT * FROM " + tableName;

View Full Code Here
553
554
555
556
557
558
559
560
561
562
563
    Map columnMap)
    throws ControllerException, UpdaterException {

    Connection conn = null;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      conn = dataSource.getConnection();
      conn.setAutoCommit(false); // Start transaction
View Full Code Here
701
702
703
704
705
706
707
708
709
710
711
    if (!isDefault) {
      return;
    }

    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = null;
    sql = "select * from " + tableName;
    sql += " where (";
    sql += " (is_default=true)";

View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
 
  public void go() {
   
    DataSource dataSource= DataSourceHandler.getDataSource();
    QueryRunner runner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = "select * from Client where (ClientID=1)";
    Map clientMap = null;
    try {
      clientMap = (Map) runner.query(sql, null, rsh);
    } catch (SQLException se) {
View Full Code Here
TOP

Related Classes of org.apache.commons.dbutils.handlers.MapHandler

  • cn.chen.core.DBhelp
  • nz.co.transparent.client.controller.GenericController
  • nz.co.transparent.client.controller.GenericTransactionController
  • nz.co.transparent.client.controller.LoginController
  • nz.co.transparent.client.controller.SpecificController
  • nz.co.transparent.client.controller.SystemDBController
  • test.TestDbUtils
  • test.TestDbUtils2
  • test.TestDbUtils3
  • test.TestException
    • 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.