delfriend.jsp

jsp做的一个论坛

<%@ 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="checkbbsuser.jsp"%>
<%@ include file="../inc/conn.jsp"%>
<%!String sql,strsql,strDest;%>
<%
String postuser = new String(request.getParameter("postuser").getBytes("iso-8859-1"));
sql="select * from clubuser where clubuser_name='"+session.getAttribute("name")+"'";
ResultSet rs=stmt.executeQuery(sql);
rs.next();

String strSource=rs.getString("friend");
String strFrom="|"+postuser;
String strTo="";
int intFromLen = strFrom.length(); 
int intPos; 
while((intPos=strSource.indexOf(strFrom))!=-1){ 
strDest = "";
strDest = strDest + strSource.substring(0,intPos); 
strDest = strDest + strTo; 
strSource = strSource.substring(intPos+intFromLen); 
} 
strDest = strDest + strSource; 
strsql="update clubuser set friend='"+strDest+"' where clubuser_name='"+session.getAttribute("name")+"'";
stmt.executeUpdate(strsql);
//out.print("<script language='javascript'>");
//out.print("alert('删除成功！');");
//out.print("history.go(-1);");
//out.print("</script>");
//out.close();
response.sendRedirect("myfriend.jsp");
//conn.clsoe;
%>