favorties.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;
String id = request.getParameter("id"); 
sql="select top 1 * from ftbbs_favorites where clubuser_name='"+username+"' and bbstitleid="+id;
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs3=stmt3.executeQuery(sql);
if(rs3.next()){
    out.print("<script language='javascript'>");
    out.print("alert('你已经收藏过该贴子!');");
    out.print("history.go(-1);");
    out.print("</script>");
    out.close();
}
else{
    String str="insert into ftbbs_favorites (clubuser_name,bbstitleid,typesign) values('" + username + "',"+id+",0)";
    stmt.executeUpdate(str);
	response.sendRedirect("ftbbs.jsp?id="+id);
}
stmt.close(); 
conn.close();
%>