acteinform.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 root=(String)session.getAttribute("root");root=ht.donull(root);
request.setCharacterEncoding("gb2312");
String mid=request.getParameter("id");
String txt=request.getParameter("text");txt=ht.donull(txt);
String title=request.getParameter("title");title=ht.donull(title);
String sql;

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

if(step<3){
out.print("<meta http-equiv=\"refresh\" content=\"2;URL=../index.jsp\"><br><br><center><font color=#FF0000><strong>您无权修改此公告信息</strong></font></center>");
}else{

if(!ht.isNumber(mid)){
out.print("<br><br><center><font color=#FF0000><strong>参数错误！</strong><font></center>");
}else{
sql="select id from massage where id="+mid;
ResultSet rs=con.query(sql);rs.next();
if(rs.getRow()==0){
out.print("<br><center><font color=#FF0000>您要修改的留言不存在</font></center>");
}else{

sql="update massage set title='"+con.gb2iso(title)+"',txt='"+con.gb2iso(txt)+"',time=now() where id="+mid;
con.update(sql);
response.sendRedirect("madmin.jsp");
}
}
}
%>