java串連Oracle資料庫的步驟

標籤：bsp   .sql   system   apache   ring   imp   etl   sql   org   

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import org.apache.log4j.Logger;public class Test1 {    private static Logger logger=Logger.getLogger(Test1.class.getName());    public static void main (String [] args){            Connection conn=null;        //載入驅動        try {            Class.forName("oracle.jdbc.OracleDriver");        } catch (ClassNotFoundException e) {            logger.error(e);        }        //建立串連        try {            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","java78","java78");            System.out.println("建立串連成功！");        } catch (SQLException e) {            logger.error(e);        }finally{            //關閉串連            if(conn!=null){                try {                    conn.close();                } catch (SQLException e) {                    logger.error(e);                }                System.out.println("關閉串連成功！");            }        }    }}

 

java串連Oracle資料庫的步驟