connpoolhandler.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 79 行

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name:   ConnPoolHandler.java

package com.sxit.common;

import java.io.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;

public class ConnPoolHandler
{

    public ConnPoolHandler()
    {
    }

    public static Connection getConnection()
    {
        Connection con = null;
        DataSource ds = null;
        try
        {
             //tongweb
//              Context ctx = new InitialContext();
//              ds=(DataSource)ctx.lookup("sxit");
//              con=ds.getConnection();
              //jboss
//            Context ctx = new InitialContext();
//            ds = (DataSource)ctx.lookup("java:/sxit");
//            con = ds.getConnection();
              //weblogic
             Hashtable ht = new Hashtable();
             ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
             ht.put(Context.PROVIDER_URL, "t3://localhost:80");
             Context ctx = new InitialContext(ht);
             ds=(DataSource)ctx.lookup("sxit");
             con=ds.getConnection();
             //websphere
//             Hashtable ht = new Hashtable();
//             ht.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.ejs.ns.jndi.CNInitialContextFactory");
//             ht.put(Context.PROVIDER_URL, "iiop://localhost:2809");
//             Context ctx = new InitialContext(ht);
//             ds=(DataSource)ctx.lookup("sxit");
//             con=ds.getConnection();
        }
        catch(NamingException e)
        {
            System.out.println("jndi error!");
        }
        catch(SQLException e)
        {
            System.out.println();
            System.out.println("sql error!");
        }
        catch(Exception e)
        {
            System.out.println("system error!");
        }
        return con;
    }

    public static void closeConnection(Connection con)
    {
        try
        {
            if(con != null)
                con.close();
        }
        catch(Exception e)
        {
            System.out.println("system error!");
        }
    }
}