我正在编写Servlet使用mysqlconnector
Java与mysql
数据库连接,但是它给出了错误
java.lang.classnotfoundexception:com.mysql.jdbc.driver
我使用与MySQL连接的相同驱动程序相同的java
尝试过,并且查询也在运行,但使用Servlet无法正常工作。
我的代码适用于servlet
是:
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class RegisterServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String n = request.getParameter("userName");
String p = request.getParameter("password");
String e = request.getParameter("email");
String c = request.getParameter("course");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/phpmyadmin/saiiff","root", "");
PreparedStatement ps = conn
.prepareStatement("insert into eemeze values(?,?,?,?)");
ps.setString(1, n);
ps.setString(2, p);
ps.setString(3, e);
ps.setString(4, c);
int i = ps.executeUpdate();
if (i > 0)
out.print("You are successfully registered...");
} catch (Exception e2) {
System.out.println(e2);
}
out.close();
}
}
- 从http://www.java2s.com/code/jardownload/com.mysql/com.mysql.jdbc_5.1.5.1.5.5.5.jar.zip 下载mysql jar
- 并建立在classPath上