pagecount.java

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

package bean;


import java.sql.*;
import java.util.Calendar;
import java.util.GregorianCalendar;

public class PageCount {
	
	public void count(String ip,String address,String dc){
		
		Connection conn=null;
		Statement st=null;
		//ResultSet rs=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);
			int hour = dd.get(Calendar.HOUR_OF_DAY);
			int minute = dd.get(Calendar.MINUTE);
			int second = dd.get(Calendar.SECOND);
			
			String date = year+"-"+month+"-"+day+" "+hour+":"+minute+":"+second;
			
			conn=DBConn.getConn();
			st=conn.createStatement();
			st.executeUpdate("insert into pagecount values('"+ip+"','"+address+"','"+date+"','"+dc+"')");
			System.out.println("调查结果已提交");
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				//if(rs!=null)rs.close();
				if(st!=null)st.close();
				if(conn!=null)conn.close();
			}catch(Exception ee){
				ee.printStackTrace();
			}
		}

	}

}