Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/ly_blog";
String username = "root";
String password = "root";
conn = DriverManager.getConnection(url, username, password);
String sql = "insert into blog(title,category_id,context,created_time) values(?,?,?,now())";
String[] params = {title, category, content};
QueryRunner qr = new QueryRunner();
result = qr.update(conn, sql, params);new QueryRunner()的时候没有用到DataSource。
改成这样也是不行。
result = qr.update(sql, conn, params);
String url = "jdbc:mysql://localhost/ly_blog"; URL 端口呢? 1433?
是dbutils的问题。
result 已经初始化。
异常已经捕获
写错了
现在的问题是处在dbutils这里
包也已经引入了。
error message:
java.lang.NoClassDefFoundError: org/apache/commons/dbutils/QueryRunner
at com.ly.blog.BlogServlet.doPost(BlogServlet.java:41)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
package com.ly.blog;import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.commons.dbutils.QueryRunner;public class BlogServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
} public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String title = request.getParameter("title");
String category = request.getParameter("category");
String content = request.getParameter("content"); Connection conn = null;
int result = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/ly_blog";
String username = "root";
String password = "root";
conn = DriverManager.getConnection(url, username, password);
String sql = "insert into blog(title,category_id,context,created_time) values(?,?,?,now())";
String[] params = {title, category, content};
QueryRunner qr = new QueryRunner();
result = qr.update(sql, conn, params);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
String message = "";
if(result == 1) {
message = "博文添加成功";
}else {
message = "博文添加不成功";
}
request.setAttribute("message", message);
request.getRequestDispatcher("/addBlogResult.jsp").forward(request, response);
}
}
有这个包? 这个包的问题吧。