📄 listinfo.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>订单信息</title>
<style type="text/css">
<!--
body {
background-color: #B9DAF9;
}
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String userid = (String) session.getAttribute("userid");
if (userid == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
Integer level = (Integer) session.getAttribute("level");
int l = level.intValue();
if (level == null)
response.sendRedirect("../index.jsp?error=2");
if (!(l == 2))
response.sendRedirect("../error.jsp");
%>
<%
String sql = null;
String sql2 = null;
String sql3 = null;
java.sql.ResultSet rs = null;
java.sql.ResultSet rs2 = null;
java.sql.ResultSet rs3 = null;
%>
<%
sql = "select * from List";
try {
rs = myRs.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
}
%>
<%
sql2 = "select c.classname from List l,class c where c.classid=l.classid";
try {
rs2 = myRs.executeQuery(sql2);
} catch (Exception e) {
e.printStackTrace();
}
%>
<%
sql3 = "select b.bookname from List l,book b where b.bookid=l.bookid";
try {
rs3 = myRs.executeQuery(sql3);
} catch (Exception e) {
e.printStackTrace();
}
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" border="0" background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" height="160" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListInfo.jsp">定单信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">定单号查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">按班级查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListQuery.jsp">按图书名查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListDel.jsp">删除已有定单</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="ListAdd.jsp">增加新的定单</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<%
out.println("<table align=\"center\" border=\"1\" width=\"800\">");
out
.println("<tr><td>编号<td>班级编号<td>班级名称<td>班级人数<td>图书编号<td>图书名称<td>售价<td>已定货数</tr>");
while (rs.next()&rs2.next()&rs3.next()) {
out.println("<tr><td><a href=\"List.jsp?listid="
+ rs.getString("listid") + "\">"
+ rs.getString("listid") + "</a><td>"
+ rs.getString("classid") + "<td>"
+ rs2.getString("classname") + "<td>"
+ rs.getInt("menbers") + "<td>"
+ rs.getString("bookid") + "<td>"
+ rs3.getString("bookname") + "<td>"
+ rs.getFloat("price") + "<td>" + rs.getInt("Lnumber")
+ "</tr>");
}
out.println("</table>");
while(rs3.next())
{
out.println(rs3.getString("bookname"));
out.println("<p>");
}
%>
<%
if(!rs2.next())//由于上面rs2.next()已经到达记录集的底部为空
out.println("rs2:null!!!!!!!!!!!!!");
%>
<%
if(!rs3.next())//由于上面rs3.next()已经到达记录集的底部为空
out.println("rs3:null!!!!!!!!!!!!!");
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -