JAVA直接访问ACCESS

来源：互联网发布：正方软件怎么样编辑：程序博客网时间：2024/06/07 18:29

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ConnectAccess {

/**
* @param args
* @throws IOException
*/

public static void main(String[] args) throws IOException{
        String driverName ="sun.jdbc.odbc.JdbcOdbcDriver";
        String str = ConnectAccess.class.getClass().getResource("/").getPath();
        //java.io.
        System.out.println(str);
        File directory = new File("");//参数为空
        String courseFile = directory.getCanonicalPath();
        System.out.println(courseFile);

        String dbURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:/realproject/testAcess/src/Sludge.mdb;";

        String userName = "";
        String userPwd = "";
        Connection dbConn;
        try {
            Class.forName(driverName);
            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
            System.out.println("Connection Successful!");
        }
       catch (ClassNotFoundException e) {
             System.out.println(" 出错了：class:"+e.getMessage());
        }
        catch(SQLException sql){
         System.out.println("sql:"+sql.getMessage()+"   sTte:"+sql.getSQLState());
        }

   }

}