作者：淘特網(wǎng)

出處：http://www. 

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();//列出用戶信息,上次登錄時(shí)間...
      updateUserLogin(userID);//更新用戶表中的信息，登錄時(shí)間...
      listLoginData();//再次顯示用戶信息，以便對(duì)比
    }
    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();
  }
}