java连接oracle数据库代码实例（注释详解）

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GetOracleConnection{
    
    /** Oracle数据库连接URL*/
    private final static String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
    
    /** Oracle数据库连接驱动*/
    private final static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
    
    /** 数据库用户名*/
    private final static String DB_USERNAME = "global";
    
    /** 数据库密码*/
    private final static String DB_PASSWORD = "odps";
    
    /**
     * 获取数据库连接
     * @return
     * @throws SQLException 
     */
    public void getConnection(){
        /** 声明Connection连接对象*/
        Connection conn = null;
        Statement  st=null;
        ResultSet  rs=null;
        try{
            /** 使用Class.forName()方法自动创建这个驱动程序的实例且自动调用DriverManager来注册它*/
            Class.forName(DB_DRIVER);
            /** 通过DriverManager的getConnection()方法获取数据库连接*/
            conn = DriverManager.getConnection(DB_URL,DB_USERNAME,DB_PASSWORD);
            System.out.println("连接数据库成功！");
            /**采用Statement进行查询 */
            st = conn.createStatement(); 
            rs = st.executeQuery("select * from tab001"); 
            while(rs.next()) { 
            	/**打印字段信息 */
            	System.out.println(rs.getString("content"));
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }finally{
        	/**注：一定要记得关闭连接，否则后果很严重的！*/
        	try {
				rs.close();
				st.close();
	        	conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
        }
    }
    public static void main(String[] args){
    	(new GetOracleConnection()).getConnection();
    }
}