上一话题 | 下一话题 使用DbUtils执行sql不能带有引号的参数如何解决?

代码: // 带单引号的字符串，插入到数据库中
  String sql = "INSERT INTO Test(testException) VALUES ('0')";

  QueryRunner qr = DBHelper.getQueryRunner();
  try {
   qr.update(sql);
  } catch (SQLException e) {
   e.printStackTrace();
  }

异常:

java.sql.SQLException: Duplicate entry '0' for key 'PRIMARY' Query: INSERT INTO Test(testException) VALUES ('0') Parameters: []
 at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:655)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:620)
 at com.v512.blog.Test.doGet(Test.java:23)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:619)