edittypeok.jsp

JSP实现的远程教育平台

<%@ include file="conn.jsp"%>
<%@ include file="isadmin.jsp"%>
<%
request.setCharacterEncoding("GB2312");
String id=request.getParameter("id");
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+"' and typeid<>"+id; 
ResultSet rs=stmt.executeQuery(sql); 
 if(rs.next()){
out.print("<SCRIPT language=JavaScript>alert('数据库中已经有一个名为"+addtype+"的栏目了！');");
   out.print("history.go(-1);</SCRIPT>"); 
  }else{
 stmt.executeUpdate("update scott.type set type='"+addtype+"' where typeid='"+id+"'");

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