JAVA的Jdbc连接Access数据库

发布时间 2023-05-01 13:36:56作者: 有翅膀的大象

    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();
     }
    
    
}