addsuper.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");id=ht.donull(id);
String name=(String)session.getAttribute("name");name=ht.donull(name);
String root=(String)session.getAttribute("root");id=ht.donull(id);
String bbsid=request.getParameter("bbsid");
String bdid=request.getParameter("bdid");
String table="btable1";
String user_id="";
String user_name="";
String title="";
String board="";
String bdmast="";
int point=0;
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));
bdmast=ht.donull(con.getStr(bd.getString(3)));
String mast[]=ht.split(bdmast,"*");
for(int i=0;i<mast.length-1;i+=2){
if(mast[i].compareTo(id)==0){
ed=true;
}
}
}

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

if(step > 2 || ed){

String sup="update "+table+" set super='y' where id="+bbsid;
con.update(sup);

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 usql="select point from online where userid='"+user_id+"'";
ResultSet usrs=con.query(usql);usrs.next();
if(usrs.getRow()!=0){
point=usrs.getInt(1)+30;
}

String uppoint="update online set point="+point+" where userid='"+user_id+"'";
con.update(uppoint);

if(id.compareTo("")==0){id="numb1";}
if(name.compareTo("")==0){name="站长";}

String mt=board+"版精华通知";
String txt="恭喜您！您在南部湾论坛"+board+"版发表的《"+title+"》已被加入精华区，您将获得了三十点积分作为奖励！希望您能继续发扬!";
String massage="insert into mas values('','"+user_id+"','"+user_name+"','"+id+"','"+con.gb2iso(name)+"','"+con.gb2iso(mt)+"','"+con.gb2iso(txt)+"',now(),'n')";
con.update(massage);
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=../display.jsp?bdid="+bdid+"&bbsid="+bbsid+"\"><br><br><center><font color=#ff0000>添加精华成功<br><a href=\"../display.jsp?bdid="+bdid+"&bbsid="+bbsid+"\">点击此处跳过系统等待</a></font></center>");
}else{
response.sendRedirect("../index.jsp");
}
%>