editsortnew.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
	  String action1=request.getParameter("action");  
	  String sorts=request.getParameter("sort");
	 String title=request.getParameter("title");   
	  String body=request.getParameter("body");  
	  String   sql2;

	  if(action1==null){
		  sql="select * from scott.allarti where id='"+id+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
%>
<form name="myform" method="post" action="editsortnew.jsp?action=edit&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>
        <select name="sort">
          <%Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
		    sql2="select * from scott.allsort order by id";
      ResultSet rs2=stmt2.executeQuery(sql2); 
	  while(rs2.next()) {%>
          <option value="<%=rs2.getString("id")%>"><%=rs2.getString("sort")%></option>
          <%	  }%>
        </select>
      </td>
  </tr>
  <tr> 
      <td>栏目新闻标题:</td>
    <td><input name="title" type="text" id="title" value="<%=rst.getString("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"><%=rst.getString("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("edit")){		  
    stmt.executeUpdate("update scott.allarti set frominto='"+sorts+"', title='"+title+"', body='"+body+"' 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><div align="center">修改后的文件将在主页面上显示,操作时请一定谨慎对待.请选择你返回要返回的页面.</div></td>
  </tr>
  <tr> 
    <td height="20"> <div align="center"><a href="sort_new.jsp">【返回】</a><a href="adminbody.jsp">【继续其它操作】</a></div></td>
  </tr>
</table>
	<%  }
}%>