counter.java

一个用jsp技术实现的新闻发布系统

package net.ijsp.news.online;

/**
* 计数器
*/
import net.ijsp.news.database.*;
import java.sql.*;

public class Counter{

	String createDate,todayDate,maxDate;
	int count,todayCount,maxCount;

	public Counter(String createDate,int count,String todayDate,int todayCount,String maxDate,int maxCount) {
		this.createDate = createDate;
		this.count = count;
		this.todayDate = todayDate;
		this.todayCount = todayCount;
		this.maxDate = maxDate;
		this.maxCount = maxCount;
	}
	public String getCreateDate() {return createDate;}
	public String getTodayDate() {return todayDate;}
	public String getMaxDate() {return maxDate;}
	public int getCount() {return count;}
	public int getTodayCount() {return todayCount;}
	public int getMaxCount() {return maxCount;}

	public static void  add() {
		DBConnect dbc = null;
		try{
			dbc = new DBConnect();
			String sql="UPDATE counter1 SET counter = counter + 1, todayCounter = todayCounter+1 ";
			dbc.prepareStatement(sql);
			dbc.executeUpdate();	
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			try{
				if(dbc!=null)
					dbc.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	
	public static Counter getMsg() {
		DBConnect dbc = null;
		Counter counter = null;
		try{
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM counter1");
			ResultSet rs = dbc.executeQuery();
			if(rs.next()) {
				counter = new Counter(rs.getString("createDate"),
							rs.getInt("counter"),
							rs.getString("todayDate"),
							rs.getInt("todayCounter"),
							rs.getString("maxDate"),
							rs.getInt("maxCounter")
						);
			}
		}catch(Exception e){
			System.err.println(e);
		}finally{
			try{
				if(dbc!=null)
					dbc.close();
			}catch(Exception e){}
		}
	return counter;
	}
   public static void update(String today) {
		DBConnect dbc = null;
		try{
			dbc = new DBConnect();
			dbc.prepareStatement("update counter1 set todayDate=?,todayCounter=1  where todayDate < ? ");
			dbc.setString(1,today);
			dbc.setString(2,today);
			dbc.executeUpdate();
			dbc.prepareStatement("Update counter1 set maxDate=todayDate, maxCounter=todayCounter+1 where todayCounter > maxCounter ");
			dbc.executeUpdate();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(dbc!=null)
					dbc.close();
			}catch(Exception e){
			}
		}
   }
}