addfriend.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);
String fid=request.getParameter("fid");fid=ht.donull(fid);
String fname="";
String sql;
ResultSet rs;

if(fid.compareTo("")==0 || id.compareTo("")==0 || fid.compareTo(id)==0){
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../index.jsp\"><center><font color=#FF0000><strong>参数错误</strong></font></center>");
}else{

sql="select name from user where userid='"+fid+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()==0){
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../friendadmin.jsp\"><center><font color=#FF0000><strong>该会员不存在</strong></font></center>");
}else{
fname=con.getStr(rs.getString(1));
con.close();

sql="select isfriend from friend where userid='"+id+"' and friendid='"+fid+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
if(rs.getString(1).compareTo("y")==0){
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../friendadmin.jsp\"><center><font color=#FF0000><strong>您已经将该会员加入好友了</strong></font></center>");

}

if(rs.getString(1).compareTo("n")==0){
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../friendadmin.jsp\"><center><font color=#FF0000><strong>您已经将会员加入黑名单了</strong></font></center>");

}
}else{

sql="insert into friend values(0,'"+id+"','"+con.gb2iso(name)+"','"+fid+"','"+con.gb2iso(fname)+"','y')";
con.update(sql);
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../friendadmin.jsp\"><center><font color=#FF0000><strong>加入好友成功</strong></font></center>");
}
}
}
%>