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

if(fid.compareTo("")==0||id.compareTo("")==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 id from friend where userid='"+id+"' and id="+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{
sql="delete from friend where userid='"+id+"' and id="+fid;
con.update(sql);
out.print("<br><br><meta http-equiv=\"refresh\" content=\"1;URL=../friendadmin.jsp\"><center><font color=#FF0000><strong>删除成功</strong></font></center>");
}
}
%>