JDBC连接数据库问题!求助!!!帮帮忙!
public class addServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int id= new Integer (request.getParameter("id"));
String name=request.getParameter("name");
System.out.println(id+"`"+name);
studen student =new studen() ;
student .setId(id);
student. setName(name);
String sql="insert into mystudent values (?,?) ";
DBUtil dbUtil =new DBUtil() ;
Connection connection =dbUtil .getConnection();
try {
System.out.println("444!");
PreparedStatement preparedStatement =connection .prepareStatement(sql);
System.out.println("555!");
preparedStatement .setInt(1,student.getId() );
System.out.println("666!");
preparedStatement .setString(2,student.getName());
System.out.println("777!");
preparedStatement.executeUpdate();
System.out.println("888!");
} catch (SQLException e) {
e.printStackTrace();
}finally {
dbUtil .close(connection ) ;
}
我如果把这段代码的方法放在主函数main里面就可以执行成功但是放在servlet里面就不行啊
执行结果就是输出“444!”下面的PreparedStatement preparedStatement =connection .prepareStatement(sql);就执行出错啊
这是输出的结果:
444!
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1309)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1138)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at servlets.DBUtil.getConnection(DBUtil.java:11)
at servlets.addServlet.doPost(addServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)