JNDI 访问WebLogic数据源

来源：互联网发布：同城网络app 编辑：程序博客网时间：2024/05/31 18:36

全文： http://blog.163.com/lyq_163_2009/blog/static/134082696201281075357976/

<%@ page language="java" pageEncoding="UTF-8"%>

<%@ page import="java.util.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page session="false"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JNDI DEMO</title>
</head>
<body>
<%
out.print("JNDI Begin ! <br/>");
DataSource ds = null;
try {
InitialContext ctx = new InitialContext();
ds = (DataSource) ctx.lookup("WebLogic_DS");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from test";
ResultSet rs = stmt.executeQuery(strSql);
while (rs.next()) {
out.println(rs.getString(2));
}
} catch (Exception ex) {
out.print("ERROR:" + ex.getMessage());
ex.printStackTrace();
}
out.print("JNDI End ! <br/>");
%>
</body>
</html>

<%@ page language="java" pageEncoding="UTF-8"%>

<%@ page import="java.util.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page session="false"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JNDI DEMO</title>
</head>
<body>
<%
out.print("JNDI Begin ! <br/>");
DataSource ds = null;
try {
Hashtable ht = new Hashtable();
ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
ht.put(Context.PROVIDER_URL, "t3://localhost:7001");
Context initial = new InitialContext(ht);
ds = (DataSource) initial.lookup("WebLogic_DS");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from test";
ResultSet rs = stmt.executeQuery(strSql);
while (rs.next()) {
out.println(rs.getString(2));
}
} catch (Exception ex) {
out.print("ERROR:" + ex.getMessage());
ex.printStackTrace();
}
out.print("JNDI End ! <br/>");
%>
</body>
</html>