editmznew.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
      String nstitle=request.getParameter("title");   
	  String action1=request.getParameter("action");  
	  String nsbody=request.getParameter("body");
	  String writers=request.getParameter("writer");
	  String   sql2;
	  if(action1==null){
		  sql="select id,nstitle,nsbody,writers from scott.news 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="editmznew.jsp?action=edit&id=<%=id%>">
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr> 
      <td height="30" colspan="2" bgcolor="#B1E1F3"> <div align="center"><strong>添加栏目新闻</strong></div></td>
    </tr>
    <tr> 
      <td width="20%">栏目新闻标题:</td>
      <td width="80%"><input name="title" type="text" id="title" value="<%=rst.getString("nstitle")%>"></td>
    </tr>
	<tr><td>发布单位:</td><td><input name="writer" type="text" value="<%=rst.getString("writers")%>"></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("nsbody")%></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.news set nstitle='"+nstitle+"', nsbody='"+nsbody+"', writers='"+writers+"' 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_news.jsp">【返回查看】</a> </div></td>
  </tr>
</table>
<%  }
} %>
</body>
</html>