使用JDBC连接access

来源：互联网发布：h5页面打开淘宝app 编辑：程序博客网时间：2024/05/17 21:08

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class ConnAccess {
public static void main(String[] args) {
  Connection conn = null;
  PreparedStatement ps = null;
  ResultSet rs = null;
  List idList = null;
  try{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  }catch(Exception e){
   e.printStackTrace();
  }
  try{
   idList = new ArrayList();
   String ur1="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=aaaa.mdb";
   conn = DriverManager.getConnection(ur1);
   ps= conn.prepareStatement("select * from user");
   rs = ps.executeQuery();
   while(rs.next()){
    String id = (String)rs.getString("id");
    System.out.println("--------:"+id);
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
    if(null != rs){
     rs.close();
    }
    if(null != ps){
     ps.close();
    }
    if(null != conn){
     conn.close();
    }
   }catch(Exception e){
    e.printStackTrace();
   }
  }
}
}