<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"  %>
<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("gb2312");
String sql="select softname,downurl,jb from download where id='"+request.getParameter("softid")+"'";
ResultSet rs=stmt.executeQuery(sql);
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2="Update download set hits=hits+1 where id='"+request.getParameter("softid")+"'";
if(rs.next()){
 if(rs.getString("jb").equals("免費軟件")){
 stmt2.executeUpdate(sql2);
 // 得到文件名字和路徑 
 String file = rs.getString("downurl"); 
 //out.print(file);
 // 設置響應頭和下載保存的文件名 
// response.setContentType("APPLICATION/OCTET-STREAM"); 
// response.setHeader("Content-Disposition","attachment; file=' + file + '"); 
response.setHeader("Content-Disposition","attachment; "); 
response.sendRedirect(file);
 // 打開指定文件的流信息 
/* java.io.FileInputStream fileInputStream = new java.io.FileInputStream(file); 
  
 // 寫出流信息 
 int i; 
 while ((i=fileInputStream.read()) != -1) { 
  out.write(i); 
 } 
 fileInputStream.close(); 
 out.close(); */
 }else{
 	//if(session.getAttribute("IsMem")==null|session.getAttribute("IsMem")==""){
	Cookie cookies[]=request.getCookies();
	if(cookies==null){
 	String msg="您尚未登陸，請<a href=login.jsp><b>登陸</b></a>后下載";
 	}else{
	 stmt2.executeUpdate(sql2);
 	 // 得到文件名字和路徑 
 	String file = rs.getString("downurl"); 
 
	 // 設置響應頭和下載保存的文件名 
	 //response.setContentType("APPLICATION/OCTET-STREAM"); 
	 //response.setHeader("Content-Disposition",  "attachment; file=\"" + file + "\""); 
    response.setHeader("Content-Disposition","attachment; "); 
    response.sendRedirect(file);
 	// 打開指定文件的流信息 
 	/*java.io.FileInputStream fileInputStream = new java.io.FileInputStream(file); 
  
 	// 寫出流信息 
	 int i; 
	 while ((i=fileInputStream.read()) != -1) { 
 	 out.write(i); 
	 } 
 	fileInputStream.close(); 
	 out.close(); */
 }
 }
}
%>