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

素颜马尾好姑娘i 2023-10-10 10:49 10阅读 0赞

![Center][]

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 block
    			e.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 block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (ClassNotFoundException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.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 exception
    			e.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 block
    			e.printStackTrace();
    		}
    
    	}
    
    	// OracleUtil数据库工具类测试方法
    	public static void main(String[] args) {
    		OracleUtil util = new OracleUtil();
    		util.getConn();
    	}
    
    }

配置文件：

![Center 1][]

[Center]: https://img-blog.csdn.net/20130828105144640?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: https://img-blog.csdn.net/20130828105358484?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center