jsp测试mysql连接

<%@ page import="java.sql.*" %>
<html>
<head>
    <title>MySQL Connection Test</title>
</head>
<body>
<h2>Testing MySQL Connection</h2>
<%
    Connection conn = null;
    try {
        // 加载JDBC驱动
        Class.forName("com.mysql.jdbc.Driver");
        
        // 建立连接
        String url = "jdbc:mysql://localhost:3306/your_database";
        String user = "your_username";
        String password = "your_password";
        conn = DriverManager.getConnection(url, user, password);
        
        out.println("Connection successful!");
    } catch (ClassNotFoundException e) {
        out.println("JDBC Driver not found: " + e.getMessage());
    } catch (SQLException e) {
        out.println("Connection failed: " + e.getMessage());
    } finally {
        // 关闭连接
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                out.println("Failed to close connection: " + e.getMessage());
            }
        }
    }
%>
</body>
</html>