测试数据库连接用的test.jsp

最新推荐文章于 2019-09-20 13:58:25 发布

kumcun

最新推荐文章于 2019-09-20 13:58:25 发布

阅读量300

点赞数

分类专栏： Java 文章标签： JSP SQL

本文链接：https://blog.csdn.net/kumcun/article/details/83809958

版权

Java 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<%@   page import="javax.naming.Context"%>
<%@   page import="javax.sql.DataSource"%>
<%@   page import="javax.naming.InitialContext"%>
<%@   page import="java.sql.*"%>

<%
	DataSource ds = null;
	try {
		Context initCtx = new InitialContext();
		Context envCtx = (Context) initCtx.lookup("java:comp/env");
		ds = (DataSource) envCtx.lookup("IMDB");
		if (ds != null) {
			out.println("Connection   is   OK! ");
			Connection cn = ds.getConnection();
			if (cn != null) {
		out.println("cn   is   Ok! ");
		Statement stmt = cn.createStatement();
		ResultSet rst = stmt
				.executeQuery("select   *   from   dual ");
		out.println(" <p> rst   is   Ok! ");
		while (rst.next()) {
			out.println(" <P> test: " + rst.getString(1));
		}
		cn.close();
			} else {
		out.println("rst   Fail! ");
			}
		} else
			out.println("Fail! ");
	} catch (Exception ne) {
		out.println(ne);
	}
%>