JdbcOdbc Connect : JDBC ODBC « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. JDBC ODBC

JdbcOdbc Connect

  

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

  }
}


   
  

Related examples in the same category