连接访问数据库 [英] Connectivity to access database

问题描述

import java.sql.*;
public class Main
{
    private static final String accessDBURLPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
    private static final String accessDBURLSuffix = ";DriverID=22;READONLY=false}";
    // Initialize the JdbcOdbc Bridge Driver
    static {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch(ClassNotFoundException e) {
            System.err.println("JdbcOdbc Bridge Driver not found!");
        }
    }
    public static Connection getAccessDBConnection(String filename) throws SQLException {
        String databaseURL = accessDBURLPrefix + filename + accessDBURLSuffix;
        return DriverManager.getConnection(databaseURL, "", "");
    }
    public static void main(String[] args)
    {
        try
        {
            Connection conn = getAccessDBConnection("User.mdb");
            Statement s = conn.createStatement();
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
    }
}

推荐答案

使用JDBC并废除它更好地使用SHINE ENTERPRISE库

为您完成所有设置

非常容易和快捷

http://SourceForge.net/projects/shine-enterpris/files/ [

FOR USING JDBC AND HIBERNATE IT''S BETTER USE SHINE ENTERPRISE LIBRARY

IT DO ALL SETTING FOR YOU

IT''S VERY EASY AND FASTER

http://SourceForge.net/projects/shine-enterpris/files/[^]

这篇关于连接访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！