纯java方式链接数据库并在jsp显示
时间: 2023-06-12 20:06:46 浏览: 64
这里提供一个简单的纯Java方式链接MySQL数据库并在JSP中显示数据的示例代码。
1. 首先,需要下载MySQL JDBC驱动程序,并将其添加到项目中。
2. 在Java中编写一个数据库连接类,例如:
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
private static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase";
private static final String DB_USERNAME = "username";
private static final String DB_PASSWORD = "password";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(DB_DRIVER);
conn = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return conn;
}
}
```
3. 在JSP页面中,使用Java代码从数据库中检索数据并显示它们,例如:
```jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Display Data</title>
</head>
<body>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
</tr>
<%
Connection conn = DBConnection.getConnection();
PreparedStatement pstmt = null;
ResultSet rs = null;
String query = "SELECT * FROM users";
try {
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getInt("id") + "</td>");
out.println("<td>" + rs.getString("name") + "</td>");
out.println("<td>" + rs.getString("email") + "</td>");
out.println("</tr>");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>
</table>
</body>
</html>
```
这个例子演示了如何在JSP页面中使用Java代码连接到MySQL数据库,从中检索数据并在页面上显示它们。需要注意的是,这个例子只是一个简单的示例,实际应用中需要更加完善的错误处理和安全措施。