jdbc+oracle測試類別。

標籤：.sql   pass   ora   print   引入   final   cti   body   ace   

package org.portal.service;

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 測試連接oracle資料庫
* @author wpc
*
*/

public class Test {
//驅動，URL，使用者名稱，密碼
private static final String driver = "oracle.jdbc.driver.OracleDriver";
private static final String url = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String username = "zjuser";
private static final String password = "zjpass";

public static Connection getConnection() {
Connection connection = null;
try {
// 加 載驅動
Class.forName(driver);
// 通過驅動管理類擷取資料庫連接
connection = DriverManager.getConnection(url, username, password);
// 關閉串連
//connection.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}

// 測試oracle串連是否成功
public static void main(String[] args) throws SQLException {
Connection connection = Test.getConnection();
if (connection != null) {
System.out.println("串連oracle資料庫成功:" + connection);
//這裡具體查詢資料庫中的資料，可以直接取出。
/* String sql = "select * FROM BUSER";
Statement st = connection.createStatement();
st.executeQuery(sql);
ResultSet rs = st.executeQuery(sql);
if(rs.next()){
String name = rs.getString("NAME");
System.out.println("name"+name);
}
connection.close();*/
} else {
System.out.println("串連oracle資料庫失敗!!!");
}


}
}

//要引入jdbc.jar包

https://files.cnblogs.com/files/cyz110/jdbc6.rar

jdbc+oracle測試類別。