editworknet1.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
      String nettitle=request.getParameter("nettitle");   
	  String action1=request.getParameter("action");  
	  String netbody=request.getParameter("netbody");
	  String workfile=request.getParameter("filename");
	  	  String filename=request.getParameter("workfile");
	  String   sql2;
	   if(action1==null){
		  sql="select * from scott.worknet 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="editworknet1.jsp?action=edit&id=<%=id%>" >
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bordercolorlight="#000000">
    <tr bgcolor="#B4E7F1"> 
      <td height="30" colspan="2"> 
        <div align="center"><strong>添加网上事务文件</strong></div></td></tr>
    <tr>
      <td width="22%">网上事务标题:</td>
      <td height="25"> <input name="nettitle" type="text" size="30" value="<%=rst.getString("nettitle")%>"></td>
    <tr>
	<tr>
      <td width="22%">内容:</td>
      <td width="78%"> 
        <textarea name="netbody" cols="60" rows="20"><%=rst.getString("netbody")%></textarea>
      </td>
    </tr>
	<tr><td>附件名称:</td><td><input name="workfile" type="text" size="30" value="<%=rst.getString("filename")%>"></td></tr>
 <tr> 
      <td height="40">上传的附件：</td>
      <td height="25"> 
     <input type="text" name="filename" value="<%=rst.getString("workfile")%>">
        注意,如果你不是太熟悉的话.此处最好不要修改.</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.worknet set nettitle='"+nettitle+"', netbody='"+netbody+"', workfile='"+workfile+"', filename='"+filename+"' where id='"+id+"'");

 		 %>
		 
<table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr>
    <th height="30" bgcolor="#B4E7F1">修改成功</th>
  </tr>
  <tr>
    <td>你可以返回到上一页面查看</td>
  </tr>
  <tr>
    <td><div align="center"><a href="admin_worknet.jsp">【返回】</a></div></td>
  </tr>
</table>
<% }
} %>
</body>
</html>