addtj.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%  String  sql;
      String body=request.getParameter("body");   
	  String action1=request.getParameter("action");  
	  String tjtitle=request.getParameter("tjtitle");
	    if(action1==null){
%>
<form name="myform" method="post" action="addtj.jsp?action=add">
  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
      <td height="30" colspan="2"> 
        <div align="center"><strong>添加统计</strong></div></td>
    </tr>
    <tr> 
      <td width="17%">统计标题:</td>
      <td width="83%"><input name="tjtitle" type="text" id="title"></td>
    </tr>
    <tr bgcolor="#B1E1F3"> 
      <td height="25" colspan="2"> <div align="center"><strong>统计内容</strong></div></td>
    </tr>   
    <tr> 
      <td colspan="2"><div align="center"> 
          <textarea name="body" cols="70" rows="15" id="body"></textarea>
        </div></td>
    </tr>
    <tr> 
      <td colspan="2"> <div align="center"> 
          <input type="submit" name="ccc" value="添加">
          &nbsp;&nbsp;&nbsp;&nbsp;
          <input type="reset" name="Submit2" value="取消">
        </div></td>
    </tr>
  </table>
</form>
<% 
 }else{
	  if(action1.equals("add")){		
		//  out.print("INSERT INTO scott.mztj(tjid,tjtitle,tjbody) VALUES(scott.id.nextval,'"+tjtitle+"','"+body+"')");
   stmt.executeUpdate("INSERT INTO scott.mztj(tjid,tjtitle,tjbody) VALUES(scott.id.nextval,'"+tjtitle+"','"+body+"')");
		%>
<table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr>
    <th height="30" bgcolor="#B1E1F3">添加成功</th>
  </tr>
  <tr>
    <td>数据已成功添加,请选择你要返回的页面</td>
  </tr>
  <tr>
    <td><div align="center"><a href="admin_tj.jsp">【返回上一页面】</a><a href="adminbody.jsp">【返回管理首页】</a></div></td>
  </tr>
</table>
<%  }
}  %>
</body>
</html>