admin_sort.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<div align="center">
  <%String  sql;
      String id=request.getParameter("id");   
	  String action1=request.getParameter("action");  
	  String sorts=request.getParameter("sort"); 
      sql="select * from scott.allsort order by id";
	  if(action1==null){
      ResultSet rst=stmt.executeQuery(sql); 
	  
	%>
  <table width="200" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr> 
      <td height="30" colspan="2" bgcolor="#B1E1F3"> 
        <div align="center"><strong>所有栏目</strong></div></td>
  </tr>
  <% while(rst.next()) {  %>
  <tr> 
    <td><%=rst.getString("sort")%></td>
    <td><div align="center"><a href="admin_sort.jsp?action=edit&id=<%=rst.getString("id")%>">修改</a></div></td>
  </tr>
  <%  }
  %>
  <tr> 
    <td colspan="2">&nbsp;&nbsp;&nbsp;本站一共有17个栏目,在主界面经过了精心布置与排版, 所以暂不提供添加新栏目的功能,添加之后的栏目排在主页面上不太美观.所以建议你在修改栏目时也为主界面的美观考虑,原先的栏目是四个字的,修改后尽量保持他也是四个字, 
      如果有一些四个字,有一些五个字.这样会给主界面美观带来非常不好的影响.</td>
  </tr>
</table>
<% }else{
		  if(action1.equals("edit")){
         sql="select * from scott.allsort  where id='"+id+"'";	
          ResultSet rst=stmt.executeQuery(sql); 
            if(rst.next()){%>
   <form name="form1" method="post" action="admin_sort.jsp?action=xiugai&id=<%=rst.getString("id")%>">
  <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
      <tr> 
        <td height="30" colspan="2" bgcolor="#B1E1F3"> 
          <div align="center"><strong>栏目名称修改</strong></div></td>
  </tr>
  <tr> 
    <td>修改栏目名称:</td>
    <td>
        <input type="text" name="sort" value="<%=rst.getString("sort")%>">
      </td>
  </tr>
  <tr> 
        <td colspan="2"> <div align="center">
            <input type="submit" name="Submit" value="修改">
          </div></td>
  </tr>
</table>
</form>
<%
			}
	  }

 if(action1.equals("xiugai")){
     stmt.executeUpdate("update scott.allsort set sort='"+sorts+"' where id='"+id+"'");
      %>
	   
	   <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr>
    <td height="30" bgcolor="#B1E1F3"> 
      <div align="center"><strong>修改成功</strong></div></td>
  </tr>
  <tr>
    <td>数据修改成功,你所修改后的数据内容将直接在主界在上显示.操作时请谨慎处理</td>
  </tr>
  <tr>
    <td><div align="center"><a href="admin_sort.jsp">【返回】</a><a href="adminbody.jsp">【继续其它操作】</a></div></td>
  </tr>
</table>
	   <%}
  }

%>

</div>
</body>
</html>