feed.jsp

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

<script language="JavaScript">
function check()
{
  if(document.thisfb.title.value.length==0)
  {
     alert("请填写主题");
	 document.thisfb.title.focus();
	 return false;
  }
  if(document.thisfb.text.value.length==0)
  {
     alert("请填写内容");
	 document.thisfb.text.focus();
	 return false;
  }
}
</script>
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<table align="center" width="400" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr>
<td>
<%
int pagesize=5;
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;
}
sql="select * from feedback where name='"+member+"' order by id desc";
rs=data.executeQuery(sql);
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 title=rs.getString("title");
String text=rs.getString("text");
String re=rs.getString("re").trim();
%>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF" class="defaulttext">
<tr>
<td height="10" colspan="3"></td>
</tr>
<tr>
<td width="120" height="20"><div align="right">投诉主题:</div></td>
<td width="10"></td>
<td width="420"><font color="#FF0000"><%=title%></font></td>
</tr>
<tr>
<td height="20"><div align="right">投诉内容:</div></td>
<td></td>
<td><%=text%></td>
</tr>
<tr>
<td height="20"><div align="right">回复:</div></td>
<td></td>
<td><%if(re.equals("")){%><font color="#0000FF">无回复</font><%}else{%><%=re%><%}%></td>
</tr>
</table>
<%
i=1;
title="";
text="";
re="";
while(i<pagesize && rs.next())
{
title=rs.getString("title").trim();
text=rs.getString("text").trim();
re=rs.getString("re").trim();
%>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF" class="defaulttext">
<tr>
<td height="15" colspan="3"></td>
</tr>
<tr>
<td width="120" height="20"><div align="right">投诉主题:</div></td>
<td width="10"></td>
<td width="420"><font color="#FF0000"><%=title%></font></td>
</tr>
<tr>
<td height="20"><div align="right">投诉内容:</div></td>
<td></td>
<td><%=text%></td>
</tr>
<tr>
<td height="20"><div align="right">回复:</div></td>
<td></td>
<td><%if(re.equals("")){%><font color="#0000FF">无回复</font><%}else{%><%=re%><%}%></td>
</tr>
</table>
<%
i++;
}}%>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td height="10"></td>
</tr>
</table>
</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="feed.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="feed.jsp?page=<%=1%>">最前页</a><a href="feed.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="feed.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="feed.jsp?page=<%=intpage+1%>">下一页　</a><a href="feed.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>
<%
String feedback=request.getParameter("feedback");
if(feedback!=null && feedback.equals("true"))
{
String title=request.getParameter("title");
title=new String(title.getBytes("ISO8859_1"),"GBK");
String text=request.getParameter("text");
text=new String(text.getBytes("ISO8859_1"),"GBK");
sql="insert into feedback(title,text,name,re) values(\'"+title+"\',\'"+text+"\',\'"+member+"\',\'"+""+"\')";
rs=data.executeQuery(sql);
}
%>
<form action="" method="post" name="thisfb" onSubmit="return check()">
<input type="hidden" name="feedback" value="">
<table width="550" border="0" align="center" cellpadding="0" cellspacing="0" class="defaulttext">
  <tr>
  <td height="20" colspan="3"></td>
  </tr>
  <tr> 
    <td width="80" height="20"><div align="right">主题:</div></td>
    <td width="10"></td>
    <td><input type="text" name="title" size="70" maxlength="50" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
  </tr>
  <tr> 
    <td height="15" colspan="3"></td>
  </tr>
  <tr> 
    <td valign="top"><div align="right">内容:</div></td>
    <td></td>
    <td><textarea name="text" cols="72" rows="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></textarea></td>
  </tr>
  <tr> 
    <td height="15" colspan="3"></td>
  </tr>
  <tr> 
    <td height="25" colspan="3"><div align="center">
        <input type="submit" value="投诉" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.feedback.value='true';">
        <input type="reset" value="重写" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
      </div></td>
  </tr>
</table>
</form>