JdbcConnect.java Source code

Introduction

Here is the source code for JdbcConnect.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class JdbcConnect {

    public static void main(String[] args) throws Exception {
        Connection conn1 = null;
        Connection conn2 = null;
        Connection conn3 = null;

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        String jdbcUrl = "jdbc:odbc:authors";

        String user = "yourName";
        String pwd = "mypwd";

        conn1 = DriverManager.getConnection(jdbcUrl);
        if (conn1 != null) {
            System.out.println("Connection 1 successful!");
        }
        Properties prop = new Properties();
        prop.put("user", user);
        prop.put("password", pwd);

        conn2 = DriverManager.getConnection(jdbcUrl, prop);
        if (conn2 != null) {
            System.out.println("Connection 2 successful!");
        }
        conn3 = DriverManager.getConnection(jdbcUrl, user, pwd);
        if (conn3 != null) {
            System.out.println("Connection 3 successful!");
        }
        conn1.close();
        conn2.close();
        conn3.close();
        if (conn1.isClosed()) {
            System.out.println("Connection 1 is closed");
        }

        if (conn2.isClosed()) {
            System.out.println("Connection 2 is closed");
        }
        if (conn3.isClosed()) {
            System.out.println("Connection 3 is closed");
        }

        conn1.close();
        conn2.close();
        conn3.close();

    }
}