addfav.jsp

JSP+ORACLE网站开发实例（下）.rar

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

out.print("<SCRIPT language=JavaScript>alert('["+iname+"]成功添加到收藏夹！');");
out.print("javascript:history.go(-1);</SCRIPT>");
                            }
                   }
}
%>