思路：1、创建db连接 2、创建statement 3、执行查询 4、遍历结果并展示
完整代码如下：
<span style="font-size:12px"><span style="font-size:14px"><%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/htmlcharset=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:24pxcolor: rgb(255, 0, 0)">
</span></span>
<%//JSP页面直接访问数据库
Connection conn = null
Statement stmt = null
ResultSet rs = null
try{
Class.forName("JDBC驱动")
conn = DriverManager.getConnection("url", "username", "password")
stmt = conn.createStatement()
rs = stmt.executeQuery("select factor, ratio from 表名 where id=1")
while(rs.next()){
String factor = rs.getString("factor")
String ratio = rs.getString("ratio")
%>
factor :<%=factor %>
ratio :<%=ratio %>
<%
}
}catch(Exception e){
e.printStackTrace()
}finally{
try{
if(rs != null) rs.close()
if(stmt != null) stmt.close()
if(conn != null) conn.close()
}catch(Exception e1){
e1.printStackTrace()
}
}
%>
修改 驱动、url、username、password、表名、字段名成你应用的相应数据，然后将这些代码加入到你的jsp页面，就可以在jsp页面直接读取到数据库中的对应表指定字段的数据了，祝你好运！
JSP页面中用c标签遍历list，要显示数据的对象列表放到list中。
java代码：
request.setAttribute("list", yourList)jsp代码：
<c:forEach var="user" items="${list}">User Name: ${user.username}<br/>
Age: ${user.age}
</c:forEach>
注意在JSP中引入jstl的core标签，如果实在不清楚，继续追问
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）