editpolicy.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
	  String action1=request.getParameter("action");  
	  String pytitle=request.getParameter("pytitle");
	 String pybody=request.getParameter("pybody");   
	  String pyimg=request.getParameter("filename");  
	  String   sql2;
	   if(action1==null){
		  sql="select * from scott.policy where id='"+id+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
 %>
<form name="frmCtoy" method="post" action="editpolicy.jsp?action=edit&id=<%=id%>" >
  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000">
    <tr> 
      <td height="30" colspan="2" bgcolor="#B4E7F1"> 
        <div align="center"><strong>编辑政策法规</strong></div></td></tr>
    <tr>
      <td width="22%">政策法规标题:</td>
      <td height="25"> <input name="pytitle" type="text" size="30" value="<%=rst.getString("pytitle")%>"></td>
    <tr>
	<tr>
      <td width="22%">政策法规内容:</td>
      <td width="78%"> 
        <textarea name="pybody" cols="60" rows="20"><%=rst.getString("pybody")%></textarea>
      </td>
    </tr>
 <tr> 
      <td height="40">上传图片：</td>
      <td height="25"> 
     <input type="text" name="filename" value="<%=rst.getString("pyimg")%>">
        如果图片文件名您不太清楚,请不要乱修改</td>
  </tr>
  <tr>
      <td height="25">&nbsp;</td>
    <td><input type="submit" name="ups" value="修改"></td>
	</tr>
</table>
</form>
<% 
}
 }else{
	  if(action1.equals("edit")){		

   stmt.executeUpdate("update scott.policy set pytitle='"+pytitle+"', pybody='"+pybody+"', pyimg='"+pyimg+"' where id='"+id+"'");

   %>
   <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr> 
    <td height="30" bgcolor="#B1E1F3"> <div align="center"><strong>修改成功</strong></div></td>
  </tr>
  <tr> 
    <td><div align="center">修改后的文件将在主页上以修改后的内容显示,操作时请一定谨慎对待.认真对校,请选择你返回要返回的页面.</div></td>
  </tr>
  <tr> 
    <td height="20"> <div align="center"><a href="admin_policy.jsp">【返回】</a><a href="adminbody.jsp">【继续其它操作】</a></div></td>
  </tr>
</table>
<% }
} %>
</body>
</html>