Java jdbc 串連oracle之三（封裝工具類）

標籤：nec   acl   封裝   man   cti   ring   source   .sql   throw   

driver = oracle.jdbc.driver.OracleDriverurl = jdbc:oracle:thin:@192.168.10.105:1521:orcluser = LFpassword = LF

import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.util.Properties;public class JdbcTools {    //properties檔案名稱    private static String defaultName = "jdbc.properties";    /**     * 擷取Connection     * @return connection     * @throws Exception     */    public static Connection getConnection() throws Exception{        Connection connection = getConnection(defaultName);        return connection;    }    /**     * 通過properties檔案名稱擷取Connection     * @param fileName  properties檔案名稱     * @return          Connection     * @throws Exception     */    public static Connection getConnection(String fileName) throws Exception{        //IO流讀取jdbc.properties檔案        InputStream in = JdbcTools.class.getClassLoader().getResourceAsStream(fileName);        // 讀取參數        Properties p = new Properties();        p.load(in);        String url = p.getProperty("url");        String user = p.getProperty("user");        String password = p.getProperty("password");        String driver=p.getProperty("driver");        Class.forName(driver);        Connection connection = DriverManager.getConnection(url, user, password);        if (in!=null) {            in.close();        }        return connection;    }        }

 

Java jdbc 串連oracle之三（封裝工具類）