through_ware.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<%
String delsmall=request.getParameter("delsmall");
String delbig=request.getParameter("delbig");
String delid=request.getParameter("delid");
if(delsmall!="" && delsmall!=null)
{
if(delbig!="" && delbig!=null)
{
if(delid!="" && delid!=null)
{
String sql="delete from ware where id='"+delid+"' and class_small='"+delsmall+"' and class_big='"+delbig+"'";
ResultSet rs=data.executeQuery(sql);
response.sendRedirect("through_ware.jsp");
}}}
%>
<br><br>
<table width="542" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5">&nbsp;</td>
  </tr>
</table>
<table width="540" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr>
    <td>
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<%
	int pagesize=20;
	int allcount;
	int allpage;
	int intpage;
	int i;
	String strpage=request.getParameter("page");
	if(strpage==null)
	{
	intpage=1;
	}else{
	intpage=Integer.parseInt(strpage);
	if(intpage<1) intpage=1;
	}
	String sql="select id,warename,addware,addtime,class_small,class_big from ware where censor_yes='"+"0"+"' order by id desc";
	ResultSet rs=data.executeQuery(sql);
	if(!rs.next())
	{%>
	    <tr bgcolor="#FFFFFF">
		<td height="60"><div align="center">目前尚无商品，请<a href="addware.jsp"><font color="#0000FF">添加</font></a>！</div></td>
        </tr>
	<%}
	rs.last();
	allcount=rs.getRow();
	allpage=(allcount+pagesize-1)/pagesize;
	if(intpage>allpage) intpage=allpage;
	if(allpage>0)
	{
	rs.absolute((intpage-1)*pagesize+1);
	int getid=rs.getInt("id");
	String getname=rs.getString("warename");
	String getware=rs.getString("addware");
	String gettime=rs.getString("addtime").substring(0,16);
	int getsmall=rs.getInt("class_small");
	int getbig=rs.getInt("class_big");
	%>
	<tr bgcolor="#FFFFFF">
	      <td width="35" height="20"><div align="center"><%=getid%></div></td>
	      <td width="220">　<a href="edit_ware.jsp?small=<%=getsmall%>&big=<%=getbig%>&id=<%=getid%>"><%=getname%></a></td>
	   <td width="60"><div align="center"><font color="#FF0000"><%=getware%></font></div></td>
	   <td width="120"><div align="center"><%=gettime%></div></td>
	   <td width="35"><div align="center"><a href="edit_ware.jsp?small=<%=getsmall%>&big=<%=getbig%>&id=<%=getid%>"><font color="#0000FF">编辑</font></a></div></td>
	   <td width="35"><div align="center"><a href="through_ware.jsp?delsmall=<%=getsmall%>&delbig=<%=getbig%>&delid=<%=getid%>"><font color="#0000FF">删除</font></a></div></td>
	   <td width="35"><div align="center"><a href="through.jsp?small=<%=getsmall%>&big=<%=getbig%>&id=<%=getid%>"><font color="#0000FF">审核</font></a></div></td>
	</tr>
	<%
	i=1;
	int id=0;
	String warename="";
	String addware="";
	String addtime="";
	int intsmall=0;
	int intbig=0;
	while(i<pagesize && rs.next())
	{
	id=rs.getInt("id");
	warename=rs.getString("warename");
	addware=rs.getString("addware");
	addtime=rs.getString("addtime").substring(0,16);
	intsmall=rs.getInt("class_small");
	intbig=rs.getInt("class_big");
	%>
	<tr bgcolor="#FFFFFF">
	      <td width="40" height="20"><div align="center"><%=id%></div></td>
	      <td width="150">　<a href="edit_ware.jsp?small=<%=intsmall%>&big=<%=intbig%>&id=<%=id%>"><%=warename%></a></td>
	   <td width="80"><div align="center"><font color="#FF0000"><%=addware%></font></div></td>
	   <td width="150"><div align="center"><%=addtime%></div></td>
	   <td width="40"><div align="center"><a href="edit_ware.jsp?small=<%=intsmall%>&big=<%=intbig%>&id=<%=id%>"><font color="#0000FF">编辑</font></a></div></td>
	   <td width="40"><div align="center"><a href="through_ware.jsp?delsmall=<%=intsmall%>&delbig=<%=intbig%>&delid=<%=id%>"><font color="#0000FF">删除</font></a></div></td>
	   <td width="40"><div align="center"><a href="through.jsp?small=<%=intsmall%>&big=<%=intbig%>&id=<%=id%>"><font color="#0000FF">审核</font></a></div></td>
	</tr>
	<%
	i++;
	}}
	%>
	</table>
	</td>
  </tr>
</table>
<table width="542" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5">&nbsp;</td>
  </tr>
</table><br>
<form action="" method="post">
<div align="center">当前<font color="#FF0000"><%=intpage%></font>/<font color="#FF0000"><%=allpage%></font>页，每页<font color="#FF0000"><%=pagesize%></font>条
<%if(intpage>1)
 {
if(intpage==1)
 {%>
  <a href="through_ware.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="through_ware.jsp?page=<%=1%>">最前页</a><a href="through_ware.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="through_ware.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="through_ware.jsp?page=<%=intpage+1%>">下一页　</a><a href="through_ware.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>