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

if(id.compareTo("")==0){
out.print("<meta http-equiv=\"refresh\" content=\"2;URL=../login.jsp\"><br><br><center><font color=#FF0000>您还没登陆呢？请先<a href=../login.jsp>登录</a>或<a href=../reg.jsp>注册</a></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 toid='"+toid+"' and frid='"+id+"' and 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");
}
}
}
%>