countdaoimpl.java

刚学JAVA不到一个月

package count;

import java.io.Serializable;
import java.sql.*;
import javax.sql.*;
import java.util.Date;
import java.text.*;

public class CountDAOImpl{
	
         String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
         String sConnStr = "jdbc:odbc:mycount";
         private Connection conn = null;
         private Statement stmt = null;
         private PreparedStatement perstmt=null;
         ResultSet rs = null;
	 Count count = null;
	 String sql="select * from count";
         SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd"); 
         DateFormat df = DateFormat.getDateInstance(); 
 

	
	 public CountDAOImpl() {
	     try {
                        Class.forName(sDBDriver); 
                        conn = DriverManager.getConnection(sConnStr); 
                        stmt = conn.createStatement();
 
                        ResultSet rs = stmt.executeQuery(sql);
                        while(rs.next()){
                          String createDate1=rs.getString("createdate");
        	          String maxDate1=rs.getString("maxdate");	
	                  String todayDate1=rs.getString("todayDate");
                           Date createDate = df.parse(createDate1); 
                           Date maxDate=df.parse(maxDate1);
                           Date todayDate=df.parse(todayDate1);
	                  int allCount=rs.getInt("allcount");	
	                  int avgCount=rs.getInt("avgcount");	
	                  int maxCount=rs.getInt("maxcount");	
	                  int todayCount=rs.getInt("todaycount");
                          
    count=new Count(allCount,todayCount, avgCount, maxCount, todayDate, maxDate, createDate);
                        }
                        stmt.close();
                        conn.close();
                            
             }
              catch(java.lang.ClassNotFoundException e) {
                    System.err.println(e.getMessage());
              }catch(SQLException e){
                     System.err.println(e.getMessage());
             }catch(ParseException e) { 
         System.out.println("Unable to parse " + df); 
      } 

	

   }
	
	
	
	
	public Count getCount() {
		             
		return count;
	}

	
	public final void updateCount(final Count arg) {

                          Date createDate1=arg.getCreateDate();
        	          Date maxDate1=arg.getMaxDate();	
	                  Date todayDate1=arg.getTodayDate();
                          String createDate=sf.format(createDate1);
                          String maxDate=sf.format(maxDate1);
                          String todayDate=sf.format(todayDate1);
	                  int allCount=arg.getAllCount();	
	                  int avgCount=arg.getAvgCount();	
	                  int maxCount=arg.getMaxCount();	
	                  int todayCount=arg.getTodayCount();
                         try{
                          Class.forName(sDBDriver); 
                       
                         conn = DriverManager.getConnection(sConnStr); 
                         stmt = conn.createStatement();
       String sql="update count set allcount="+allCount+",todaycount="+todayCount+",avgcount="+avgCount+",maxcount="+maxCount+",todaydate='"+todayDate+"',maxdate='"+maxDate+"',createdate='"+createDate+"' where id=1";
      stmt.executeUpdate(sql);
  }catch(java.lang.ClassNotFoundException e) {
                    System.err.println(e.getMessage());
              }catch(SQLException e){
                     System.err.println(e.getMessage());
	}
                

		
	}
}