actaddmast.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");
String boardid=request.getParameter("mast");
String boardname="";
String mast="";
String user_root="";
String user_name="";
int user_step=0;

String board="select name,boardmast from board where id="+boardid;
ResultSet boa_rs=con.query(board);boa_rs.next();
if(boa_rs.getRow()!=0){
boardname=con.getStr(boa_rs.getString(1));
mast=con.getStr(boa_rs.getString(2));
}

String user="select * from user where userid='"+user_id+"'";
ResultSet use_rs=con.query(user);use_rs.next();
if(use_rs.getRow()!=0){
user_step=use_rs.getInt(2);
user_root=use_rs.getString(3);
user_name=con.getStr(use_rs.getString(7));
}

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

if(step<4){
response.sendRedirect("../index.jsp");
}else{

if(mast.length()>200 || user_root.length()!=0){
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../aboutuser.jsp?id="+user_id+"\"><center><font color=#FF0000>对不起，操作失败。该版斑竹以满,或该会员担任职务过多</font></center>");
}else{

if(mast.indexOf(user_id) == (-1) && user_step==1){
String addmast=mast+user_id+"*"+user_name+"*";
String boardup="update board set boardmast='"+con.gb2iso(addmast)+"' where id="+boardid;
con.update(boardup);

String uproot=boardid+"*"+boardname;
String userup="update user set root='"+con.gb2iso(uproot)+"',step=2 where userid='"+user_id+"'";
con.update(userup);
//out.print(boardup+"<br>"+userup);
out.print("<meta http-equiv=\"refresh\" content=\"1;URL=rootlist.jsp?id="+user_id+"\"><center><font color=#FF0000><strong>操作成功</strong></font></center>");
}else{
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../aboutuser.jsp?id="+user_id+"\"><center><font color=#FF0000>您无权进行此操作</font></center>");
}
}
}
%>