package com.shower.exercise.jdbc.util; import java.sql.*; import java.util.ResourceBundle; /** * @author suchuner * @className JDBCUtil * @description TODO * @date 2018-09-13 10:55 */ public class JDBCUtil { private JDBCUtil() { } private static ResourceBundle bundle=ResourceBundle.getBundle("jdbc");//直接写配置文件名称即可,不需要加后缀 private static String driver_class_name = bundle.getString("jdbc.driver_class_name"); private static String url = bundle.getString("jdbc.url"); private static String username = bundle.getString("jdbc.username"); private static String password = bundle.getString("jdbc.password"); static { try { Class.forName(driver_class_name); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public static Connection getConn() { try { return DriverManager.getConnection(url, username, password); } catch (SQLException e) { e.printStackTrace(); } return null; } public static Connection getConn(String url, String user, String password) { try { return DriverManager.getConnection(url, user, password); } catch (SQLException e) { e.printStackTrace(); } return null; } public static void close(Connection conn, PreparedStatement ps, ResultSet rs) { try { if (rs != null) { rs.close(); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (ps != null) { ps.close(); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } } }
配置文件位置:
配置文件内容: