fd.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
  if(document.thisre.re.value.length==0)
  {
    alert("请填写回复内容");
	document.thisre.re.focus();
	return false;
  }
}
</script>
<%
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>
<%}}%>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">投诉管理</font></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <%
	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 * from feedback order by id desc"; 
    ResultSet rs=data.executeQuery(sql);
	if(!rs.next())
	{%>
	<tr bgcolor="#FFFFFF">
    <td height="30" colspan="5"><div align="center">无投诉</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);
	String settitle="";
	int id=rs.getInt("id");
	String title=rs.getString("title").trim();
	int inttitle=title.length();
	if(inttitle<12)
	{ settitle=title; }
	if(inttitle>12)
	{ settitle=title.substring(0,12); }
	String name=rs.getString("name").trim();
	%>
	<tr>
	<td width="40" height="20"><div align="center"><%=id%></div></td>
	<td width="210">　<a href="fd.jsp?show=<%=id%>"><%=settitle%>.......</a></td>
	<td width="80"><div align="center"><a target="_blank" href="user.jsp?id=<%=name%>"><%=name%></a></div></td>
	<td width="35"><div align="center"><a href="fd.jsp?show=<%=id%>"><font color="#FF0000">查看</font></a></div></td>
	<td width="35"><div align="center"><a href="fd.jsp?del=<%=id%>"><font color="#FF0000">删除</font></a></div></td>
	</tr>
	<%
	i=1;
	id=0;
	title="";
	name="";
	settitle="";
	while(i<pagesize && rs.next())
	{
	id=rs.getInt("id");
	title=rs.getString("title").trim();
	inttitle=title.length();
	if(inttitle<12)
	{ settitle=title; }
	if(inttitle>12)
	{ settitle=title.substring(0,12); }
	name=rs.getString("name");
	%>
	<tr>
	<td width="40" height="20"><div align="center"><%=id%></div></td>
	<td width="210">　<a href="fd.jsp?show=<%=id%>"><%=settitle%>.......</a></td>
	<td width="80"><div align="center"><a target="_blank" href="user.jsp?id=<%=name%>"><%=name%></a></div></td>
	<td width="35"><div align="center"><a href="fd.jsp?show=<%=id%>"><font color="#FF0000">查看</font></a></div></td>
	<td width="35"><div align="center"><a href="fd.jsp?del=<%=id%>"><font color="#FF0000">删除</font></a></div></td>
	</tr>
	<%
	i++;
	}}%>
	</table></td>
  </tr>
  <tr>
    <td height="25" bgcolor="3969A5">&nbsp;</td>
  </tr>
</table>
<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="fd.jsp?page=<%=intpage-1%>">上一页　</a> 
    <%} else{%>
    <a href="fd.jsp?page=<%=1%>">最前页</a><a href="fd.jsp?page=<%=intpage-1%>">　上一页</a> 
    <%}}%>
    <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
    <a href="fd.jsp?page=<%=intpage+1%>">下一页</a> 
    <%}else{%>
    <a href="fd.jsp?page=<%=intpage+1%>">下一页　</a><a href="fd.jsp?page=<%=allpage%>">最后页</a> 
    <%}}%>
  </div>
</form>
<br><br>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
sql="delete from feedback where id='"+del+"'";
rs=data.executeQuery(sql);
response.sendRedirect("fd.jsp");
}
%>
<%
String show=request.getParameter("show");
if(show!="" && show!=null)
{
sql="select * from feedback where id='"+show+"'";
rs=data.executeQuery(sql);
rs.next();
String gettitle=rs.getString("title").trim();
String text=rs.getString("text").trim();
String name=rs.getString("name").trim();
String getre=rs.getString("re").trim();
rs.close();
%>
<table align="center" width="400" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr bgcolor="3969A5">
    <td height="25" colspan="3"><div align="center"><font color="#FFFFFF">投诉人:</font><font color="#00FFFF"><%=name%></font></div></td>
</tr>
<tr>
<td>
<table align="center" width="400" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="80" height="25"><div align="right">投诉主题:</div></td>
<td width="10"></td>
<td width="310"><%=gettitle%></td>
</tr>
<tr>
<td height="25"><div align="right">投诉内容:</div></td>
<td></td>
<td><%=text%></td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="3969A5">
<td height="25" colspan="3"><div align="center">　　　　　　　　　　　　　　　　　　　　　　　　　　<a href="fd.jsp?show=<%=show%>&re=<%=show%>&text=<%=getre%>"><font color="#CCCCCC">回复</font></a></div></td>
</tr>
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="80"><div align="right">回复:</div></td>
<td width="10"></td>
<td width="310" height="25"><%=getre%></td>
</tr>
</table>
</td>
</tr>
</table>
<%}%>
<%
String re=request.getParameter("re");
if(re!="" && re!=null)
{
String text=request.getParameter("text");
text=new String(text.getBytes("ISO8859_1"),"GBK");
%>
<form action="" method="post" name="thisre" onSubmit="return check()">
<input type="hidden" name="rethis" value="">
<input type="hidden" name="id" value="<%=re%>">
<table align="center" width="400" cellpadding="0" cellspacing="0" border="0" bgcolor="#CCCCCC">
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td height="150"><div align="center"><textarea name="setre" cols="60" rows="8" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"><%=text%></textarea></div></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="25"><div align="center">
              <input type="submit" value="回复" onClick="document.all.rethis.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
            </div></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<%}%>
<%
String rethis=request.getParameter("rethis");
if(rethis!=null && rethis.equals("true"))
{
String id=request.getParameter("id");
String getre=request.getParameter("setre");
getre=new String(getre.getBytes("ISO8859_1"),"GBK");
sql="update feedback set re='"+getre+"' where id='"+id+"'";
rs=data.executeQuery(sql);
response.sendRedirect("fd.jsp");
}
%>