jsp连接mysql数据库的语句怎么写

<!-- pom.xml -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.23</version>
</dependency>

<%@ page import="java.sql.*" %>
<%
    // 数据库连接参数
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

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

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

        // 创建Statement对象
        stmt = conn.createStatement();

        // 执行查询
        String sql = "SELECT * FROM your_table_name";
        rs = stmt.executeQuery(sql);

        // 处理结果集
        while (rs.next()) {
            out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name") + "<br>");
        }
    } catch (ClassNotFoundException e) {
        out.println("JDBC驱动加载失败: " + e.getMessage());
    } catch (SQLException e) {
        out.println("数据库操作失败: " + e.getMessage());
    } finally {
        // 关闭资源
        try {
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            out.println("关闭资源失败: " + e.getMessage());
        }
    }
%>