addlink.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%
String  sql;
      String webaddr=request.getParameter("webaddr");   
	  String action1=request.getParameter("action");  
	  String fnames=request.getParameter("fnames");

	    if(action1==null){
%>
<form name="form1" method="post" action="addlink.jsp?action=add">			   
  <table width="350" border="0" align="center">
    <tr> 
    <th colspan="2">添加链接</th>
  </tr>
  <tr> 
    <td>链接的单位名称:</td>
    <td>
        <input type="text" name="fnames">
      </td>
  </tr>
  <tr> 
    <td>链接单位的网址:</td>
    <td><input type="text" name="webaddr"></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td><input type="submit" name="Sumit" value="添 加"></td>
  </tr>
</table>
</form>
<% }else{
	  if(action1.equals("add")){		

   stmt.executeUpdate("INSERT INTO scott.aboutlink(id,zwname,webaddr) VALUES(scott.id.nextval,'"+fnames+"','"+webaddr+"')");


%>
	<table width="100%" border="0" align="center">
  <tr>
    <th>添加成功</th>
  </tr>
  <tr>
    <td>数据已经添加,请返回首页进行查看.或选择你要返回的地点.</td>
  </tr>
  <tr>
    <td><div align="center"><a href="admin_link.jsp">【返回】</a><a href="adminbody.jsp">【返回前一页】</a> 
        </div></td>
  </tr>
</table>
<%  }
}  %>
</body>
</html>