Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.QueryRunner.query()

42
43
44
45
46
47
48
49
50
51
52
    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) {
      System.out.println(se.getMessage());
      return;
    }
   
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
      System.out.println("Field value = " + clientMap.get(fieldName));
    }
   
    clientMap = null;
    try {
      clientMap = (Map) runner.query(conn, sql, null, rsh);
      DbUtils.close(conn);
    } catch (SQLException se) {
      System.out.println(se.getMessage());
      return;
    }
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
    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());
      throw new ControllerException(se);
    }
  }     
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
      QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
      ResultSetHandler rsh = new MapListHandler();
      String sql = "select * from parameter";
     
      try {
        parameterMap = (Map) queryRunner.query(sql, rsh);
      } catch (SQLException se) {
        String msg = "Parameter: error loading parameters.\n" + se.getMessage();
        log.warning(msg);
        Messager.exception(null, msg);
        return;
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    QueryRunner runner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new ResultSetMetaDataHandler();
    String sql = "select * from Client";
    List columnList = null;
    try {
      columnList = (List) runner.query(sql, rsh);
    } catch (SQLException se) {
      System.out.println(se.getMessage());
      return;
    }
   
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
      if (orderClause != null) {
        sql += " ORDER BY " + orderClause;
      }

      return (List) queryRunner.query(sql, rsh);
    } catch (SQLException se) {
      log.warning("GenericController SQLException: " + se.getMessage());
      throw new ControllerException(se);
    }
  }
View Full Code Here
307
308
309
310
311
312
313
314
315
316
317
      if (whereClause != null) {
        sql += " WHERE " + whereClause;
      }

      Map map = (Map) queryRunner.query(sql, rsh);
      if (map == null) {
        throw new FinderException();
      }

      return map;
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
        sql += " WHERE (" + whereClause + ")";
      }

      Map map = null;
      if (params == null) {
        map = (Map) queryRunner.query(sql, rsh);
      } else {
        map = (Map) queryRunner.query(sql, params, rsh);
      }

      if (map == null) {
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
      Map map = null;
      if (params == null) {
        map = (Map) queryRunner.query(sql, rsh);
      } else {
        map = (Map) queryRunner.query(sql, params, rsh);
      }

      if (map == null) {
        return false;
      } else {
View Full Code Here
563
564
565
566
567
568
569
570
571
572
573
      conn.setAutoCommit(false); // Start transaction

      sql = "select * from " + tableName;
      sql += " where (" + primaryKeyName + "=?)";
      Map columnMapTemp =
        (Map) queryRunner.query(
          sql,
          columnMap.get(primaryKeyName),
          rsh);

      if (columnMapTemp == null) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.