actsend.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 acid=request.getParameter("acid");acid=ht.donull(acid);
String txt=request.getParameter("text");txt=ht.donull(txt);
String title=request.getParameter("title");title=ht.donull(title);
String ac_name="";
String sql;
ResultSet rs;

int c=6;

if(id.compareTo("")==0){
    c=1;
}

if(id.compareTo(acid)==0){
c=2;
}


sql="select name,refusemassage from user where userid='"+acid+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()==0){
c=3;
}else{
ac_name=con.getStr(rs.getString(1));
if(rs.getString(2).compareTo("y")==0){
c=4;
}
}
con.close();

sql="select id from friend where friendid='"+id+"' and userid='"+acid+"'and isfriend='n'";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
c=5;
}
con.close();

switch(c){
case 1:
    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>");
    break;
case 2:
    out.print("<br><center><font color=#FF0000>您不能给您自己留言。</font></center>");
    break;
case 3:
    out.print("<br><center><font color=#FF0000>您要留言的用户不存在，请选择您要留言的用户！</font></center>");
	break;
case 4:
    out.print("<br><center><font color=#FF0000>该用户拒绝拒绝接受留言</font></center>");
    break;
case 5:
    out.print("<br><center><font color=#FF0000>该用户拒绝拒绝接受您留言</font></center>");
    break;
default:
sql="insert into massage values(0,'"+acid+"','"+con.gb2iso(ac_name)+"','"+id+"','"+con.gb2iso(name)+"','"+con.gb2iso(title)+"','"+con.gb2iso(txt)+"',now(),0)";
con.update(sql);
con.close();
response.sendRedirect("madmin.jsp");
}

%>