Weblogic 连接池的建立程序应用

连接池的建立

public class mypooltest {

 public static void main(String[] args) {

    Statement stmt = null;

    Connection conn = null;

    ResultSet res = null;

    try {

      Hashtable env = new Hashtable();

 

      env.put(InitialContext.INITIAL_CONTEXT_FACTORY,

              "weblogic.jndi.WLInitialContextFactory");

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

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

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

      InitialContext ctx = new InitialContext(env);

      DataSource ds = (DataSource) ctx.lookup("mytest");JNDI 名称为mytest

      conn = ds.getConnection();

      stmt = conn.createStatement();

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

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

      while (res.next()) {

        int id = res.getInt(1);

        String name = res.getString(2);

        String address = res.getString(3);

 

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

      }

    }

    catch (SQLException sse) {

      System.out.println("sql error!");

    }

    finally {

 

    }

 }

}