editok.jsp

这是一个在线教育系统

<%@ include file="conn.jsp"%>
<%String adminvalue="admin",teacher="",fenlei1="",fenlei2="";%>
<%@ include file="isteacher.jsp"%>
<%@ include file="fenlei.jsp"%>
<%
request.setCharacterEncoding("GB2312");
String course=request.getParameter("course");
String fileurl=request.getParameter("fileurl");
String content=request.getParameter("content");
String title=request.getParameter("title");
String typeid=request.getParameter("type");
String filesize=request.getParameter("filesize");
String id=request.getParameter("id");

 sql="select * from scott.main where mainid="+id; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(!rs_lar.next()){
	  out.print("<script>alert('该资料不存在');history.go(-1);</script>");
   }else{
 stmt.executeUpdate("update scott.main set fileurl='"+fileurl+"',course='"+course+"',content='"+content+"',title='"+title+"',idoftype='"+typeid+"',filesize='"+filesize+"' where mainid='"+id+"'");
 out.print("<script>alert('修改成功');window.location.href='edit.jsp?id="+id+"';</script>");
   }
%>