Examples of ResultSetHandler

Examples of com.iCo6.util.org.apache.commons.dbutils.ResultSetHandler

354
355
356
357
358
359
360
361
362
363
364
                QueryRunner run = new QueryRunner();

                try {
                    try{
                        run.query(old, "SELECT * FROM " + table, new ResultSetHandler(){
                            public Object handle(ResultSet rs) throws SQLException {
                                Account current = null;
                                Boolean next = rs.next();

                                if(next)
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

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

Examples of org.apache.commons.dbutils.ResultSetHandler

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

Examples of org.apache.commons.dbutils.ResultSetHandler

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

Examples of org.apache.commons.dbutils.ResultSetHandler

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

Examples of org.apache.commons.dbutils.ResultSetHandler

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

Examples of org.apache.commons.dbutils.ResultSetHandler

104
105
106
107
108
109
110
111
112
113
114
   *
   */
  public static void loadParameters() {

      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) {
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

48
49
50
51
52
53
54
55
56
57
58
 
  public void go() {
   
    DataSource dataSource= DataSourceHandler.getDataSource();
    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) {
View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

130
131
132
133
134
135
136
137
138
139
140
    String orderClause,
    String whereClause)
    throws ControllerException {

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

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

View Full Code Here

Examples of org.apache.commons.dbutils.ResultSetHandler

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
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.