如何将MySQL与JSP项目关联？JSP网页连接MySQL服务器遇阻求助

Hey there! Let's figure out why your JSP web app isn't connecting to MySQL when your standalone app works. I've debugged this exact issue dozens of times, so let's break it down step by step:

In standalone apps, you probably included the MySQL JDBC driver jar directly in your project—but JSP web apps have a specific place for this:

• Download the correct mysql-connector-java.jar (match your MySQL version: use 8.x for MySQL 8+, 5.x for older versions)
• Drop it into your web app's WEB-INF/lib folder. If this folder doesn't exist, create it.
• Pro tip: For MySQL 8.x, the driver class name changed to com.mysql.cj.jdbc.Driver (old 5.x uses com.mysql.jdbc.Driver—mixing these up causes silent failures).

Let's rule out connection issues first. Add this snippet to a test JSP file (e.g., test-connection.jsp) to verify connectivity:

<%@ page import="java.sql.*" %>
<%
    String dbUrl = "jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC";
    String dbUser = "your_mysql_username";
    String dbPass = "your_mysql_password";

    try {
        // Load driver (required for older JDBC versions, still safe for new ones)
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPass);
        
        out.println("<h3>Success! Connected to MySQL.</h3>");
        // Always close connections to avoid leaks
        conn.close();
    } catch (Exception e) {
        e.printStackTrace();
        out.println("<h3>Connection failed: " + e.getMessage() + "</h3>");
    }
%>

• Note: For MySQL 8.x, the serverTimezone parameter in the URL is mandatory—omitting it throws a timezone error.

Looking at your index.jsp snippet, your form has two critical issues that will break data submission:

• Input fields lack name attributes (you can't retrieve values in SignUp.jsp without them)
• The button's onclick is unnecessary and misnamed.

Update your form like this:

<div class="login-page">
    <div class="form">
        <form class="login-form" action="SignUp.jsp" method="POST">
            <input type="text" name="username" placeholder="username"/>
            <input type="password" name="password" placeholder="password"/>
            <button type="submit">Login</button>
            <p class="message">Not registered? <a href="register.jsp">Create an account</a></p>
        </form>
    </div>
</div>

Now in SignUp.jsp, you can fetch the values with request.getParameter("username") and request.getParameter("password").

While you can write DB code directly in JSP, it's bad practice. Instead:

• Move database logic to a Servlet or a separate utility class
• Store DB credentials in web.xml (instead of hardcoding) for easier maintenance:

  <!-- Add this to WEB-INF/web.xml -->
  <context-param>
      <param-name>dbUrl</param-name>
      <param-value>jdbc:mysql://localhost:3306/your_db?useSSL=false&serverTimezone=UTC</param-value>
  </context-param>
  <context-param>
      <param-name>dbUser</param-name>
      <param-value>root</param-value>
  </context-param>
  <context-param>
      <param-name>dbPassword</param-name>
      <param-value>your_password</param-value>
  </context-param>
  

  Then retrieve them in your code with:

  String url = getServletContext().getInitParameter("dbUrl");
  String user = getServletContext().getInitParameter("dbUser");
  String pass = getServletContext().getInitParameter("dbPassword");
  

Make sure your MySQL user has permission to connect from localhost (Tomcat runs locally):
Run this in MySQL shell:

GRANT ALL PRIVILEGES ON your_database.* TO 'your_user'@'localhost' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;

Start with step 1 and work your way down—9 times out of 10, the missing driver jar is the problem. Let me know if you hit any specific error messages!

内容的提问来源于stack exchange，提问作者AneeshCRao