加载数据库驱动并取得连接

来源：互联网发布：sql替换字符串编辑：程序博客网时间：2024/06/06 18:56

package com.glf.sfa.report;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class SqlConn{    private Connection conn;            private final String oracleDriverName = "oracle.jdbc.driver.OracleDriver";    private final static String oracleUrlToConnect = "jdbc:oracle:thin:@192.168.101.233:1521:orathiz";    private final static String user = "sfa_sqa_test";    private final static String password = "sfa_sqa_test";    /*    *加载驱动    */    public SqlConn(){        try{            Class.forName(oracleDriverName).newInstance();        }catch(Exception ex){}    }    /*    *取得连接     */    public Connection getConn(){        try{            conn = DriverManager.getConnection(oracleUrlToConnect,user,password);        }catch(SQLException sqlex){}        return conn;    }    /*    *关闭数据库    */    public void closeDB(){        try{            conn.close();        }catch(SQLException sqlex){}    }}