package java_jdbc;
//java连接Oracle数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JdbcOracleTest {

public static void main(String[] args) {
    // TODO Auto-generated method stub
   //1.加载驱动
    Connection conn=null;  //连接对象
    Statement stmt=null;  //语句对象
    ResultSet rs=null;   //数据集对象
    String url="jdbc:oracle:thin:@localhost:1521:orcl";
    String username="scott";   //Oracle数据库用户名
    String password="tiger";   //Oracle数据库密码
    try {
        Class.forName("oracle.jdbc.OracleDriver");
        //2.获得数据库连接
        conn=DriverManager.getConnection(url,username,password);
        /*
        //判断数据库连接是否成功
        if(conn!=null)
        {
            System.out.println("Oracle数据库间接成功");
        }else{
            System.out.println("Oracle数据库连接失败");
        }
         */
        //3.创建语句对象
        stmt=conn.createStatement();
        String sql="select * from students";//students是Oracle数据库中的表名
        rs=stmt.executeQuery(sql);
        //遍历输出数据库students表中的数据
        while(rs.next())
        {
            System.out.println(rs.getInt("sid")+","+
               rs.getString("sname")+","+rs.getString("gender")+","+
               rs.getString("birthday")+","+rs.getString("marjor")+","+
               rs.getString("address"));
        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally {
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (stmt != null) {
                stmt.close();
                stmt = null;
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }

        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}

}
2.Oracle的配置：
Oracle的用户名为：scott
Oracle的密码为：tiger
数据库为：oral11g
创建的数据表为：students