jsp登录连接mysql数据库代码

<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>

<%
// 建立数据库连接
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
    // 获取数据库连接池
    Context ctx = new InitialContext();
    DataSource ds = (DataSource) ctx.lookup("jdbc/MySQLDataSource"); // 数据库连接池的JNDI名称

    // 从连接池获取连接
    conn = ds.getConnection();

    // 创建查询语句
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    String sql = "SELECT * FROM users WHERE username='" + username + "' AND password='" + password + "'";

    // 执行查询
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);

    // 处理查询结果
    if (rs.next()) {
        // 登录成功
        out.println("登录成功！");
    } else {
        // 登录失败
        out.println("用户名或密码错误！");
    }
} catch (Exception e) {
    e.printStackTrace();
} finally {
    // 关闭数据库连接
    try {
        if (rs != null) {
            rs.close();
        }
        if (stmt != null) {
            stmt.close();
        }
        if (conn != null) {
            conn.close();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
%>