action.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="d" scope="page" class="numb1.com.Dodate"/>
<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("id");
String title=request.getParameter("title");
String txt=request.getParameter("text");
String ip=request.getRemoteAddr();
String clas=request.getParameter("class");clas=ht.donull(clas);
String pn=request.getParameter("pn");
String penname="";
String pn1="";
String pn2="";
String table="";
String main="main.jsp";
String display="display.jsp";

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

    String sqlbd="select btable, page from board where id="+bdid;
    ResultSet bdrs=con.query(sqlbd);bdrs.next();
    if(bdrs.getRow()==0){
        response.sendRedirect("../first.jsp");
    }else{
        table=bdrs.getString(1);
		main=bdrs.getString(2)+"main.jsp";
        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 "+table+" values(0,"+bdid+",'"+con.gb2iso(title)+"','"+clas+"','"+con.gb2iso(txt)+"','n','n','n','n','"+id+"','"+con.gb2iso(name)+"','','',now(),'0000-00-00 00:00:00','"+ip+"',0,0,now(),'"+penname+"','','')";
        con.update(sql);
        String addpoint="select txt, point from online where userid='"+id+"'";
        ResultSet addrs=con.query(addpoint);addrs.next();
        int txtcount=addrs.getInt(1)+1;
        int point=addrs.getInt(2)+2;

        String uppoint="update online set txt="+txtcount+",point="+point+" where userid='"+id+"'";
        con.update(uppoint);
        out.print("<meta http-equiv=\"refresh\" content=\"1;URL=../"+main+"?id="+bdid+"\"><center><font color=#FF0000>发帖成功</font></center>");
    }
}
%>