softdown.jsp

jsp+oracle 网站开发实例精解.源码是下载程序.某公司网站全程序.

<%@ include file="conn.jsp"%>
<%@  page  import="java.util.*,  java.text.*"  %>
<%@ page import="java.util.Calendar" %> 
<%String id=request.getParameter("id");
//更新每周每日数据
	java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd-M月- yyyy"); 
java.util.Date currentTime_1 = new java.util.Date(); 
	stmt.executeUpdate("update scott.download set  dayhits=dayhits+1,hits=hits+1 where lasthits>='"+formatter.format(currentTime_1)+"' and id='"+id+"'");
%>

    <%! String year; 
   String month; 
%> 
<% month=request.getParameter("month"); 
   year =request.getParameter("year"); 
Calendar thisMonth=Calendar.getInstance(); 
  if(month!=null&&(!month.equals("null"))) 
   thisMonth.set(Calendar.MONTH, Integer.parseInt(month) ); 
  if(year!=null&&(!year.equals("null"))) 
   thisMonth.set(Calendar.YEAR, Integer.parseInt(year) ); 
  year=String.valueOf(thisMonth.get(Calendar.YEAR)); 
month=String.valueOf(thisMonth.get(Calendar.MONTH)); 
thisMonth.setFirstDayOfWeek(Calendar.SUNDAY); 
thisMonth.set(Calendar.DAY_OF_MONTH,1); 
int firstIndex=thisMonth.get(Calendar.DAY_OF_WEEK)-1; 
int maxIndex=thisMonth.getActualMaximum(Calendar.DAY_OF_MONTH); 

int dayOfWeek = thisMonth.get(thisMonth.DAY_OF_WEEK); 
stmt.executeUpdate("update scott.download set  weekhits=weekhits+1 where lasthits>=sysdate-"+dayOfWeek+" and id='"+id+"'");
stmt.executeUpdate("update scott.download set  lasthits=sysdate where id='"+id+"'");
  
String sql="select * from scott.download where id = '" + request.getParameter("id") + "'"; 
ResultSet rs=stmt.executeQuery(sql); 
   if(rs.next()){

	String url1="";
	
	url1=rs.getString("filename");
	
  response.sendRedirect(url1); 

}

%>