coun.java

·新闻采用在线编辑器

package popten.web;
			/****************************************
			*  news_title  POPTEN					*
			*  @author: 边缘孤客					*
			*  Company: http://www.popten.com		*
			*  Copyright: Copyright (c) 2002-10-1	*
			*  @version 1.0 beta					*
			****************************************/
import popten.db.DBConnect;
import popten.util.*;
import java.sql.*;
import java.util.*;
public class Coun{
private int all_coun,today_coun,average_coun,max_coun;
private String max_dat;
public int getall_coun() { return all_coun;}
public int gettoday_coun() { return today_coun;}
public int getaverage_coun() { return average_coun;}
public int getmax_coun() { return max_coun;}
public String getmax_dat() { return max_dat;}
public void setall_coun(int all_coun) { this.all_coun = all_coun; }
public void settoday_coun(int today_coun) { this.today_coun = today_coun; }
public void setaverage_coun(int average_coun) { this.average_coun = average_coun; }
public void setmax_coun(int max_coun) { this.max_coun = max_coun; }
public void setmax_dat(String max_dat) { this.max_dat = max_dat; }
	public Coun(){}
	public static void startCoun()throws Exception {
		DBConnect dbc = new DBConnect();
		ResultSet rs;
		try{
		  dbc.prepareStatement("insert into coun set all_coun='0',today_coun='0',average_coun='0',max_coun='0',max_dat=Now(),today=Now(),creat_dat=Now()");
		  dbc.executeUpdate();
		}
		catch(Exception e){
				System.err.println(e);
				  }
		finally{
			try{
				dbc.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}

	}
	/************************
	*		计数器加一		*
	************************/
	public static void addCoun()throws Exception {
		DBConnect dbc = new DBConnect();
		ResultSet rs;
		int all_coun,today_coun,average_coun,max_coun;

		try{
			dbc.prepareStatement("Select * from coun where today=Now()");
			rs=dbc.executeQuery();
			if(rs.next()){
				//all_coun=rs.getInt("all_coun")+1;
				today_coun=rs.getInt("today_coun")+1;
				max_coun=rs.getInt("max_coun");
				//average_coun=all_coun/(Now()-rs.getDate("creat_dat"));
				if(today_coun>max_coun){
					dbc.prepareStatement("update coun set all_coun=all_coun+1,today_coun=today_coun+1,average_coun=round(all_coun/(TO_DAYS(NOW())+1-TO_DAYS(creat_dat))),max_coun=today_coun,max_dat=Now()");
					dbc.executeUpdate();
				}
				else{
					dbc.prepareStatement("update coun set all_coun=all_coun+1,today_coun=today_coun+1,average_coun=round(all_coun/(TO_DAYS(NOW())+1-TO_DAYS(creat_dat)))");
					dbc.executeUpdate();
				}
			}
			else{
				dbc.prepareStatement("update coun set all_coun=all_coun+1,today_coun=1,average_coun=round(all_coun/(TO_DAYS(NOW())+1-TO_DAYS(creat_dat))),today=Now()");
				dbc.executeUpdate();
			}
		}
		catch(Exception e){
				System.err.println(e);
				  }
		finally{
			try{
				dbc.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}

	}
	/************************
	*		读出计数器		*
	************************/
	public Coun loadCoun()throws Exception{
		DBConnect dbc = new DBConnect();
		ResultSet rs;
		Coun coun=new Coun();
		try{
			dbc.prepareStatement("select * from coun");
			rs = dbc.executeQuery();
			if(rs.next()){
				coun.setall_coun(rs.getInt("all_coun"));
				coun.settoday_coun(rs.getInt("today_coun"));
				coun.setaverage_coun(rs.getInt("average_coun"));
				coun.setmax_coun(rs.getInt("max_coun"));
				coun.setmax_dat(rs.getString("max_dat"));
				}
		}
		catch(Exception e){
				System.err.println(e);
				  }
		finally{
			try{
				dbc.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		return coun;
	}
}