addtypeok.jsp

这是一个在线教育系统

<%@ include file="conn.jsp"%>
<%@ include file="isadmin.jsp"%>
<%request.setCharacterEncoding("GB2312");
String addtype=request.getParameter("addtype");
if(addtype==null){
 out.print("<script>alert('请输入要添加的栏目名');history.go(-1);</script>");
}
String sql="select * from scott.type  where type='"+addtype+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
 if(rs.next()){
out.print("<SCRIPT language=JavaScript>alert('数据库中已经有一个名为"+addtype+"的栏目了！');");
   out.print("history.go(-1);</SCRIPT>"); 
  }else{
stmt.executeUpdate("INSERT INTO scott.type(typeid ,type) VALUES(scott.typeid.nextval,'"+addtype+"')");

out.print("<script>alert('添加成功');window.location.href='addtype.jsp';</script>");
  }
%>