Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- class ConnectAccess{
- String connStr;
- public ConnectAccess(String accessDB_DSN_Name){
- //accessDB_DSN_Nameabc为自己创建的系统DSN数据源名,对应一个Access数据库.
- //String link="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=H:\\summer\\javaxml\\db.mdb";
- connStr = "jdbc:odbc:"+accessDB_DSN_Name;
- try{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection(connStr,"","");
- Statement statement=con.createStatement();
- ResultSet rs=statement.executeQuery("select * from student");
- while(rs.next()){
- System.out.println(rs.getString(1)+" "+rs.getString(2) + " " + rs.getString(3));
- }
- rs.close();
- statement.close();
- con.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- public static void main(String[] args){
- ConnectAccess access = new ConnectAccess("abc");
- }
- }
Add Comment
Please, Sign In to add comment