Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.io.FileOutputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Hashtable;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NameClassPair;
import javax.naming.NamingEnumeration;

import oracle.jdbc.pool.OracleDataSource;

public class Main {
    public static void main(String[] args) throws Exception {
        Connection conn = getMySqlConnection();
        // Set up the environment for creating the initial context
        Hashtable env = new Hashtable(11);
        env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.fscontext.RefFSContextFactory");
        env.put(Context.PROVIDER_URL, "file:/jdbc");

        Context context = new InitialContext(env);
        NamingEnumeration list = context.list("jdbc");

        while (list.hasMore()) {
            NameClassPair nc = (NameClassPair) list.next();
            System.out.println(nc);
        }

        OracleDataSource ods = new OracleDataSource();
        ods.setDriverType("thin");
        ods.setServerName("localhost");
        ods.setNetworkProtocol("tcp");
        ods.setDatabaseName("databaseName");
        ods.setPortNumber(1521);
        ods.setUser("userName");
        ods.setPassword("Password");

        Context ctx = new InitialContext();
        ctx.bind("file:/jdbc/mydb", ods);

        // Get the initial context of JNDI and lookup the datasource.
        InitialContext ic = new InitialContext();
        javax.sql.DataSource ds = (javax.sql.DataSource) ic.lookup("file:/jdbc/mydb");
        // Set the optional printwriter where the trace log is to be directed.
        ds.setLogWriter(new PrintWriter(new FileOutputStream("c:/datasource.log")));
        Connection con1 = ds.getConnection();
        Connection con2 = ds.getConnection("userName", "password");
        conn.close();

    }

    private static Connection getHSQLConnection() throws Exception {
        Class.forName("org.hsqldb.jdbcDriver");
        System.out.println("Driver Loaded.");
        String url = "jdbc:hsqldb:data/tutorial";
        return DriverManager.getConnection(url, "sa", "");
    }

    public static Connection getMySqlConnection() throws Exception {
        String driver = "org.gjt.mm.mysql.Driver";
        String url = "jdbc:mysql://localhost/demo2s";
        String username = "oost";
        String password = "oost";

        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, username, password);
        return conn;
    }

    public static Connection getOracleConnection() throws Exception {
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@localhost:1521:databaseName";
        String username = "userName";
        String password = "password";

        Class.forName(driver); // load Oracle driver
        Connection conn = DriverManager.getConnection(url, username, password);
        return conn;
    }

}