package com.java.dbtest; 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
public class TestConnection implements DBTest{ 
public void SelectUser(){ 
//設(shè)定數(shù)據(jù)庫(kù)驅(qū)動(dòng)，數(shù)據(jù)庫(kù)連接地址、端口、名稱(chēng)，用戶(hù)名，密碼 
String driverName="oracle.jdbc.driver.OracleDriver"; 
String url="jdbc:oracle:thin:@localhost:1521:BJPOWERNODE"; //test為數(shù)據(jù)庫(kù)名稱(chēng)，1521為連接數(shù)據(jù)庫(kù)的默認(rèn)端口 
String user="system"; //aa為用戶(hù)名 
String password="bjpowernode"; //123為密碼 
PreparedStatement pstmt = null; 
ResultSet rs = null; 
//數(shù)據(jù)庫(kù)連接對(duì)象 
Connection conn = null; 
try { 
//反射Oracle數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序類(lèi) 
Class.forName(driverName); 
//獲取數(shù)據(jù)庫(kù)連接 
conn = DriverManager.getConnection(url, user, password); 
//輸出數(shù)據(jù)庫(kù)連接 
System.out.println(conn); 
//定制sql命令 
String sql = "select * from t_user where user_id = ?"; 
//創(chuàng)建該連接下的PreparedStatement對(duì)象 
pstmt = conn.prepareStatement(sql); 
//傳遞第一個(gè)參數(shù)值 root，代替第一個(gè)問(wèn)號(hào) 
pstmt.setString(1, "root"); 
//執(zhí)行查詢(xún)語(yǔ)句，將數(shù)據(jù)保存到ResultSet對(duì)象中 
rs = pstmt.executeQuery(); 
//將指針移到下一行，判斷rs中是否有數(shù)據(jù) 
if(rs.next()){ 
//輸出查詢(xún)結(jié)果 
System.out.println("查詢(xún)到名為【" + rs.getString("user_id") + "】的信息，其密碼為：" + rs.getString("password")); 
}else{ 
//輸出查詢(xún)結(jié)果 
System.out.println("未查詢(xún)到用戶(hù)名為【" + rs.getString("user_id") + "】的信息"); 
} 
} catch (ClassNotFoundException e) { 
e.printStackTrace(); 
} catch (SQLException e) { 
e.printStackTrace(); 
}finally{ 
try{ 
if(rs != null){ 
rs.close(); 
} 
if(pstmt != null){ 
pstmt.close(); 
} 
if(conn != null){ 
conn.close(); 
} 
} catch (SQLException e) { 
e.printStackTrace(); 
} 
} 
} 
public static void main(String[] args){ 
new TestConnection().SelectUser(); 
} 
}