addfav.jsp

来自「jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码」· JSP 代码 · 共 33 行

<% String puid= (String) session.getValue("puid"); 
if((puid==null)|(puid=="")){
 
   out.print("<SCRIPT language=JavaScript>alert('操作超时，请重新登录！');");
   out.print("this.location.href='../default.jsp';</SCRIPT>"); 
    }
%>
<%@ include file="../conn.jsp"%>
<% 
 request.setCharacterEncoding("GB2312");
String cname;
String uname= (String) session.getValue("puid"); 
String fav=request.getParameter("fav");
if(fav!=null){
String sql="select * from scott.company where uname='"+fav+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
         if(!rs.next()){
out.print("<SCRIPT language=JavaScript>alert('用户["+fav+"]不存在！');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{
	cname=rs.getString("cname");
String sql1="select * from scott.pfavorite where uname='"+uname+"'and fuid='"+fav+"'"; 
ResultSet rs1=stmt.executeQuery(sql1); 
           if(rs1.next()){
out.print("<SCRIPT language=JavaScript>alert('["+cname+"]已添加到收藏夹，请勿重复添加！');");
out.print("javascript:history.go(-1);</SCRIPT>");
  }else{
 stmt.executeUpdate("INSERT INTO scott.pfavorite(id,uname,fuid) VALUES(scott.pfavoriteid.nextval,'"+uname+"', '"+fav+"')");
out.print("<SCRIPT language=JavaScript>alert('["+cname+"]成功添加到收藏夹！');");
out.print("javascript:history.go(-1);</SCRIPT>");
                            }
                   }
}%>