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