?? main.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>旭陽圖書在線</title>
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>
<body >
<center><font size=2 color='#B8D85A'>
<br><b>旭陽圖書在線</b><br>
<br><b>圖書信息一覽表</b><br>
</font></center><p>
<%
//獲取登錄用戶信息
String username=(String)session.getAttribute("username");
String rights=(String)session.getAttribute("rights");
String currentDateTime=(String)session.getAttribute("loginDateTime");
String loginIP=(String)session.getAttribute("loginIP");
%>
<a href="javascript:this.location.reload()"><font size=2 color='blue'>刷新</font></a> <a href="main.jsp"><font size=2 color='blue'>主頁></font></a>
<div align="center"><font size=2 color='#FF6600'></font></div>
<table width="700" border="0" bgcolor="#FFFFFF" cellspacing="0" align="center">
<tr style='font-size:9pt;color:white' bgcolor='#3366CC' align='center'>
<td></td>
<td><b>用戶登錄信息</b></td>
<td></td>
<td></td>
</tr>
<tr style='font-size:9pt;color:#FFFF00' bgcolor='#3366CC' align='center'>
<td><b>用戶名：<%=username%></b></td>
<td><b>用戶權限：<%=rights%></b></td>
<td><b>登錄日期：<%=currentDateTime%></b></td>
<td><b>用戶IP：<%=loginIP%></b></td>
</tr>
</table>
<table width="700" bgcolor="#ffffff" class="style1" border="1" align="center" width="100%" cellpadding="0" cellspacing="0" bordercolorlight="#5E9BF7" bordercolordark="#FFFFFF">
<tr bgcolor="#CCCCCC" class="style3" align="center">
<td height="25"><b>書號</b></td>
<td><b>書名</b></td>
<td><b>作者</b></td>
<td><b>出版社</b></td>
<td><b>出版日期</b></td>
<td><b>價格</b></td>
</tr>
<%
myapp.DBConnection dbConnection=new myapp.DBConnection();//獲取數據庫訪問對象DBConnection實例dbConnection
dbConnection.getConnection();//調用DBConnection數據庫連接方法
String sql="select isbn,title,author,publish,PublishDate,price from book";
ResultSet rs=dbConnection.selectRecord(sql);//調用DBConnection數據查詢方法
while (rs.next()){
%>
<tr bgcolor="#ffffff" class="style1" align="left">
<td><%=rs.getString("isbn")%></td>
<td><%=rs.getString("isbn")%></td>
<td><%=rs.getString("author")%></td>
<td><%=rs.getString("publish")%></td>
<td><%=rs.getString("PublishDate")%></td>
<td align="right"><%=rs.getFloat("price")%></td>
</tr>
<%}
dbConnection.closeConn();//調用DBConnection關閉數據庫連接方法
%>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -