move.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 id=(String)session.getAttribute("id");
String name=(String)session.getAttribute("name");
String root=(String)session.getAttribute("root");
String bbsid=request.getParameter("bbsid");
String bdid=request.getParameter("bdid");
String mvid=request.getParameter("mvbdid");
String table="btable1";
String retable="";
String user_id="";
String user_name="";
String title="";
String board="";
String newboard="";
boolean ed=false;

String bdsql="select btable,name,boardmast from board where id="+bdid;
ResultSet bd=con.query(bdsql);bd.next();
if(bd.getRow()!=0){
table=bd.getString(1);
board=con.getStr(bd.getString(2));
String mast[]=ht.split(bd.getString(3),"*");
for(int i=0;i<mast.length-1;i+=2){
if(mast[i].compareTo(id)==0){
ed=true;
}
}
}
con.close();

String bdnew="select name from board where id="+bdid;
ResultSet bd2=con.query(bdnew);bd2.next();
if(bd2.getRow()!=0){
newboard=con.getStr(bd2.getString(1));
}
con.close();

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

if(step > 2 || ed){

String bbssql="select title,userid,usname from "+table+" where id="+bbsid;
ResultSet brs=con.query(bbssql);brs.next();
if(brs.getRow()!=0){
title=con.getStr(brs.getString(1));
user_id=brs.getString(2);
user_name=brs.getString(3);
}
con.close();

String mvsql="update "+table+" set boardid="+mvid+" where id="+bbsid;
con.update(mvsql);

retable="re"+table;
String mvre="update "+retable+" set boardid="+mvid+" where reid="+bbsid;
con.update(mvre);

String txt="您好，您在南部湾论坛“"+board+"”版发表的《"+title+"》已被转移到“<font color=#ff0000>"+newboard+"</font>”！请注意查收，由于我们的操作给您带来的不便，我们表示深切的歉意，谢谢合作!";
String massage="insert into massage values(0,'"+user_id+"','"+user_name+"','"+id+"','"+con.gb2iso(name)+"','"+con.gb2iso("帖子转移移通知")+"','"+con.gb2iso(txt)+"',now(),'n')";
con.update(massage);
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../display.jsp?bdid="+mvid+"&bbsid="+bbsid+"\"><br><br><center><font color=#ff0000>帖子转移成功<br><a href=\"../display.jsp?bdid="+mvid+"&bbsid="+bbsid+"\">点击此处跳过系统等待</a></font></center>");
}else{
response.sendRedirect("../index.jsp");
}
%>