count.java

来自「用jsp+javebean+access编写的 页面和阿江（ASP）写的记数器很」· Java 代码 · 共 69 行

package sds;

import java.sql.*;
import java.io.*;
import java.util.*;


public class count{

Connection conn=null;

//连结数据库;
public java.sql.Connection getconn(){
  try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E://www//counts//data//stats.mdb";
    conn= DriverManager.getConnection(url);
    }    
    catch(Exception e){
    e.printStackTrace();
    }
    return this.conn;
}

//设置时间
public String getyear(){

java.text.DateFormat year = new java.text.SimpleDateFormat("yyyy") ;

String dateyear = year.format(new java.util.Date()) ;

return dateyear;

}

public String getmonth(){

java.text.DateFormat month = new java.text.SimpleDateFormat("MM") ;

String datemonth = month.format(new java.util.Date()) ;

return datemonth;

}

public String getday(){

java.text.DateFormat day = new java.text.SimpleDateFormat("dd") ;

String dateday = day.format(new java.util.Date()) ;

return dateday;

}

//更新数据;
public void update(String sql1){
  
  try{
   Connection con1=getconn();
   Statement stmt1=con1.createStatement();
   stmt1.executeUpdate(sql1);
   con1.close();
   stmt1.close();
  }catch(Exception ex){
}
}

}