localapplication.java

来自「jdbc oracle jdbc oraclejdbc oraclejdbc o」· Java 代码 · 共 39 行

package tlz;

import java.sql.DriverManager;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.File;
import java.sql.Connection;
import oracle.jdbc.*;
public class LocalApplication {
    protected String dbUser = null;
    protected String dbPwd = null;
    protected String jdbcDriverClass = null;
    protected String jdbcURL = null;
    protected String exportSQL = null;
    protected String exportFile = null;
    
    public LocalApplication() throws Exception {
    /*    String url = "" + this.getClass().getResource(".");
        System.out.println("url = " + url);
        url = url.substring(6); //去掉开头的"file:/"
        url = url.substring(0, url.lastIndexOf("tlz")); //去掉结尾的tlz/imp
*/      String  url = "tlz/config.txt";
        Properties props = new Properties();
        props.load(new FileInputStream(url));
        dbUser = props.getProperty("database_user");
        dbPwd = props.getProperty("database_password");
        jdbcDriverClass = props.getProperty("jdbc_driver_class");
        jdbcURL = props.getProperty("jdbc_url");
        exportSQL = props.getProperty("exp_sql");
        exportFile = props.getProperty("exp_file");
    }

    public OracleConnection getConnection() throws Exception{
        Class.forName(jdbcDriverClass);
        OracleConnection conn = (OracleConnection)DriverManager.getConnection(jdbcURL,dbUser,dbPwd);
        return conn;
    }
}