连接Oracle 的工具类（OracleConnUtils）

本文总结了使用Java代码获取Oracle 连接的工具类

使用的jar包是：ojdbc14.jar  将jar包引入对应项目

package per.test.oracle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class OracleConnUtils {

private static Connection conn = null;

/**
* 连接oracle
* 
* @param url jdbc:oracle:thin:@localhost:1521:orcl (localhost 是连接的主机地址，1521是端口，orcl是数据库名称)
* @param user 连接用户名
* @param password 连接密码
* @return
*/
public static Connection getConnection(String url, String user, String password) {


try {
Class.forName("oracle.jdbc.driver.OracleDriver");


conn = DriverManager.getConnection(url, user, password);


} catch (Exception e) {
e.printStackTrace();
}
return conn;
}


// Test
public static void main(String[] args) {


Statement sql = null;
ResultSet rs = null;
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "root";
String password = "root";


int no;
String name;
String job;

Connection connection = OracleConnUtils.getConnection(url, user, password);

if (connection == null) {
System.out.print("连接失败");

System.exit(0);
}
try {
sql = connection.createStatement();
// 得到结果集
rs = sql.executeQuery("select empno, ename, job from emp");
System.out.println("工号" + "            " + "姓名" + "             " + "工种");

while (rs.next()) {
no = rs.getInt(1);
name = rs.getString(2);
job = rs.getString(3);
System.out.println(no + "         " + name + "         " + job);
}
} catch (SQLException e) {
e.printStackTrace();
}
}


}