<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%@ include file="isadmin.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 ask=request.getParameter("ask");
String answer=request.getParameter("answer");
String qq =request.getParameter("qq");
String intro=request.getParameter("intro");
 password=request.getParameter("password");

String locked =request.getParameter("locked");
String id =request.getParameter("id");

 sql="select * from scott.teacher where loginname='"+loginname+"' and teacherid<>"+id; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(rs_lar.next()){
	  out.print("<script>alert('該登錄名已經(jīng)有人使用了');history.go(-1);</script>");
   }else{
	   stmt.executeUpdate("update scott.teacher set teacher='"+teacher+"',fenlei1='"+fenlei1+"',fenlei2='"+fenlei2+"',email='"+email+"',homepage='"+homepage+"',address='"+address+"',qq='"+qq+"',intro='"+intro+"',ask='"+ask+"',answer='"+answer+"',loginname='"+loginname+"',password='"+password+"',locked='"+locked+"' where teacherid='"+id+"'");
out.print("<script>alert('修改成功');window.location.href='editteacher.jsp?id="+id+"';</script>");
   }
%>