editvideo.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 vdtitle=request.getParameter("vdtitle");
	 String introvd=request.getParameter("introvd");   
	  String movies=request.getParameter("movies");  
	  String   sql2;
	   if(action1==null){
		  sql="select * from scott.video where id='"+id+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
 %>

<form name="frmCtoy" method="post" action="editvideo.jsp?action=edit&id=<%=rst.getString("id")%>" >
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bordercolorlight="#000000">
    <tr bgcolor="#B1E1F3"> 
      <td height="30" colspan="2"> 
        <div align="center"><strong>修改视频文件</strong></div></td>
  </tr>
  <tr> 
    <td width="35%">视频文件标题:</td>
    <td height="25"> <input name="vdtitle" type="text" size="30" value="<%=rst.getString("vdtitle")%>"></td>
  <tr> 
  <tr> 
    <td width="35%">内容简介:</td>
    <td width="65%"> <textarea name="introvd" cols="30" rows="5"><%=rst.getString("introvd")%></textarea> </td>
  </tr>
  <tr> 
    <td height="27">视频文件名：</td>
    <td height="25"><input name="movies" type="text" size="30" value="<%=rst.getString("movies")%>"></td>
  </tr>
  <tr> 
    <td height="25">&nbsp;</td>
    <td><input type="submit" name="ups" value="确定"></td>
  </tr>
</table>
</form>
<% }
 }else{
	  if(action1.equals("edit")){		  
    stmt.executeUpdate("update scott.video set vdtitle='"+vdtitle+"', introvd='"+introvd+"', movies='"+movies+"' 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 height="41">
<div align="center"><a href="video.jsp">【返回】</a><a href="adminbody.jsp">【继续其它操作】</a></div></td>
  </tr>
</table>
 
<% }
} %>
</body>
</html>