📄 seecheck.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="shop.logBean"%>
<%@ page import="java.sql.*"%>
<%!
public String codeString(String s){
String str=s;
try{
byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}catch(Exception e){return str;}
}
%>
<body bgcolor=#C0C0C0>
<%
if(session.isNew()){
%>
<jsp:forward page="index.jsp"/>
<%
}
else{
%>
<jsp:useBean id="log" class="shop.logBean" scope="session"/>
<%
String islog=log.getIslog();
if(!islog.equals("true")||!log.getId().equals("admini")){
%>
<jsp:forward page="index.jsp"/>
<%
}
else{
%>
<center>
<jsp:getProperty name="log" property="id"/>
,查看销售记录页面
<jsp:include page="adminihead.txt"/>
</center>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con;
Statement sql;
ResultSet rs;
String goodid="";
String time="";
String goodname="";
String userid="";
String amount="";
String price="";
String checkout="";
String checkway="";
float allcheckout=0;
con=DriverManager.getConnection("jdbc:odbc:myshop","","");
sql=con.createStatement();
String condition="SELECT * FROM check ";
rs=sql.executeQuery(condition);
int rowcount=0;
%>
<center>
<table width="800" bgcolor="#C0C0C0" >
<tr>
<td ><table border="1" width="800" height="30">
<td width="300" valign="middle" align="center">时间</td>
<td width="100" valign="middle" align="center">商品名</td>
<td width="100" valign="middle" align="center">商品号</td>
<td width="50" valign="middle" align="center">商品价</td>
<td width="50" valign="middle" align="center">数量</td>
<td width="100" valign="middle" align="center">客户</td>
<td width="50" valign="middle" align="center">成交额</td>
<td width="50" valign="middle" align="center">贸易方式</td>
</table></td>
</tr>
<%
while(rs.next()){
rowcount++;
time=rs.getString("time");
goodid=rs.getString("goodid");
goodname=rs.getString("goodname");
price=rs.getString("price");
amount=rs.getString("amount");
checkout=rs.getString("checkout");
checkway=rs.getString("checkway");
userid=rs.getString("userid");
allcheckout+=Float.valueOf(checkout).floatValue();
if(checkway.equals("0")){
checkway="邮寄";
}else{
checkway="信用卡";
}
%>
<tr>
<td ><table border="1" width="800" height="30">
<td width="300" valign="middle" align="center"><%=time%></td>
<td width="100" valign="middle" align="center"><%=goodname%></td>
<td width="100" valign="middle" align="center"><%=goodid%></td>
<td width="50" valign="middle" align="center"><%=price%></td>
<td width="50" valign="middle" align="center"><%=amount%></td>
<td width="100" valign="middle" align="center"><%=userid%></td>
<td width="50" valign="middle" align="center"><%=checkout%></td>
<td width="50" valign="middle" align="center"><%=checkway%></td>
</table></td>
</tr>
<%
}
%>
</table>
总成交额：<%=allcheckout%>
</center>
<%
con.close();
}catch(SQLException e){
%>
<jsp:forward page="index.jsp"/>
<%
}catch(ClassNotFoundException e){
%>
<jsp:forward page="index.jsp"/>
<%
}
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -