设置配置文件链接数据库

快来打我* 2023-06-19 09:37 2阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzQxODAzNjkz_size_16_color_FFFFFF_t_70][]

DbUtil.class链接数据库

public class DbUtil {
        private static String className;
        private static String url;
        private static String pwd;
        private static String users;
        private static Properties prop = new Properties();
        //静态块 在方法被调用之前就执行了
        static {
            InputStream is = DbUtil.class.getResourceAsStream("Config.properties");
            try {
                prop.load(is);
                className = prop.getProperty("className").trim();
                url = prop.getProperty("url").trim();
                users = prop.getProperty("users").trim();
                pwd = prop.getProperty("pwd").trim();
            } catch (IOException e1) {
                // TODO Auto-generated catch block
                e1.printStackTrace();
            }
            try {
                Class.forName(className);
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        public static Connection getConnection() throws SQLException {
            Connection conn = DriverManager.getConnection(url, users, pwd);
            System.out.println("连接成功！");
            return conn;
        }
        public static void closeConnection(Connection conn) throws SQLException{
            if(conn!=null){
                conn.close();
            }
        }
        public static void main(String []args) throws SQLException {
            System.out.println(getConnection());
        }
    }

配置文件：Config.properties

className=oracle.jdbc.OracleDriver
    url=jdbc:oracle:thin:@localhost:1521:XE
    users=supermarket
    pwd=0000

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzQxODAzNjkz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191205144947415.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzQxODAzNjkz,size_16,color_FFFFFF,t_70