?? softdown.jsp
字號:
<%@ 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(); */
}
}
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -