利用SQL Server查詢數據，并把所有數據顯示在頁面上。
<%@ 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>新聞熱點
疑難解答
