java访问access数据库

来源：互联网发布：新网互联域名编辑：程序博客网时间：2024/05/22 15:12

package bao;

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

public class TestConnect {

/**
* @param args
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) throws InstantiationException, IllegalAccessException {
  // TODO Auto-generated method stub
  try{
   //加载驱动程序
  // Class.forName("org.apache.derby.jdbc.clientDriver");
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

   //创建连接
   //Connection conn=DriverManager.getConnection("jdbc:derby://localhost:1527/test;create=false");
   String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=F://test.mdb";
   Connection conn = DriverManager.getConnection(url,"","");
   String sql="select * from student";
   Statement stmt=conn.createStatement();
   ResultSet rs=stmt.executeQuery(sql);
   while(rs.next()){
    System.out.print(rs.getString(1)+"/t"+rs.getString(2)+"/t"+rs.getString(3)+"/r");

   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException e){
   e.printStackTrace();
  }catch(ClassNotFoundException e) {e.printStackTrace();}
}
}