dbfactory.java

来自「新闻管理系统」· Java 代码 · 共 28 行

package newsset;
import java.sql.*;//做数据库时候必须要引入的包
import oracle.jdbc.driver.OracleDriver;
public class DBFactory {
    Connection Conn=null;
    PreparedStatement Stmt=null;
    ResultSet Rs=null;
    String driverName="oracle.jdbc.driver.OracleDriver";
    String OracleUserName="scott";
    String OracleUserPwd="tiger";
    String ConnUrl="jdbc:oracle:thin:@localhost:1521:Ora";
    public  Connection getConnection()
    {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException ex) {
            System.out.println("加载驱动程序有错误");
        }
        try {
            Conn = DriverManager.getConnection(ConnUrl, OracleUserName,OracleUserPwd);
        } catch (SQLException ex1) {
            System.out.print("取得连接的时候有错误，请核对用户名和密码");
        }

        return Conn;
    }
}