Package org.apache.commons.dbutils

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

123
124
125
126
127
128
129
130
131
132
133
        personRoleMap.put("role_id",new Integer(2));
        genericController.insertRecord("person_role", "person_role_id", personRoleMap);
       
        // Grant all premission to person table
        sql = "grant ALL on APP.person to " + userName + " with grant option";
        int result = queryRunner.update(sql);
      }

      sql =
        "select role_id from person_role where person_id = "
          + personMap.get("person_id");
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
          + " where ("
          + " (person_id=?)"
          + " )";

      Integer personID = (Integer) personMap.get("person_id");
      int result = queryRunner.update(sql, personID);

      if (result == 0) {
        sql =
          "insert into login"
            + " set user_name="
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
        sql =
          "insert into login"
            + " set user_name="
            + SQL.getUniqueKey("login", "user_name")
            + " ,person_id=?";
        result = queryRunner.update(sql, personID);
      }

      return;
    } catch (SQLException se) {
      String message =
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
          + " (person_id=?)"
          + " )";

      Integer personID = (Integer) personMap.get("person_id");
      Object[] params = { personID };
      int result = queryRunner.update(sql, params);
    } catch (SQLException se) {
      String message =
        "LoginController: SQL Exception: " + se.getMessage();
      log.warning(message);
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    String sql = "create user " + userName + " set password '" + password + "'";
    QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
   
    try {
     
      queryRunner.update(sql);
    } catch (SQLException se) {
      log.warning("SystemDBController: " + se.getMessage());
      throw new ControllerException(se);
    }
  }     
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
    }
     
    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
146
147
148
149
150
151
152
153
154
155
156
    }
   
    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
164
165
166
167
168
169
170
171
172
173
174
    throws ControllerException {
   
    String sql = "drop user " + userName;
    QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
    try {
      queryRunner.update(sql);
    } catch (SQLException se) {
      log.warning("SystemDBController: " + se.getMessage());
      throw new ControllerException(se);
    }
  }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
   */
  public static int update(String sql, Object... params) {
    Connection con=DBPool.getConnection();
    try {
      QueryRunner runner = new QueryRunner();
      return runner.update(con,sql, params);
    } catch (Exception e) {
      log.error(e.getMessage(), e);
    }finally{
      DBPool.releaseConnection(con);
    }
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
      sql.append(" WHERE SchritteID = ? ");
      Object[] param = { step.getTitle(), step.getReihenfolge(), step.getBearbeitungsstatus(), time, start, end,
          step.getBearbeitungsbenutzer(), step.getEditType(), step.isTypAutomatisch(), step.getId() };
      logger.debug("saving step: " + sql.toString() + ", " + param);

      run.update(connection, sql.toString(), param);
      // logger.debug(sql);
      ret = step.getId();
      return ret;
    } finally {
      closeConnection(connection);
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.