Eclipse加入Access_JDBC30.jar:
程序如下:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class conn { public static String connct() { try{ //Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); //Connection conn=DriverManager.getConnection("jdbc:odbc:MondrianFoodMart","sa","123456"); Class.forName("com.hxtt.sql.access.AccessDriver"); Connection conn = DriverManager.getConnection("jdbc:Access:///D:/Mondrian/foodmart/access/MondrianFoodMart.mdb","sa","123456"); Statement sql=conn.createStatement(); System.out.print("数据库连接成功"); ResultSet rs=sql.executeQuery("select * from product"); return "ok"; } catch(Exception e) { } return "no"; } }
调用方式:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; public class test { // conn n=new conn(); public static void main(String[] args) { String s= conn.connct(); } }