adminbean.java

JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计

package bean;


import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.GregorianCalendar;

public class AdminBean {
	Connection conn=null;
	Statement st=null;
	ResultSet rs=null;
	
	/**
	 * 页面受欢迎度统计
	 * @return
	 */
	public ArrayList pageWelcome(){
		
		ArrayList col = null;
		ArrayList al = new ArrayList();
		
		try{
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select type,count(*) from pagecount group by type");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}
	
	/**
	 * 今日小时段统计
	 * @return
	 */
	public ArrayList hourstat(){
		
		ArrayList al = new ArrayList();
		ArrayList col = null;
		try{
			Calendar dd = new GregorianCalendar();
			int year = dd.get(Calendar.YEAR);
			int month = 1 + dd.get(Calendar.MONTH);
			int day = dd.get(Calendar.DAY_OF_MONTH);
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select hour,count(*) from count where year='"+year+"' and month='"+month+"' and day='"+day+"' group by hour");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}
	
	/**
	 * 今日访问访次统计
	 * @return
	 */
	public ArrayList numstat(){
		
		ArrayList col = new ArrayList();
		
		try{
			Calendar dd = new GregorianCalendar();
			int year = dd.get(Calendar.YEAR);
			int month = 1 + dd.get(Calendar.MONTH);
			int day = dd.get(Calendar.DAY_OF_MONTH);
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select count(*) from count where year='"+year+"' and month='"+month+"' and day='"+day+"'");
			
			if(rs.next()){
				col.add(rs.getString(1));
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return col;
	}
	
/**
 * 日统计报表
 * @return
 */
public ArrayList daystat(String year,String month,String day){
		
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select * from count where year='"+year+"' and month='"+month+"' and day='"+day+"'");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(2));
				col.add(rs.getString(3));
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				col.add(rs.getString(6));
				col.add(rs.getString(7));
				col.add(rs.getString(8));
				col.add(rs.getString(9));
				col.add(rs.getString(10));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 周统计报表
 * @return
 */
public ArrayList weekstat(int year,int month,int week){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
	String day = "";
	String temp = "";
	String sql = "";
	
	try{

		DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
/*			Calendar c = Calendar.getInstance();
			c.set(Calendar.YEAR, year);
			c.set(Calendar.MONTH, month - 1);
			c.set(Calendar.WEEK_OF_MONTH,week);
*/
		Calendar c1 = Calendar.getInstance();
		c1.set(Calendar.YEAR, year);
		c1.set(Calendar.MONTH, month - 1);
		c1.set(Calendar.WEEK_OF_MONTH,week);
		Calendar   cpcalendar=(Calendar)c1.clone();  //++ 
		cpcalendar.set(Calendar.DAY_OF_WEEK,   Calendar.MONDAY);//++

		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));//++
		System.out.println("该周第一天是[" + temp + "]");
		String change1[]=temp.split("-");
		day = day+change1[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第二天是[" + temp + "]");
		String change2[]=temp.split("-");
		day = day+change2[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第三天是[" + temp + "]");
		String change3[]=temp.split("-");
		day = day+change3[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第四天是[" + temp + "]");
		String change4[]=temp.split("-");
		day = day+change4[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第五天是[" + temp + "]");
		String change5[]=temp.split("-");
		day = day+change5[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第六天是[" + temp + "]");
		String change6[]=temp.split("-");
		day = day+change6[2]+",";
		
		cpcalendar.add(Calendar.DATE,1);   
		temp = df.format(   new   Date(cpcalendar.getTimeInMillis()));
		System.out.println("该周第七天是[" + temp + "]");
		String change7[]=temp.split("-");
		day = day+change7[2];

         sql ="select * from count where year in("+year+") and month in("+month+") and day in("+day+")";
         
         System.out.println(sql);
         
         conn=DBConn.getConn();
         st=conn.createStatement();
         rs=st.executeQuery(sql);
         
         while(rs.next()){
        	 
        	col = new ArrayList();
        	col.add(rs.getString(2));
			col.add(rs.getString(3));
			col.add(rs.getString(4));
			col.add(rs.getString(5));
			col.add(rs.getString(6));
			col.add(rs.getString(7));
			col.add(rs.getString(8));
			col.add(rs.getString(9));
			col.add(rs.getString(10));
        	 
        	al.add(col);
         }
	
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		close();
	}
	return al;
}

/**
 * 月统计报表
 * @return
 */
public ArrayList monthstat(String year,String month){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select * from count where year='"+year+"' and month='"+month+"'");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(2));
				col.add(rs.getString(3));
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				col.add(rs.getString(6));
				col.add(rs.getString(7));
				col.add(rs.getString(8));
				col.add(rs.getString(9));
				col.add(rs.getString(10));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 年统计报表
 * @return
 */
public ArrayList yearstat(String year){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select * from count where year='"+year+"'");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(2));
				col.add(rs.getString(3));
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				col.add(rs.getString(6));
				col.add(rs.getString(7));
				col.add(rs.getString(8));
				col.add(rs.getString(9));
				col.add(rs.getString(10));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 今日全部访问列表
 * @return
 */
public ArrayList dayallstat(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{
			Calendar dd = new GregorianCalendar();
			int year = dd.get(Calendar.YEAR);
			int month = 1 + dd.get(Calendar.MONTH);
			int day = dd.get(Calendar.DAY_OF_MONTH);
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select * from count where year='"+year+"' and month='"+month+"' and day='"+day+"'");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(2));
				col.add(rs.getString(3));
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				col.add(rs.getString(6));
				col.add(rs.getString(7));
				col.add(rs.getString(8));
				col.add(rs.getString(9));
				col.add(rs.getString(10));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 最近100位访问者
 * @return
 */
public ArrayList near(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{

			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select top 100 * from count order by year desc ");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(2));
				col.add(rs.getString(3));
				col.add(rs.getString(4));
				col.add(rs.getString(5));
				col.add(rs.getString(6));
				col.add(rs.getString(7));
				col.add(rs.getString(8));
				col.add(rs.getString(9));
				col.add(rs.getString(10));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 用户操作系统统计
 * @return
 */
public ArrayList czxt(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{

			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select czxt,count(*) from count group by czxt");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 用户浏览器统计
 * @return
 */
public ArrayList llq(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{

			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select llq,count(*) from count group by llq");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 屏幕分辨率统计
 * @return
 */
public ArrayList pmfbl(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{

			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select pmfbl,count(*) from count group by pmfbl");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 访问者地址统计
 * @return
 */
public ArrayList address(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
		
		try{

			
			conn=DBConn.getConn();
			st=conn.createStatement();
			rs=st.executeQuery("select address,count(*) from count group by address");
			
			while(rs.next()){
				
				col = new ArrayList();
				col.add(rs.getString(1));
				col.add(rs.getString(2));
				
				al.add(col);
			}
		
		
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			close();
		}
		return al;
	}

/**
 * 历史小时段统计
 * @return
 */
public ArrayList agohourstat(){
	
	ArrayList al = new ArrayList();
	ArrayList col = null;
	
	try{
		Calendar dd = new GregorianCalendar();
		int day = dd.get(Calendar.DAY_OF_MONTH);
		
		conn=DBConn.getConn();
		st=conn.createStatement();
		rs=st.executeQuery("select hour,count(*) from count where day<>'"+day+"' group by hour");
		
		while(rs.next()){
			
			col = new ArrayList();
			col.add(rs.getString(1));
			col.add(rs.getString(2));
			
			al.add(col);
		}
	
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		close();
	}
	return al;
}


/**
 * 关闭数据库
 *
 */
public void close(){
	try{
		if(rs!=null)rs.close();
		if(st!=null)st.close();
		if(conn!=null)conn.close();
	}catch(Exception ee){
		ee.printStackTrace();
	}
}

}