最近做个报表管理的小程序,用到java连接access数据库，故把例子贴在这里，以备以后再用到方便查找！

package com.flymz.dbconfig;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection {
String dBdriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String dBuser = "";
String dBpwd = "";
String dBConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=WebRoot/db/yinzuo.mdb";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;
public DBConnection(){
   try {
    Class.forName(dBdriver);
   } catch (java.lang.ClassNotFoundException e) {
    System.err.println("sqlbean();" + e.getMessage());
   }
}
public ResultSet executeQuery(String sql) {
   rs = null;
   try {
    conn = DriverManager.getConnection(dBConnStr, dBuser, dBpwd);
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
   } catch (java.sql.SQLException ex) {
    System.out.println("executeQuery:" + ex.getMessage());
   }
   return rs;
}

public int executeUpdate(String sql) {
   stmt = null;
   rs = null;
   int retval=0;
   try {
    conn = DriverManager.getConnection(dBConnStr);
    stmt = conn.createStatement();
    retval=stmt.executeUpdate(sql);
    stmt.close();
    conn.close();

   } catch (java.sql.SQLException ex) {
    System.out.println("executeUpdate:" + ex.getMessage());
   }
   return retval;
}
public boolean executeDelete(String sql){
   boolean retval=false;
   stmt=null;
   rs=null;
   try {
    conn=DriverManager.getConnection(dBConnStr);
    stmt=conn.createStatement();
    retval=stmt.execute(sql);
   } catch (SQLException ex) {
    System.out.println("executeDelete:" + ex.getMessage());
   }
  
   return retval;
}
public static void main(String[] args){
   DBConnection conn=new DBConnection();
   ResultSet rs=conn.executeQuery("select * from t_user");
   try {
    while(rs.next()){
     String name=rs.getString("username");
     System.out.println(name);
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
}
}