addworknet.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%
String  sql;
      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");
	    if(action1==null){
%>
<form name="frmCtoy" method="post" action="addworknet.jsp?action=save" >
  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" 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"></td>
    <tr>
	<tr>
      <td width="22%">内容:</td>
      <td width="78%"> 
        <textarea name="netbody" cols="60" rows="20"></textarea>
      </td>
    </tr>
	<tr><td>附件名称:</td><td><input name="workfile" type="text" size="30"></td></tr>
 <tr> 
      <td height="40">上传文件：</td>
      <td height="25"> 
        <iframe frameborder="0" width="400" height=24 scrolling="no" src="upfile.htm" ></iframe>
     <input type="hidden" name="filename">
      </td>
  </tr>
  <tr>
      <td height="25">&nbsp;</td>
    <td><input type="submit" name="ups" value="确定"></td>
	</tr>
</table>
</form>
<% }else{
	  if(action1.equals("save")){		

   stmt.executeUpdate("INSERT INTO scott.worknet(id,nettitle,netbody,filename,workfile) VALUES(scott.id.nextval,'"+nettitle+"','"+netbody+"','"+filename+"','"+workfile+"')");


%>
		 
<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>