Package org.apache.commons.dbutils

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

75
76
77
78
79
80
81
82
83
84
85
    String sql = "insert into comment (comment_username,comment_content,blog_id,comment_created_time) values(?,?,?,now())";
    String params[] = { name, content, blogId };

    QueryRunner qr = DbHelper.getQueryRunner();
    try {
      qr.update(sql, params);
    } catch (SQLException e) {

      e.printStackTrace();
    }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    String id = request.getParameter("id");
    String sql = "delete from comment where comment_id=" + id;
    QueryRunner qr = DbHelper.getQueryRunner();
    try {
      qr.update(sql);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    list(request, response);
  }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
    String sql = "update comment set comment_username=?,comment_content=? where comment_id=?";
    String params[] = { name, content, id };
    QueryRunner qr = DbHelper.getQueryRunner();
    try {
      qr.update(sql, params);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    list(request, response);
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
    } else if (newPassword.equals(reNewPassword)) {
      String sql = "update users set users_password=? where users_id=?";
      String params[] = { newPassword, user.getId().toString() };
      QueryRunner qr = DbHelper.getQueryRunner();
      try {
        qr.update(sql, params);
      } catch (SQLException e) {
        e.printStackTrace();
      }
      response.sendRedirect("/blog/admin/admin.jsp");
    } else {
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
                // 为SQL语句中的占位符？设定参数
                String params[] = {title, content, categoryId};
                QueryRunner qr = DbHelper.getQueryRunner();
                // 调用update 方法 完成SQL的执行 update中其他可用的SQL语句：insert
                // into/update/delete
                result = qr.update(sql, params);

                String message = "";
                if (result == 1) {
                    message = "添加博文成功";
                } else {
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
                String sql = "delete from blog where blog_id=" + id;
                QueryRunner qr = DbHelper.getQueryRunner();

                // 调用update 方法 完成SQL的执行 update中其他可用的SQL语句：insert
                // into/update/delete
                qr.update(sql);

            } catch (SQLException e) {
                e.printStackTrace();
            }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
                String sql = "update blog set blog_title=? , blog_content=? where blog_id=?";
                String params[] = {title, content, id};
                QueryRunner qr = DbHelper.getQueryRunner();

                result = qr.update(sql, params);

                String message = "";
                if (result == 1) {
                    message = "添加成功";
                } else {
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
        params[19] = updatedAt;
        allParams.add(params);
      }
      runner.batch(writeConnection, SQL_INSERT_ISSUE, allParams.toArray(new Object[allParams.size()][]));
      insertComments(writeConnection, allComments);
      runner.update(writeConnection, SQL_DELETE_RULE_FAILURES, violationIds);
      writeConnection.commit();
      progress.increment(rows.size());

    } finally {
      DbUtils.closeQuietly(readConnection);
View Full Code Here
799
800
801
802
803
804
805
806
807
808
809
   */
  protected int execute(String sql, Object[] args) throws DataAccessException {
    QueryRunner qr = getQueryRunner();
    logger.debug("Update SQL:{}", sql);
    try {
      return qr.update(sql, pearParams(args));
    } catch (SQLException e) {
      throw new DataAccessException("update sql error! sql:" + sql + ";", e);
    }
  }

View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
    String params[] = { name, level };
    QueryRunner qr = DbHelper.getQueryRunner();
    int result = 0;
    String message = "";
    try {
      result = qr.update(sql, params);
    } catch (SQLException e) {

      e.printStackTrace();
    }
    if (result == 1) {
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.