replyconsul.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 59 行

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
	  String action1=request.getParameter("action"); 
      String id=request.getParameter("id");   
      String reply=request.getParameter("reply");   
	  String content=request.getParameter("content");  
	  String   sql2;
	  if(action1==null){
		  sql="select * from scott.contact where id='"+id+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
%>

<form name="form1" method="post" action="replyconsul.jsp?id=<%=id%>&action=reply">
  <table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr> 
      <td width="87">咨询内容:</td>
      <td width="253"> <textarea name="content" rows="5"><%=rst.getString("guestcontent")%></textarea> 
      </td>
    </tr>
    <tr> 
      <td>回复:</td>
      <td><textarea name="reply" rows="5"><%=rst.getString("reply")%></textarea></td>
    </tr>
    <tr> 
      <td colspan="2"><div align="center">
          <input type="submit" name="Submit" value="提 交">
          　 
          <input type="reset" name="Submit2" value="取 消">
        </div></td>
    </tr>
  </table>
</form>
<%}
 }else{
	  if(action1.equals("reply")){		  
    stmt.executeUpdate("update scott.contact set reply='"+reply+"', guestcontent='"+content+"' where id='"+id+"'");

			 %>
<table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr>
    <td height="25" bgcolor="#B1E1F3"> 
      <div align="center"><strong>编辑回复动作完成</strong></div></td>
  </tr>
  <tr>
    <td>你可以返回上一页进行查看,为了尊重咨询者请尽量不要更改他的留言</td>
  </tr>
  <tr>
    <td><div align="center"><a href="admin_consul.jsp">【返回】</a></div></td>
  </tr>
</table>
<%  }
} %>
</body>
</html>