<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%request.setCharacterEncoding("GB2312");
String fenlei1=request.getParameter("fenlei1");
String fenlei2=request.getParameter("fenlei2");
String teacher =request.getParameter("teacher");
String loginname=request.getParameter("loginname");
String email=request.getParameter("email");

String homepage=request.getParameter("homepage");
String address=request.getParameter("address");
String qq =request.getParameter("qq");
String intro=request.getParameter("intro");
 password=request.getParameter("password");

String ask=request.getParameter("ask");
String answer=request.getParameter("answer");

 sql="select * from scott.teacher where loginname='"+loginname+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(rs_lar.next()){
	  out.print("<script>alert('該登錄名已經有人使用了');history.go(-1);</script>");
   }else{

stmt.executeUpdate("INSERT INTO scott.teacher(teacherid ,teacher,password,fenlei1,fenlei2,email,address,intro,homepage,qq,answer,ask,loginname) VALUES(scott.teacherid.nextval,'"+teacher+"', '"+password+"','"+fenlei1+"','"+fenlei2+"','"+email+"','"+address+"','"+intro+"','"+homepage+"','"+qq+"','"+answer+"','"+ask+"','"+loginname+"')");


out.print("<script>alert('添加成功');window.location.href='adminsearchteacher.jsp?fenlei1=&fenlei2=&teacher=&id=';</script>");
   }
%>