?? addteacherok.jsp
字號:
<%@ 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>");
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -