import java.sql.*;
import java.text.*;

/**
* 代碼
*/

public class msaccessdb  {
  public static simpledateformat sd=new simpledateformat("mmm dd yyyy");
  private preparedstatement pstmt=null;
  private statement stmt=null;
  private connection msconn=null;

  public msaccessdb() {
    try {
      jbinit();
      int userid=1;
      listlogindata();//列出用戶信息,上次登錄時間...
      updateuserlogin(userid);//更新用戶表中的信息，登錄時間...
      listlogindata();//再次顯示用戶信息，以便對比
    }
    catch(exception e) {
      e.printstacktrace();
    }
  }
  private void listlogindata() throws sqlexception {
    resultset rs=stmt.executequery("select * from user_table");
    while (rs.next()) {
      system.out.print(rs.getint("user_id")+"/t");
      system.out.print(rs.getstring("nick_name")+"/t");
      system.out.print(rs.getstring("last_name")+"/t");
      system.out.print(rs.getstring("first_name")+"/t");
      system.out.print(sd.format(rs.getdate("last_access_date"))+"/n");
    }
  }
  private void updateuserlogin(int userid) throws sqlexception {
    java.sql.date today=new java.sql.date(system.currenttimemillis());
    pstmt.setdate(1,today);
    pstmt.setint(2,userid);
    pstmt.executeupdate();
  }
  private void jbinit() throws exception {
    class.forname("sun.jdbc.odbc.jdbcodbcdriver");
    msconn=drivermanager.getconnection("jdbc:odbc:test_db;;;");
    string psstr="update user_table set last_access_date=? where user_id=?";
    pstmt=msconn.preparestatement(psstr);
    stmt=msconn.createstatement();
  }

  public static void main(string[] args) {
    msaccessdb mdb=new msaccessdb();
  }
}