jsp连接mysql步骤

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>

db.url=jdbc:mysql://localhost:3306/yourdatabase
db.username=yourusername
db.password=yourpassword

<%@ page import="java.sql.*" %>
<%@ page import="java.util.Properties" %>
<%@ page import="java.io.InputStream" %>

<%
    Connection conn = null;
    try {
        // 加载数据库配置文件
        Properties props = new Properties();
        InputStream in = getClass().getResourceAsStream("/db.properties");
        props.load(in);
        in.close();

        // 获取数据库连接信息
        String url = props.getProperty("db.url");
        String username = props.getProperty("db.username");
        String password = props.getProperty("db.password");

        // 加载MySQL驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 建立数据库连接
        conn = DriverManager.getConnection(url, username, password);

        // 连接成功后的操作
        out.println("数据库连接成功！");
    } catch (ClassNotFoundException e) {
        out.println("MySQL驱动加载失败：" + e.getMessage());
    } catch (SQLException e) {
        out.println("数据库连接失败：" + e.getMessage());
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                out.println("关闭数据库连接失败：" + e.getMessage());
            }
        }
    }
%>