download.jsp

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

<%@ include file="conn.jsp"%>
<%String sql="select * from scott.download where id = '" + request.getParameter("id") + "'"; 
ResultSet rs=stmt.executeQuery(sql); 
   if(rs.next()){
if((session.getValue("user")==null)&&(rs.getString("club")!=null)){
%>
<script>alert('对不起！此为会员影片，请注册成我们的会员！');window.close();</script>
<%}else{
	String downid="2";
	String url1="";
	if(downid.equals(request.getParameter("downid"))){
	 url1=rs.getString("filename1");
	}
downid="3";
if(downid.equals(request.getParameter("downid"))){
	url1=rs.getString("filename2");
	}
downid="1";
if(downid.equals(request.getParameter("downid"))){
	url1=rs.getString("filename");
	}
  response.sendRedirect(url1); 

}
   }
%>