使用weblogic管理数据源

最新推荐文章于 2021-12-20 13:07:29 发布

iteye_21104

最新推荐文章于 2021-12-20 13:07:29 发布

阅读量236

点赞数

分类专栏： tools 文章标签： xhtml java 数据库

本文链接：https://blog.csdn.net/iteye_21104/article/details/82610376

版权

tools 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html; charset=GBK" language="java"
	errorPage=""%>
<%@ page import="javax.naming.*,java.sql.*,javax.sql.*"%>
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	</head>
	<body>
		<%
			//初始化Context，使用InitialContext初始化Context
			Context ctx = new InitialContext();
			//通过JNDI查找数据源，该JNDI就是部署数据源所指定的JNDI
			DataSource ds = (DataSource) ctx.lookup("mmysql");
			//获取数据库连接
			Connection conn = ds.getConnection();
			//获取Statement
			Statement stmt = conn.createStatement();
			//执行查询，返回ResulteSet对象
			ResultSet rs = stmt.executeQuery("select * from t_book");
			while (rs.next()) {
				out.println(rs.getString(1) + "  " + rs.getString(2)
						+ "<br/>");
			}
			rs.close();
			stmt.close();
			conn.close();
		%>
	</body>
</html>

[img]http://dl.iteye.com/upload/picture/pic/132017/87b234bf-6060-366e-8071-07d9e1696f98.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132019/ddce9cdf-d5f0-389a-81df-73e460a74203.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132021/62344aab-f8ee-3bda-abc6-de7bfe4d8c5b.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132023/05ab98b1-562f-3b34-881e-0adcbbb05029.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132025/5ae4eff2-32a5-3889-b408-272186887ea4.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132027/e2a346e2-0d4e-3d58-b560-9b035492817c.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132029/1b54a65b-edfd-394d-a775-1fba87cdc6ef.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132031/2afd2c28-401e-3fcc-b293-99c23f3145b6.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132033/5bf135ec-8555-3f04-82ac-483f0a7f8397.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132035/4a72c31d-fb5d-31e9-86ef-db0862341d77.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132037/cbd014e0-2b52-3974-ac94-9f8b98761765.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132039/674c7f29-65a4-36b2-804e-85be22ea50b7.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/132041/b686d9df-9391-3da2-ba7a-3d5ae4bd85b3.png[/img]