softdown.jsp

来自「该程序已经集成了两个数据库」· JSP 代码 · 共 59 行

<%@ 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(); */
 }
 }
}
%>