connectionmanager.java

这个也是关于图书管理系统的代码

// Decompiled by DJ v2.9.9.61 Copyright 2000 Atanas Neshkov  Date: 2003-3-25 下午 2:02:47
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3)
// Source File Name:   ConnectionManager.java

package com.xmspk.ebp.database;

import java.sql.*;
import java.util.Hashtable;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.ConnectionPoolDataSource;
//import javax.sql.PooledConnection;

public class ConnectionManager
{

    private ConnectionManager()
    {
    }

    public static Connection getConnection()
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            String url = "jdbc:oracle:thin:@172.31.0.28:1521:oradb";
            String user = "EbpUser";
            String password = "EbpUser";
            Connection conn = DriverManager.getConnection(url, user, password);
            return conn;
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }

    public static Connection getPoolConnection()
    {
        try
        {
            Driver myDriver = (Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance();
            Connection connWebOA = myDriver.connect("jdbc:weblogic:pool:EbpUserPool", null);
            return connWebOA;
        }
        catch(Exception e)
        {
            return null;
        }
    }

    public static Connection getJndiConnection()
    {
        String name = "EbpUserDataSource";
        Hashtable env = new Hashtable(11);
        env.put("java.naming.factory.initial", "com.sun.jndi.fscontext.RefFSContextFactory");
        try
        {
            Context ctx = new InitialContext(env);
            ConnectionPoolDataSource cpds = (ConnectionPoolDataSource)ctx.lookup(name);
            return cpds.getPooledConnection().getConnection();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }
}