Weblogic 连接池的建立程序应用

 连接池的建立51Testing软件测试网Z!U3T+ol)J1hY*m(mD

public class mypooltest {

 public static void main(String[] args) {51Testing软件测试网\n
?w[[8Sp-_;v

)g G5H}6C5N}0    Statement stmt = null;51Testing软件测试网hS/y$l$C%^,j/^3S

B1I4a4S;ae0    Connection conn = null;

9|1y;h|n w%x0    ResultSet res = null;51Testing软件测试网p w[dM7\"Ka n

    try {

      Hashtable env = new Hashtable();

%J)Y;s)b$H|2me1o0 51Testing软件测试网yM1O*Z6H%m

U5S9X ~~v0      env.put(InitialContext.INITIAL_CONTEXT_FACTORY,

B8VDFb0              "weblogic.jndi.WLInitialContextFactory");

      env.put(InitialContext.PROVIDER_URL, "t3://localhost:7001");

JKN]^D0      env.put(InitialContext.SECURITY_PRINCIPAL, "yuy");登录到weblgic的用名

      env.put(InitialContext.SECURITY_CREDENTIALS, "12345678");密码

7]XHS aZ0      InitialContext ctx = new InitialContext(env);

/Vd2W'{b.o2n,?FN'pM0      DataSource ds = (DataSource) ctx.lookup("mytest");JNDI名称为mytest

      conn = ds.getConnection();51Testing软件测试网A(QXp1@1nY

;A*p,sXkLL7\0      stmt = conn.createStatement();51Testing软件测试网g/D)~pgM y m

dkzj3C7t\.pv'z0      res = stmt.executeQuery("select * from man");51Testing软件测试网'p/Ya-x`P3PK

:IMD.Q w+of0      System.out.println("id------name------address");

      while (res.next()) {51Testing软件测试网;YQs(d a)f

        int id = res.getInt(1);

        String name = res.getString(2);

        String address = res.getString(3);

ZK!n2fr:YbGlE
c0 51Testing软件测试网mT.Z^ v+l7QN

!|*u&t@1EIa-b'ig0        System.out.println(id + "------" + name + "------" + address);

      }51Testing软件测试网E'TE_uX

2II#f5F$x(`0    }

iDY&G#e.r]g1G0    catch (SQLException sse) {51Testing软件测试网W
aDQ}"]w/]

s`wru(l4J0      System.out.println("sql error!");

    }51Testing软件测试网'T2YI0Z Py

    finally {51Testing软件测试网;Q)i ^3l6_6U!T;?
g$J

-N5E1@F*I K#@W0 

    }

@tJ1vp^ B(_0 }

}51Testing软件测试网)s7EV}{R?