java连接Oracle数据库

针对于Oracle11g的版本，所需要的jar是ojdbc6.jar

import oracle.jdbc.OracleTypes;

import org.junit.Test;

import java.sql.*;

public class ConnectionTest {
    @Test
    public void testJdbc(){
        String driver="oracle.jdbc.OracleDriver";
        String url="jdbc:oracle:thin:@localhost:1521:orcl";
        String username="scott";
        String password="tiger";

        try {
            Class.forName(driver);
            Connection conn= DriverManager.getConnection(url,username,password);
            PreparedStatement pstm=conn.prepareStatement("select * from emp");
            ResultSet rs=pstm.executeQuery();
            while (rs.next()){
                System.out.println(rs.getObject(1)+","+rs.getObject(2));
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 }