Weblogic 连接池的建立程序应用

s2_l;W`B3[/ea3j\x)I0 连接池的建立51Testing软件测试网!d8GG&`I/?!T}CL0?

.GNCUSn8F sq5h0public class mypooltest {51Testing软件测试网8~7RwOg:e

xFR9C)M0@E0 public static void main(String[] args) {

,i%kS8\F1@#]/uM0    Statement stmt = null;

2ng4`T`aIw0    Connection conn = null;

Ao'B3I d0    ResultSet res = null;

    try {

      Hashtable env = new Hashtable();51Testing软件测试网 @#d6lHQ*eK-mh

\'b2S.~_Z0 51Testing软件测试网za A!eyE&vRy

V\Md2ip0      env.put(InitialContext.INITIAL_CONTEXT_FACTORY,51Testing软件测试网^y7h8E9Yl)S

*[}%{&tCM"}P+r-V'e3a0q0              "weblogic.jndi.WLInitialContextFactory");51Testing软件测试网A/B0dkzJ*V%L-A

yxCt3X?o C0      env.put(InitialContext.PROVIDER_URL, "t3://localhost:7001");

3Ec,PU'e4g0      env.put(InitialContext.SECURITY_PRINCIPAL, "yuy");登录到weblgic的用名

      env.put(InitialContext.SECURITY_CREDENTIALS, "12345678");密码51Testing软件测试网D_0w x-lIh!W

      InitialContext ctx = new InitialContext(env);51Testing软件测试网TLf9D{x

9E8X_"LZ;^0      DataSource ds = (DataSource) ctx.lookup("mytest");JNDI名称为mytest

d}IU2z0      conn = ds.getConnection();

_5q$CM D,f.K'V5O0      stmt = conn.createStatement();

      res = stmt.executeQuery("select * from man");

      System.out.println("id------name------address");

      while (res.next()) {51Testing软件测试网!{U(`.`,KL!l

        int id = res.getInt(1);51Testing软件测试网 NG#F:m8H+W,p;{4ec

        String name = res.getString(2);

        String address = res.getString(3);

jA6X ~bm$nE0        System.out.println(id + "------" + name + "------" + address);51Testing软件测试网N8h2[#oFP#e I+W(J

3kz}JKq(n0      }

    }

sFm
mSu)[0    catch (SQLException sse) {

      System.out.println("sql error!");51Testing软件测试网vW'r9yh]H!^8y

0| hW1oA_0    }

    finally {

 51Testing软件测试网Pe*D:_#~'P-vx4N3cH

6b2{`b+vSH#q0    }51Testing软件测试网Y#k7|+g3]&T
?`JA)KG

 }

HBH.fO6E/z:Hc0}51Testing软件测试网b7` tQWx1~c*D