enemydel.jsp

现今的社会是一个信息飞速发达的社会

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<%
String id=null;id=(String)session.getAttribute("id");
String mm=null;mm=(String)session.getAttribute("password");
String friendid=request.getParameter("fid");
String isf="";
String log="select mail from numb1 where userid='"+id+"' and pw='"+mm+"'";
ResultSet rs=con.query(log);rs.next();
if(rs.getRow()==0){
response.sendRedirect("login.jsp");
}


if(friendid==null||id==null){
out.print("<br><br><center><font color=#FF0000>请选择您要删除的黑名单的会员</font></center>");
}else{

String sql1="select*from friend where userid='"+id+"' and friendid='"+friendid+"' and isfriend='n'";
ResultSet rs1=con.query(sql1);rs1.next();
if(rs1.getRow()!=0){

String sql="delete from friend where userid='"+id+"' and frinedid='"+friendid+"' and isfriend='n'";
con.update(sql);
out.print("");
}

}
%>