Oracle JDBC Query

driver

1. ocrs12.jar
   
2. ojdbc14.jar
   
3. ojdbc14_g.jar

下載http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html


public void QueryOracle()
{
PreparedStatement ptmt=null;;
Connection conn=null;;
ResultSet rs;
String DB_IP="127.0.0.1";
String DB_SID="";
String DB_User="";
String DB_Password="";
String Column="";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection
("jdbc:oracle:thin:@"+DB_IP+":1521:"+DB_SID,DB_User,DB_Password);
ptmt = conn.prepareStatement("select * from unaddr group by bid");
rs = ptmt.executeQuery();
while(rs.next()){
Column = rs.getString("Column");
}
ptmt.clearParameters();
} catch (ClassNotFoundException e) {
System.out.println("找不到驅動程式");
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (ptmt != null) {
try {
ptmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}//end