<%@ 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");
teacher=request.getParameter("teacher");

 sql="select * from scott.teacher where teacher='"+teacher+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(!rs_lar.next()){
	  out.print("<script>alert('輸入的教師不存在');history.go(-1);</script>");
   }else{
session.putValue("teacherid",rs_lar.getString("teacherid"));

stmt.executeUpdate("INSERT INTO scott.main(mainid ,fileurl,idofteacher,course,content,times,title,idoftype,filesize) VALUES(scott.mainid.nextval,'"+fileurl+"', '"+session.getValue("teacherid")+"','"+course+"','"+content+"','0','"+title+"','"+typeid+"','"+filesize+"')");

out.print("<script>alert('發(fā)布成功');window.location.href='pub.jsp';</script>");
   }
%>