jdbclocator.java

以前做的一个j2ee的项目

package gov.gdlt.ssgly.taxcore.comm.servicelocator;

import javax.naming.Context;
import java.sql.Connection;
import javax.naming.InitialContext;
import javax.naming.NamingException;

/**
 * Service Locator模式的实现，在此提供从Weblogic连接池中获取连接的方法。
 *
 * <p>Title: JDBCLocator</p>
 * <p>Description: 税收管理员系统</p>
 * <p>Copyright: Copyright (c) 2005 广州市地方税务局</p>
 * <p>Company: 信息中心</p>
 * @author Lemon
 * @version 1.0
 * @since 2005.10.14.
 */

public class JDBCLocator {
    private static JDBCLocator instance;
    private Context context;
    private javax.sql.DataSource dataSource = null;
    private javax.sql.DataSource dataSourceSms = null;
    private javax.sql.DataSource djzCloneDataSource = null;

    public JDBCLocator() {
        try {
            context = new InitialContext();
        } catch (NamingException e) {

        }
    }

    public static JDBCLocator getInstance() {
        if (instance == null) {
            instance = new JDBCLocator();
        }
        return instance;
    }

    public Connection getJDBCConnection() {
        try {
            if (dataSource == null) {
                dataSource = (javax.sql.DataSource) context.lookup(
                    "jdbc/ssglyds");
            }
            return dataSource.getConnection();
        } catch (Exception e) {
            System.err.println("Couldn't get ssgly jdbc connection!");
            return null;
        }
    }

    public Connection getSmsJDBCConnection() {
        try {
            if (dataSourceSms == null) {
                dataSourceSms = (javax.sql.DataSource) context.lookup(
                    "jdbc/ssglysms");
            }
            return dataSourceSms.getConnection();
        } catch (Exception e) {
            System.err.println("Couldn't get sms jdbc connection!");
            return null;
        }
    }

    public Connection getDJZCloneJDBCConnection() {
        try {
            if (djzCloneDataSource == null) {
                djzCloneDataSource = (javax.sql.DataSource) context.lookup(
                    "jdbc/ssglydjzds");
            }
            return djzCloneDataSource.getConnection();
        } catch (Exception e) {
            System.err.println("Couldn't get djz clone connection!");
            return null;
        }
    }
}