acteditslave.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 root=(String)session.getAttribute("root");root=ht.donull(root);

request.setCharacterEncoding("gb2312");
String bdid=request.getParameter("bdid");
String bbsid=request.getParameter("bbsid");
String reid=request.getParameter("reid");
String title=request.getParameter("title");
String txt=request.getParameter("text");
String ip=request.getRemoteAddr();
String pn=request.getParameter("pn");
String p1="";
String p2="";
String user_id="";
String penname="";
String table="";
String dispaly="display.jsp";
String string="";

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="re"+bdrs.getString(1);
display=bbsrs.getString(2)+"display.jsp";
string="<meta http-equiv=\"refresh\" content=\"3;URL=../"+display+"?id="+bdid+"&bbsid="+bbsid+"\"><br><br><br><table width=360 border=0 align=center cellspacing=1 bgcolor=#7188e0><tr><th height=20><font color=#FFFFFF>回 贴 成 功！</font></th></tr><tr><td bgcolor=#FFFFFF><table width=88% border=0 align=center><tr><td><p>返回论坛首页</p><p>返回</p><p><a href=../"+display+"?id="+bdid+"&bbsid="+bbsid+">您发的帖子......３秒后返回您发的帖子</a></p></td></tr></table></td></tr></table>";
String sqlb="select userid from "+table+" where id="+reid;
ResultSet rrs=con.query(sqlb);rrs.next();
if(rrs.getRow()!=0){
user_id=rrs.getString(1);
}
if(root.compareTo("")==0){root="0";}
int step=Integer.parseInt(root);
if(step>3 || id.compareTo(user_id)==0){

String pnsql="select penname1,penname2 from online where userid='"+id+"'";
ResultSet pnrs=con.query(pnsql);pnrs.next();
if(pnrs.getRow()!=0){
p1=pnrs.getString(1);
p2=pnrs.getString(2);
}
pn=ht.donull(pn);
if(pn.compareTo("penname1")==0){
penname=",penname='"+p1+"'";
}
if(pn.compareTo("penname2")==0){
penname=",penname='"+p2+"'";
}
if(pn.compareTo("no")==0){
penname=",penname=''";
}

String sql="update "+table+" set retitle='"+con.gb2iso(title)+"',txt='"+con.gb2iso(txt)+"', editime=now(),ip='"+ip+"'"+penname+" where id="+reid;
con.update(sql);

out.print(string);
}else{out.print("对不起，您无权修改此贴！");}
}
%>