countaccnum.java

来自「可以实现网站中用于统计网站每日访问量的一个实例」· Java 代码 · 共 36 行

package com.count.Online;

import java.sql.*;
import java.util.Date;
public class CountAccNum {
	private int year=1900;
	private int month=1;
	private int day=1;
	public CountAccNum(){}
    private void getYMD(Date nowdate){
    	this.year=nowdate.getYear()+1900;
    	this.month=nowdate.getMonth()+1;
    	this.day=nowdate.getDate();
    }
	public void addtimes(Date nowdate){
		getYMD(nowdate);
		DB db=new DB();
		String searchsql="select * from tb_accnum where time_y="+year+" and time_m="+month+" and time_d="+day;
		System.out.println("searchsql:"+searchsql);
		String updatesql="update tb_accnum set time_accnum=time_accnum+1 where time_y="+year+" and time_m="+month+" and time_d="+day;
		System.out.println("updatesql:"+updatesql);
		String insertsql="insert into tb_accnum values("+year+","+month+","+day+",1)";
		System.out.println("insertsql:"+insertsql);
		try{
			ResultSet rs=db.search(searchsql);
			if(!rs.next()){
				db.dosql(insertsql);
			}
			else{
				db.dosql(updatesql);
			}
			db.closed();
		}catch(Exception e){e.printStackTrace();}
	}
}