download.jsp

这是一个在线教育系统

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String sql;
String id=request.getParameter("id");

sql="select * from scott.main where mainid="+id; 
ResultSet  rs=stmt.executeQuery(sql); 
  if(!rs.next()){
out.print("<SCRIPT language=JavaScript>alert('没有找到您要阅读的资料！');");
   out.print("window.close();</SCRIPT>"); 
  }else{

 response.sendRedirect(rs.getString("fileurl")); 
  }
%>