agree.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="checkbbsuser.jsp"%>
<%!String sql,myname,str;%>
<%!int id;%>
<%!ResultSet rs3;%>
<%
//String id = request.getParameter("id");
id=Integer.parseInt(request.getParameter("id"));
String postuser = request.getParameter("postuser"); 

sql="select friend from clubuser where clubuser_name='"+username+"'";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs3=stmt3.executeQuery(sql);
if(rs3.next()){
  myname=rs3.getString("friend");
	   if(myname.indexOf(username)!=-1)
	   {
	    str="delete from sms where id="+id;
        stmt.executeUpdate(str);
        out.print("<script language='javascript'>");
        out.print("alert('你已经加入了该用户为好友！');");
        out.print("history.go(-1);");
        out.print("</script>");
		out.close();
	   }
	   else{
		 postuser=rs3.getString("friend")+postuser+"|";
         str="update clubuser set friend='"+postuser+"' where clubuser_name='"+username+"'";
         stmt.executeUpdate(str);
		 str="delete from sms where id="+id;
         stmt.executeUpdate(str);
        out.print("<script language='javascript'>");
        out.print("alert('加入成功！');");
        out.print("history.go(-1);");
        out.print("</script>");
        out.close();
	   } 
}
stmt.close(); 
conn.close();
%>