jsp连接mysql数据库教程

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        Statement stmt = conn.createStatement();
        String sql = "SELECT * FROM your_table_name";
        ResultSet rs = stmt.executeQuery(sql);
        while (rs.next()) {
            out.println(rs.getString("column_name"));
        }
        rs.close();
        stmt.close();
        conn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
%>