jsp连接mysql数据库三个表

<%@ page import="java.sql.*" %>
<%@ page import="com.mysql.jdbc.Driver" %>

String url = "jdbc:mysql://localhost:3306/your_database_name";
String username = "your_username";
String password = "your_password";

try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
    e.printStackTrace();
}

try {
    Statement stmt = conn.createStatement();
    String query = "SELECT * FROM table1, table2, table3 WHERE table1.id = table2.id AND table2.id = table3.id";
    ResultSet rs = stmt.executeQuery(query);
    
    while (rs.next()) {
        // 处理查询结果
        // rs.getString("column_name") 获取列值
    }
    
    rs.close();
    stmt.close();
} catch (Exception e) {
    e.printStackTrace();
}

conn.close();