JDBC：MySql连接在Ajax请求-Java中不起作用

I have exactly same function in both Main method and other method JDBC connection is working fine. If I call the other function it throws error java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/wine:

我在Main方法和其他方法中具有完全相同的功能JDBC连接工作正常。如果我调用另一个函数它会抛出错误java.sql.SQLException:没有为jdbc找到合适的驱动程序:mysql:// localhost:3306 / wine:

I have included MySql Driver in library [Netbeans];

我在库[Netbeans]中包含了MySql Driver;

processRequest method:

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    String process = (String) request.getParameter("process");
    String name = (String) request.getParameter("process");
    String phone=(String) request.getParameter("phone");
    String email = (String) request.getParameter("email");
    String pwd = (String) request.getParameter("pwd");
    PrintWriter out = response.getWriter();
    out.println("Hello");
   signup(out,process,name,email,phone,pwd);

}

signup method:

private static int signup(PrintWriter out,String process,String name,String email,String phone,String pwd){
    Connection con = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    try {
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/wine", "root", "");


        out.println("Process Not Found");
        if (process == "signup") {

            String query = "INSERT INTO user(name,phone,email,password,role) VALUES(?,?,?,?,1)";
            stmt = con.prepareStatement(query);
            stmt.setString(1, name);
            stmt.setString(2, phone);
            stmt.setString(3, email);
            stmt.setString(4, pwd);

            stmt.execute();

        } else {
            out.println("Process Not Found");
        }
    } catch (SQLException e) {
        // do something appropriate with the exception, *at least*:

        out.println(e);
        e.printStackTrace();
        return 0;
    }
    return 1;
}

Main Method :

主要方法:

public static void main(String[] args) {

    Connection con = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    String process = "signup";
    String name = "Test";
    String phone="45885";
    String email = "Test@gmail.com";
    String pwd = "dkjsdh";

    try {
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/wine", "root", "");



        if (process == "signup") {

            String query = "INSERT INTO user(name,phone,email,password,role,status) VALUES(?,?,?,?,1,1)";
            stmt = con.prepareStatement(query);
            stmt.setString(1, name);
            stmt.setString(2, phone);
            stmt.setString(3, email);
            stmt.setString(4, pwd);

            stmt.execute();

        } else {
            System.out.println("Process Not Found");
        }
    } catch (SQLException e) {
        // do something appropriate with the exception, *at least*:

        System.out.println(e);
        e.printStackTrace();
    }
}

1 个解决方案

#1

There are two options that can be tried:

有两种选择可以尝试:

Class.forName("com.mysql.jdbc.Driver").newInstance() //older bug

and

Class.forName("com.mysql.jdbc.Driver");

In the comment I pasted the older bug solution when I meant to paste the second one.

在评论中,当我打算粘贴第二个时,我粘贴了旧的bug解决方案。

Either way I am glad that it worked out for you

无论哪种方式,我很高兴它为你效果

#1