用SQL Server查询所有数据并显示
时间：2021-07-01 10:21:17
帮助过：5人阅读
@ page language
="java" import
="java.util.
*" pageEncoding
="utf
-8"
%>
<%@page import
="jdbc.sqlServer"
%>
<%@page import
="java.sql.Connection"
%>
<%@page import
="java.sql.Statement"
%>
<%@page import
="java.sql.ResultSet"
%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()
+":
//"
+request.getServerName()
+":"
+request.getServerPort()
+path
+"
/";
%>
<!DOCTYPE HTML
PUBLIC "
-//W3C
//DTD HTML
4.01 Transitional
//EN"
>
<html
>
<head
>
<base href
="
<%=basePath
%>"
>
<title
>My JSP
‘LinDao.jsp‘ starting page
</title
>
<meta http
-equiv
="pragma" content
="no
-cache"
>
<meta http
-equiv
="cache
-control" content
="no
-cache"
>
<meta http
-equiv
="expires" content
="
0"
>
<meta http
-equiv
="keywords" content
="keyword1,keyword2,keyword3"
>
<meta http
-equiv
="description" content
="This
is my page"
>
<!
--
<link rel
="stylesheet" type
="
text/css" href
="styles.css"
>
-->
</head
>
<body
>
<!
-- 查询管理员信息 -->
<div
>
<table border
=1px style
="width:500px;height:200px;
text-align:center;margin:
0 auto;margin
-top:0px"
>
<div style
="width:500px;height:40px;border:1px solid red;margin:
0 auto;
text-align:center;margin
-top:60px;background:#fff;margin
-top:
-2px"
>
<font color
="red" font
-weight
="bold"
>管理员信息
</font
>
</div
>
<tr style
="background:red"
>
<td
>编号
</td
>
<td
>姓名
</td
>
<td
>元宝数
</td
>
<td
>删除
</td
>
</tr
>
<%
//引用连接数据库方法
sqlServer sq1=new sqlServer();
//得到数据库连接
Connection con1 = sq1.getConnection();
//编写sql语句
String sql1="
select * from Admin";
//得到数据库对象操作
Statement st1=con1.createStatement();
// 得到查询的结果
ResultSet rs1 = st1.executeQuery(sql1);
while(rs1.
next()){
%> <tr
>
<td
> <%out.
print(rs1.getInt(
1)
+ "\t");
%></td
>
<td
> <%out.
print(rs1.getString(
2)
+ "\t");
%></td
>
<td
> <%out.println(rs1.getInt(
3)
+ "\t");
%></td
>
<td
> <a href
="time.jsp?id
=<%out.
print(rs1.getInt(
1)
+ "\t");
%>"
>删除
</a
></td
>
</tr
><%
}
//释放资源
sq1.ShiFang(rs1,st1,con1);
%>
</table>
</div
>
</body
>
</html
>
用SQL Server查询所有数据并显示
标签：
