edit_link.jsp

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

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

	  String   sql2;
	  if(action1==null){
		  sql="select webaddr,zwname,id from scott.aboutlink where id='"+id+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
%>
  <form name="form1" method="post" action="edit_link.jsp?action=edit&id=<%=rst.getString("id")%>">			   
  <table width="350" border="1" align="center" cellpadding="0" cellspacing="0">
    <tr bgcolor="#B1E1F3"> 
      <th height="30" colspan="2">编辑链接</th>
  </tr>
  <tr> 
    <td>链接的单位名称:</td>
    <td>
        <input name="fnames" type="text" value="<%=rst.getString("zwname")%>" size="30">
      </td>
  </tr>
  <tr> 
    <td>链接单位的网址:</td>
    <td><input name="webaddr" type="text" value="<%=rst.getString("webaddr")%>" size="30"></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td><input type="submit" name="Sumit" value="修 改"></td>
  </tr>
</table>
</form>
<%}
 }else{
	  if(action1.equals("edit")){		  
    stmt.executeUpdate("update scott.aboutlink set webaddr='"+webaddr+"', zwname='"+fnames+"' where id='"+id+"'");
			        %>

			  
<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_link.jsp">【返回】</a></div></td>
  </tr>
</table>
<%  }
} %>
</body>
</html>