การ Connect Oracle JDBC โดยใช้ Java

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

public class JDBCDriverOracle {

      public static void main(String[] args) throws Exception {

            System.out.println("Getting Column Names  ");

            Connection con = null;

            String url = "jdbc:oracle:thin:@192.163.1.14:1521:TEST01";

            String driver = "oracle.jdbc.driver.OracleDriver";

            String user = "user1234";

            String pass = "password1234";

            try {

                  Class.forName(driver);

                  con = DriverManager.getConnection(url, user, pass);

                  if (con != null) {

                        System.out.println("Got Connection.");

                        DatabaseMetaData meta = con.getMetaData();

                        System.out.println("Driver Name : " + meta.getDriverName());

                        System.out.println("Driver Version : " + meta.getDriverVersion());

                        System.out.println("Got Connection success....");

                  } else {

                        System.out.println("Could not Get Connection");

                  }

            } catch (Exception e) {

                  e.printStackTrace();

            } finally {

                  if (con != null) {

                        con.close();

                  }

            }

      }

}

Output

Getting Column Names 

Got Connection.

Driver Name : Oracle JDBC driver

Driver Version : 8.1.7.0.0

Got Connection success....

** ปล.อย่าลืม ต้องไปหา Library ชือว่า classes12.jar ด้วยนะครับ

การ Connect แบบ JDBC โดยใช้ Java

การ Connect แบบ JDBC โดยใช้  Java

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.SQLException;

public class JDBCDriverInformation {

      static String userid="root";

      static String password = "password";

      static String url = "jdbc:mysql://127.0.0.1:3306/ecom";    

      static Connection con = null;

      public static void main(String[] args) throws Exception {

          Connection con = getMySqlJDBCConnection();

          if(con!= null){

             System.out.println("Got Connection.");

             DatabaseMetaData meta = con.getMetaData();

             System.out.println("Driver Name : "+meta.getDriverName());

             System.out.println("Driver Version : "+meta.getDriverVersion());

             System.out.println("Got Connection success....");

          }else{

                System.out.println("Could not Get Connection");

          }

      }

      public static Connection getMySqlJDBCConnection(){

            try {

                  Class.forName("com.mysql.jdbc.Driver");  

            } catch(java.lang.ClassNotFoundException e) {

                  System.err.print("ClassNotFoundException: ");

                  System.err.println(e.getMessage());

            }

            try {

               con = DriverManager.getConnection(url, userid, password);

            } catch(SQLException ex) {

                  System.err.println("SQLException: " + ex.getMessage());

            }

            return con;

      }

}

// Output >>

Got Connection.

Driver Name : MySQL-AB JDBC Driver

Driver Version : mysql-connector-java-5.0.7 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )

Got Connection success....

ขอให้สนุกกับการทดลองนะครับ http://java-thai-talk.blogspot.com/