是这样的,我在一个JSP页面有四个表格,数据库有4张不同的表,现在我想把数据库四张表的内容分别显示在JSP页面的四个表格里面,具体怎么做,请说细点。谢谢!
JSPé¡µé¢ æ¾ç¤ºæ°æ®åºä¸å表çå 容ï¼éè¦æä¸å表çæ°æ®åå«å°è£ å°listä¸ã
<span style="font-size:12px;"><span style="font-size:14px;"><%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<style type="text/css">
table {
border: 2px #CCCCCC solid;
width: 360px;
}
td,th {
height: 30px;
border: #CCCCCC 1px solid;
}
</style>
</head>
<body>
<%
//驱å¨ç¨åºå
String driverName = "com.mysql.jdbc.Driver";
//æ°æ®åºç¨æ·å
String userName = "root";
//å¯ç
String userPasswd = "szy";
//æ°æ®åºå
String dbName = "studentmanage";
//表å
String tableName = "student";
//èç»å符串
String url = "jdbc:mysql://localhost:3306/" + dbName + "?user="
+ userName + "&password=" + userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql = "SELECT * FROM " + tableName;
ResultSet rs = statement.executeQuery(sql);
%>
<br>
<br>
<table align="center">
<tr>
<th>
<%
out.print("å¦å·");
%>
</th>
<th>
<%
out.print("å§å");
%>
</th>
<th>
<%
out.print("ä¸ä¸");
%>
</th>
<th>
<%
out.print("ç级");
%>
</th>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td>
<%
out.print(rs.getString(1));
%>
</td>
<td>
<%
out.print(rs.getString(2));
%>
</td>
<td>
<%
out.print(rs.getString(3));
%>
</td>
<td>
<%
out.print(rs.getString(4));
%>
</td>
</tr>
<%
}
%>
</table>
<div align="center">
<br> <br> <br>
<%
out.print("æ°æ®æ¥è¯¢æåï¼æåä½ ");
%>
</div>
<%
rs.close();
statement.close();
connection.close();
%>
</body>
</html></span><span style="font-size:24px;color: rgb(255, 0, 0);">
</span></span>
å±ç¤ºç»æå¦ä¸ï¼