counter.java

JSP新闻发布系统 JSP新闻发布系统

package net.ijsp.news.online;

/**
 * <p>Title:计数器 </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: ijsp.net</p>
 * @author ccjsmile
 * @version 1.0
 */

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){
                        }
                }
   }
}