|
|
测试Weblogic 8.11 连接池的JSP文件 |
|
|
作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站 |
<%@ page contentType="text/html;charset=GBK" %> <%@ page import= "java.sql.* " %> <%@ page import= "javax.sql.* " %> <%@ page import= "javax.naming.* "%>
<HTML> <HEAD> <TITLE> </TITLE> <META NAME="Generator" CONTENT="EditPlus2.11"> </HEAD> <BODY>
<% // 从weblogic 8 文档抄来 Context ctx = null; Hashtable ht = new Hashtable(); ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory"); ht.put(Context.PROVIDER_URL,"t3://127.0.0.1:7001"); // ht.put(Context.SECURITY_PRINCIPAL, "admin"); // ht.put(Context.SECURITY_CREDENTIALS, "11111111");
Connection conn = null; Statement stmt = null; ResultSet rs = null;
try { ctx = new InitialContext(ht); DataSource ds = (DataSource)ctx.lookup ("ejbPool"); conn = ds.getConnection(); stmt = conn.createStatement(); stmt.execute("select * from accounts"); rs = stmt.getResultSet(); while ( rs.next()){ out.println( rs.getString(1)+"___"); out.println( rs.getString(2)+"___"); out.println( rs.getString(3)+"<br>"); }
stmt.close(); stmt=null; conn.close(); conn=null;
}catch (Exception e) { out.println("错误 !! ERR !" ); } finally {
try { ctx.close(); } catch (Exception e) { out.println("ctx ERR !" ); }
try { if (rs != null) rs.close(); } catch (Exception e) { out.println("rs ERR !" ); }
try { if (stmt != null) stmt.close(); } catch (Exception e) { out.println("stmt ERR !" ); }
try { if (conn != null) conn.close(); } catch (Exception e) { out.println("conn ERR !" ); }
}
%> </BODY> </HTML>

|
|
相关文章:相关软件: |
|