在jsp中使用数据库MySQL

<%@ page import="java.sql.*" %>
<%
    // 加载数据库驱动
    Class.forName("com.mysql.jdbc.Driver");
%>

<%
    // 建立数据库连接
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";
    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()) {
        // 获取每行数据的字段值并进行处理
        String column1 = rs.getString("column1");
        String column2 = rs.getString("column2");
        
        // 输出字段值
        out.println("Column1: " + column1 + ", Column2: " + column2);
    }
    
    // 关闭结果集和数据库连接
    rs.close();
    stmt.close();
    conn.close();
%>

<%
    conn.close();
%>