(java 功能篇) Java 连接Oracle数据库

Oracle工具类源代码+Oracle配置文件(注解包含在源代码中)

 

package com.rf.util;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.HashMap;import java.util.Map;import java.util.Properties;import com.sun.corba.se.spi.orbutil.fsm.State;public class OracleUtil {public Map getURL() {// 读取配置文件类Properties p = new Properties();try {// Java反射机制--加载Oracle数据库配置文件p.load(getClass().getClassLoader().getResourceAsStream("jdbc.properties"));} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}String url = p.getProperty("url");String username = p.getProperty("username");String pwd = p.getProperty("password");Map map = new HashMap();map.put("url", url);map.put("uname", username);map.put("pwd", pwd);return map;}public static Connection getConn() {OracleUtil jdbc = new OracleUtil();Map cmap = jdbc.getURL();String url = (String) cmap.get("url");String user = (String) cmap.get("uname");String password = (String) cmap.get("pwd");// Oracle 数据库连接类Connection conn = null;try {// 加载oracle 数据库驱动Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();conn = DriverManager.getConnection(url, user, password);System.out.println("Oracle数据库连接成功！");} catch (InstantiationException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}// 关闭Oracle 数据库连接方法一public static void closeCSR(Connection conn, Statement st, ResultSet rs) {try {if (rs != null)rs.close();if (st != null)st.close();if (conn != null) {conn.close();}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}}// 关闭oracle 数据库连接方法二public static void closeCS(Connection conn, Statement st) {try {if (st != null) {st.close();}if (conn != null) {conn.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}// OracleUtil数据库工具类测试方法public static void main(String[] args) {OracleUtil util = new OracleUtil();util.getConn();}}

配置文件：