📄 statistic.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="java.util.Date" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 {
color: #660000;
font-family: "幼圆";
}
.style3 {
font-size: 14px;
font-family: "幼圆";
color: #660000;
}
.style8 {font-size: 12px; color: #006633; }
.style10 {font-size: 14px; color: #660033; }
.style11 {font-size: 14px}
.style12 {
font-size: 14;
color: #660000;
}
.style14 {font-size: 12px; color: #003300; }
.style15 {font-size: 12px; color: #660000; }
-->
</style>
</head>
<%! //处理字符串的常用方法
public String getString(String s) {
if(s == null) s = "";
try{
byte a[] = s.getBytes("ISO-8859-1");
s = new String(a);
}
catch(Exception e) {}
return s;
}
%>
<% //获取session值，以及防止非法访问本页面
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
%>
<body bgcolor="#FFFFFF" >
<table width="768" height="353" border="1" align="center">
<tr>
<td height="105" colspan="2">
<table width="100%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="620"><img src="images/_r3_c4.gif" width="85" height="86" align="absmiddle"> <span class="style1">您的位置：>> 花坊管理系统</span></td>
</tr>
</table></td>
</tr>
<tr>
<td height="22" colspan="2"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr align="left" bgcolor="#ECE9D8">
<td height="30"><span class="style2"> 淳.清凉花坊感谢您今天的辛勤工作......</span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="114" height="159" rowspan="2"><p class="style3">鲜花管理</p>
<p class="style3"><a href="main.jsp">花坊首页 </a></p>
<p class="style3"><a href="admin_order.jsp">订单列表</a></p>
<p class="style3"><a href="statistic.jsp">销售统计</a></p></td>
<form name="form1" method="post" action="">
<td width="638" height="25"> <p>生成
<select name="year1" size="1">
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select>
年
<select name="month1" size="1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>月的销售统计<input name="submit" type="submit" value="提交">
</p>
</form>
</tr>
<%
String year1=request.getParameter("year1");
year1=getString(year1);
if(year1==null)
{year1="";}
//out.print(year1);
String month1=request.getParameter("month1");
month1=getString(month1);
if(month1==null)
{month1=""; }
// out.print(month1);
String date1=year1+month1;
//out.print(date1);
%>
<% Calendar calendar=Calendar.getInstance();
calendar.setTime(new Date());
String year=String.valueOf(calendar.get(Calendar.YEAR)),
month=String.valueOf(calendar.get(Calendar.MONTH)+1),
day=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH));
int hour=calendar.get(Calendar.HOUR_OF_DAY),
minute=calendar.get(Calendar.MINUTE),
second=calendar.get(Calendar.SECOND);
String date2=year+month;
//int date11 =Integer.parseInt(date1);
//int date22 =Integer.parseInt(date2);
if(date1.compareTo(date2)>0){
%>
<script language="javascript">
alert("输入日期有错！");
history.go(-1);
</script>
<%
}
else
{
%>
<tr>
<td><table width="561" border="1">
<tr>
<td width="67"><div align="center">鲜花ID</div></td>
<td width="80"><div align="center">订购量</div></td>
<td width="61"><div align="center">订单ID</div></td>
<td width="90"><div align="center">订单状态</div></td>
<td width="113"><div align="center">支付状态</div></td>
<td width="110"><div align="center">付款方式</div></td>
</tr>
<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
ResultSet rs1=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { }
try { // int total1=0;
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM orderinfo where orderid like"+"'"+date1+"%"+"'");
while(rs.next()){
String oid=rs.getString(1);
String status=rs.getString("status");
String paytype=rs.getString("paytype");
String paid=rs.getString("paid");
rs1=sql.executeQuery("select * from orderdetail where orderid ="+"'"+oid+"'");
while(rs1.next()){
String bid=rs1.getString(2);
int num=rs1.getInt(3);
%>
<tr>
<td><div align="center"><%=bid%></div></td>
<td><div align="center"><%=num%></div></td>
<td><div align="center"><%=oid%></div></td>
<td><div align="center"><%=status%></div></td>
<td><div align="center"><%=paid%></div></td>
<td><div align="center"><%=paytype%></div></td>
</tr>
<%}
}
%>
</table>
</td>
</tr>
<%
con.close();}
catch(SQLException e) { }
}
%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -