jsp连接mysql数据库代码

以下是一个简单的 JSP 连接 MySQL 数据库的示例代码：

<%@ page import="java.sql.*" %>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
// 连接 MySQL 数据库
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "123456";
conn = DriverManager.getConnection(url, username, password);

// 执行 SQL 查询语句
String sql = "SELECT * FROM mytable";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);

// 处理查询结果
while (rs.next()) {
String id = rs.getString("id");
String name = rs.getString("name");
out.println("id: " + id + ", name: " + name);
}
} catch (Exception e) {
out.println("Error: " + e.getMessage());
} finally {
// 关闭数据库连接
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
%>