get Test DB Connection via UcanaccessDriver - Java java.sql

Java examples for java.sql:Access

  1. HOME
  2. Java
  3. java.sql
  4. Access

Description

get Test DB Connection via UcanaccessDriver

Demo Code

/*/*from  www  . j  a v  a  2s.  co  m*/
 * Copyright (c) 2011 Google Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 * in compliance with the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License
 * is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
 * or implied. See the License for the specific language governing permissions and limitations under
 * the License.
 */
//package com.java2s;
import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
    public static void main(String[] argv) throws Exception {
        System.out.println(getTestDBConnection());
    }

    public static Connection getTestDBConnection() throws Exception {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        String url = "jdbc:ucanaccess://C:/users/cgrass/Desktop/"
                + "USM Marketing Application/Test Database/"
                + "test_USMMarketingIntelligenceDatabase.accdb";
        Connection conn = DriverManager.getConnection(url);
        return conn;
    }
}

Related Tutorials