jdbc-odbc桥连接Oracle

package com.sw;

import java.sql.*;

/*
 * java连接Oracle
 * 测试1
 */
public class TestOra {
	
    public static void main(String[] args) {
    	
    	Connection conn=null;
    	Statement st=null;
    	ResultSet rs=null;
    	
        try{
        	//加载驱动
        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        	//建立连接
        	conn = DriverManager.getConnection("jdbc:odbc:testsw","scott","Oracle1");
        	//
        	st = conn.createStatement();
        	//
        	rs = st.executeQuery("select * from emp");
        	//
        	while(rs.next()){
        		
        		System.out.println(rs.getString(2));
        	}
        }catch(Exception e){
        	
        }
        finally{
        	try {
				rs.close();
	        	st.close();
	        	conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

        }
	}
}

关于如何添加Oracle数据源，参看另外的博客。