editinfook.jsp

这是一个在线教育系统

<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%String adminvalue="admin",teacher="",fenlei1="",fenlei2="";%>
<%@ include file="isteacher.jsp"%>
<%
request.setCharacterEncoding("GB2312");
 fenlei1=request.getParameter("fenlei1");
 fenlei2=request.getParameter("fenlei2");
 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 photourl =request.getParameter("fileurl");

 sql="select * from scott.teacher where loginname='"+loginname+"' and teacherid<>"+session.getValue("teacherid"); 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(rs_lar.next()){
	  out.print("<script>alert('该登录名已经有人使用了');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+"',photourl='"+photourl+"' where teacherid='"+session.getValue("teacherid")+"'");
out.print("<script>alert('修改成功');window.location.href='editinfo.jsp?id="+session.getValue("teacherid")+"';</script>");
   }
  
%>