actreply.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);

request.setCharacterEncoding("gb2312");
String bdid=request.getParameter("bdid");
String bbsid=request.getParameter("bbsid");
String title=request.getParameter("title");
String txt=request.getParameter("text");
String ip=request.getRemoteAddr();
String pn=request.getParameter("pn");
String penname="";
String pn1="";
String pn2="";
String table="";
String retable="";
String locked="";
String main="main.jsp";
String display="display.jsp";
int count;

if(id.compareTo("")==0){
    response.sendRedirect("../login.jsp");
}else{

    String bdsql="select btable, page from board where id="+bdid;
    ResultSet bd=con.query(bdsql);bd.next();
    if(bd.getRow()==0){out.print(bdsql);
//	    response.sendRedirect("../first.jsp");
	}else{
        table=bd.getString(1);
        retable="re"+table;
		main=bd.getString(2)+"main.jsp";
		display=bd.getString(2)+"display.jsp";

        String bbssql="select locked, retimes from "+table+" where id="+bbsid;
        ResultSet bbs=con.query(bbssql);bbs.next();
        if(bbs.getRow()==0){response.sendRedirect("first.jsp");}else{
            locked=bbs.getString(1);
            if("y".equals(locked)){
			    out.print("<br><center><font color=#FF0000>对不起，您要恢复的帖子已琐定！</font></center>");
            }else{
                String pnsql="select penname1, penname2 from online where userid='"+id+"'";
                ResultSet pnrs=con.query(pnsql);pnrs.next();
                if(pnrs.getRow()!=0){
                    pn1=pnrs.getString(1);
                    pn2=pnrs.getString(2);
                }
                con.close();
               
			    if("penname1".equals(pn)&&pn1.compareTo("")!=0){
                   penname=pn1;
                }
                if("penname2".equals(pn)&&pn2.compareTo("")!=0){
                    penname=pn2;
                }

                String sql="INSERT INTO "+retable+" VALUES(0,"+bbsid+","+bdid+",'"+con.gb2iso(title)+"','"+con.gb2iso(txt)+"','"+id+"','"+con.gb2iso(name)+"',now(),'0000-00-00 00:00:00','"+ip+"','"+penname+"','','')";
                con.update(sql);

                count=bbs.getInt(2)+1;
                String upd="UPDATE "+table+" SET lastid='"+id+"', lastname='"+con.gb2iso(name)+"', retimes ="+count+", lastretime=NOW() WHERE id="+bbsid;
                con.update(upd);

                String addpoint="SELECT re, point FROM online WHERE userid='"+id+"'";
                ResultSet addrs=con.query(addpoint);addrs.next();
                int recount=addrs.getInt(1)+1;
                int point=addrs.getInt(2)+1;

                String uppoint="UPDATE online SET re="+recount+", point="+point+" WHERE userid='"+id+"'";
                con.update(uppoint);

               response.sendRedirect("../"+display+"?bdid="+bdid+"&bbsid="+bbsid);
            }
        }
    }
}
%>