actchangeroot.jsp

现今的社会是一个信息飞速发达的社会

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%
String root=(String)session.getAttribute("root");root=ht.donull(root);
String user_id=request.getParameter("id");user_id=ht.donull(user_id);
String get_root=request.getParameter("root");
String user_duty[];
String str="<meta http-equiv=\"refresh\" content=\"1;URL=../index.jsp\"><font color=#FF0000><strong>ERROR!!</strong></font>";
int user_root=1;
boolean test=false;
String sql="select step,root from user where userid='"+user_id+"'";
ResultSet rs=con.query(sql);rs.next();
if(rs.getRow()==0){
test=true;
}else{
user_root=rs.getInt(1);
user_duty=ht.split(rs.getString(2),"*");
if(user_duty.length>1)
{
str="<meta http-equiv=\"refresh\" content=\"1;URL=../main.jsp?id="+user_duty[0]+"\"><center><font color=#FF0000><strong>该会员已担任<a href=..main.jsp?id="+user_duty[0]+">"+user_duty[1]+"</a>斑竹，请先去<a href=..main.jsp?id="+user_duty[0]+">"+user_duty[1]+"</a>撤消其职务再来改变起权限值</strong></font></center>";
}
}

if(root.compareTo("")==0){root="0";}
int step=Integer.parseInt(root);

if(test){
    out.print("<meta http-equiv=\"refresh\" content=\"2;URL=../index.jsp\"><center><font color=#FF0000>该会员不存在</font></center>");
}else{

if(step<4 || (step<=user_root && step<6)){
    out.print("<meta http-equiv=\"refresh\" content=\"2;URL=../index.jsp\"><center><font color=#FF0000>对不起，本页面您无权进入</font></center>");
}else{

if(user_root==2){
out.print(str);
}else{
sql="update user set step=get_root,root='' where userid='"+user_id+"'";
con.update(sql);
out.print("<meta http-equiv=\"refresh\" content=\"2;URL=../aboutuser.jsp?id="+user_id+"\"><center><font color=#FF0000>该会员不存在</font></center>");
}
}
}
%>