📄 main.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="indentmsg" scope="page" class="leecong.javabean.IndentMessage"/>
<%!
String admin="";
int dipage=0;
String pages=null;
int countRecord=0;//记录条数
int countPageRecord=0;//每页记录条数
int countPage=0;//总页数
ResultSet rs=null;
int issales=2;
%>
<%
admin=(String)session.getAttribute("admin");
if (admin==null || admin.equals("")){
out.print("<script language='javascript'>alert('对不起，您还没有登陆，请先登陆!');</script>");
out.print("<script language='javascript'>location='login.jsp';</script>");
}
else
{
session.setAttribute("admin",admin);
}
if(!indentmsg.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<%
//当前页码数默认为1
pages=request.getParameter("dipage");
if(pages==null)
{
pages="1";
}
try
{
dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
dipage=1;
}
%>
<%
if(request.getParameter("issales")==null)
{
rs=indentmsg.getIndents();
}
else
{
issales=Integer.parseInt(request.getParameter("issales"));
if(issales==0)
{
rs=indentmsg.getIndents(issales);
}
else if(issales==1)
{
rs=indentmsg.getIndents(issales);
}
else
{
rs=indentmsg.getIndents();
}
}
countPageRecord=10;//每页8条记录
//得到记录的条数
try
{
rs.last();
countRecord=rs.getRow();
//得到总页数
if(countRecord/countPageRecord==0){
countPage=countRecord/countPageRecord;
}
else{
countPage=countRecord/countPageRecord+1;
}
//把记录指针移至当前页第一条记录之前
if((dipage-1)*countPageRecord==0){
rs.beforeFirst();
}
else{
rs.absolute((dipage-1)*countPageRecord);
}
}catch(Exception e){e.printStackTrace();}
%>
<html>
<head>
<title>LEE电子商务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function openScript(url,name, width, height){
window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
function checkform(){
if(document.form2.indentno.value=="")
{
alert("订单号不能为空！");
form2.indentno.focus();
return false;
}
return true;
}
var msg=" 请使用IE5.5以上版本，800*600分辨率浏览 ";
var seq = 0;
function Scroll(){
window.status = msg.substring(msg.length,seq); seq++;
if (seq >= msg.length )
{ seq = 0 };
window.setTimeout("Scroll();", 300 );
}
</script>
<link rel="stylesheet" href="books.css" type="text/css">
<style type="text/css">
<!--
.style1 {
color: #996600;
font-weight: bold;
}
-->
</style>
</head>
<body text="#000000" onLoad="Scroll();">
<div align="center">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center" width="23%"><img src="../images/01247.jpg" width="96" height="114"></td>
<td align="center" width="77%"><img src="../images/baners.gif" width="512" height="80"></td>
</tr>
<tr>
<td align="center" width="23%" valign="top">
<table width="100%" border="0" cellspacing="4" cellpadding="2">
<tr>
<td align="center"><a href="main.jsp">管理首页</a></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td align="center"><a href="addbook.jsp">添加商品资料</a></td>
</tr>
<tr>
<td align="center"><a href="booklist.jsp">商店商品查询</a><a href="orderlist.jsp"></a></td>
</tr>
<tr>
<td align="center"><a href="addbookclass.jsp">添加商品类别</a></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td align="center"><a href="login.jsp">退出</a></td>
</tr>
<tr>
<td align="center">
<form name="form1" method="post" action="main.jsp">
<select name="issales">
<option value="2">-所有-</option>
<option value="0">未发货</option>
<option value="1">已发货</option>
</select>
<input type="submit" name="Submit" value="查询">
</form> </td>
</tr>
<tr>
<td align="center"><img src="../images/baobei[1].gif" width="120" height="60"></td>
</tr>
</table>
</td>
<td width="77%" valign="top">
<center><span class="style1"><font size="2">欢迎你登陆，LEE电子商务 商品管理员</font></span>...</center>
<form name="form2" action="showindent.jsp" method="post" onSubmit="return checkform();" target="_blank">
LEE 电子商务订单情况
订单号：<input type="text" name="indentno" size="20" maxlength="17">
<input type="submit" name="Submit2" value="查询">
</form>
<table width="98%" border="1" cellspacing="1" cellpadding="1" bordercolor="#336633">
<tr align="center">
<td width="22%">订单编号</td>
<td width="20%">用户名</td>
<td width="16%">发货时间</td>
<td width="12%">总金额(元)</td>
<td width="10%">付款</td>
<td width="10%">发货</td>
<td width="10%">查看</td>
</tr>
<%
try{
int i=0;
while(rs.next())
{
%> <tr>
<td><font color="red"><%=rs.getString(2)%></font></td>
<td align="center"><%=rs.getString(3)%></td>
<td align="center"><%=rs.getString(5).substring(0,10)%></td>
<td align="center"><%=rs.getFloat(6)%></td>
<td align="center">
<%
if(rs.getBoolean(7)){
out.print("已付款");
}
else{
out.print("未付款");
}
%>
</td>
<td align="center">
<%
if(rs.getBoolean(8)){
out.print("已发货");
}
else{
out.print("未发货");
}
%>
</td>
<td align="center">
<a href="javascript:openScript('showindent.jsp?indentid=<%=rs.getString(1)%>&indentno=<%=rs.getString(2)%>','indentlist',600,500);">详细</a>
</td>
</tr>
<%
i++;
if(i>=countPageRecord){
break; //当前页显示完，则退出循环
}
}
}catch(Exception ex){ex.printStackTrace();}
%>
</table><br>
<%
try{
if(dipage==1)//当前是首页
out.print("首页 上一页 ");
else//当前不是首页
{
out.print("<a href=main.jsp?dipage=1&issales="+issales+">首页 </a> ");
out.print("<a href=main.jsp?dipage="+(dipage-1)+"&issales="+issales+">上一页</a> ");
}
if(dipage==countPage || (dipage-1)==countPage)//当前是末页
out.print("下一页 末页 ");
else//当前不是末页
{
out.print("<a href=main.jsp?dipage="+(dipage+1)+"&issales="+issales+">下一页 </a> ");
out.print("<a href=main.jsp?dipage="+countPage+"&issales="+issales+">末页 </a> ");
}
}catch(Exception e2){e2.printStackTrace();}
%>
<br>
<%
out.print("共"+countRecord+"条记录,共"+countPage+"页，当前第"+dipage+"页，每页"+countPageRecord+"条记录");
%>
<p> </p>
</td>
</tr>
</table>
<br>
<table width="70%" border="0" cellspacing="2" cellpadding="2" align="center">
<tr>
<td align="center">开发:LeeCong<br>
CopyRight@2006 <br>
Email:<a href="mailto:leecong@eyou.com">leecong@eyou.com</a></td>
</tr>
</table>
</div>
<%
indentmsg.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -