📄 list.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import = "java.util.*" %>
<%@ page import = "java.sql.*" %>
<jsp:useBean id="db" scope="page" class="Db.Db" />
<html>
<head>
<title>订单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<%
Boolean IsAdmin=(Boolean)session.getValue("IAmAdin");
boolean isAdmin=false;
if(IsAdmin!=null){
isAdmin=IsAdmin.booleanValue();
}
if(!isAdmin)response.sendRedirect("main.html");
%>
<body bgcolor="#FFFFFF" text="#000000">
<h2>订单列表</h2>
<%
String SQL="SELECT * FROM client";
ResultSet rscb;
ResultSet rsc=db.execQ(SQL);
if(rsc==null)return ;
out.println("<table border=1>");
out.println("<tr>");
out.println("<td>");
out.println("<b>顾客号</b>");
out.println("</td>");
out.println("<td>");
out.println("<b>顾客信息</b>");
out.println("</td>");
out.println("<td>");
out.println("<b>金额</b>");
out.println("</td>");
out.println("</tr>");
while(rsc.next()){
long clientid=rsc.getLong("id");
out.println("<tr>");
out.println("<td>");
out.println("<a href=list_detail.jsp?clientid="+clientid+">");
out.println(clientid);
out.println("</a>");
out.println("</td>");
out.println("<td>");
out.println("姓名："+rsc.getString("name")+"  ");
out.println("住址："+rsc.getString("addr")+"  ");
out.println("电话："+rsc.getString("phone")+"  ");
out.println("</td>");
out.println("<td>");
out.println(rsc.getFloat("amount")+"元  </b>");
out.println("</td>");
out.println("</tr>");
} //while rsc
out.println("</table>");
%>
<br>
<br>
<br>
<a href="javascript:history.go(-1)">返回</a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -