web工程测试JDNI

刺骨的言语ヽ痛彻心扉 2022-01-26 06:49 105阅读 0赞

### web工程测试JDNI ###

*  环境
 *  tomcat9 配置 JNDI
 *  项目结构
 *  web.xml
 *  测试页面 index.jsp
 *  测试结果
 *  测试页面 index2.jsp
 *  测试结果2

# 环境 #

*  tomcat9
 *  jdk8
 *  数据库使用JNDI

# tomcat9 配置 JNDI #

[https://blog.csdn.net/qq\_26264237/article/details/90636085][https_blog.csdn.net_qq_26264237_article_details_90636085]

# 项目结构 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2MjY0MjM3_size_16_color_FFFFFF_t_70]

# web.xml #

<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
    	<description>test jndi</description>
    	<jsp-config>
    		<taglib>
    			<taglib-uri>http://java.sun.com/jsp/jstl/sql</taglib-uri>
    			<taglib-location>/WEB-INF/sql.tld</taglib-location>
    		</taglib>
    		<taglib>
    			<taglib-uri>http://java.sun.com/jsp/jstl/core</taglib-uri>
    			<taglib-location>/WEB-INF/c.tld</taglib-location>
    		</taglib>
    	</jsp-config>
    	<resource-ref>
    		<description>DB Connection</description>
    		<res-ref-name>jdbc/TestDB</res-ref-name>
    		<res-type>javax.sql.DataSource</res-type>
    		<res-auth>Container</res-auth>
    	</resource-ref>
    </web-app>

*  sql.tld和c.tld：测试jndi
 *  resource-ref：注册jndi

# 测试页面 index.jsp #

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <sql:query var="rs" dataSource="jdbc/TestDB">
    SELECT id, name FROM t_hello
    </sql:query>
    <html>
    <head>
    <title>DB Test</title>
    </head>
    <body>
    	<h2>Results</h2>
    	<c:forEach var="row" items="${rs.rows}">
    	[id: ${row.id} , name: ${row.name}]<br />
    	</c:forEach>
    </body>
    </html>

# 测试结果 #

[http://localhost:8080/testJndiWeb/index.jsp][http_localhost_8080_testJndiWeb_index.jsp]  
![在这里插入图片描述][20190528140122489.png]

# 测试页面 index2.jsp #

[http://localhost:8080/testJndiWeb/index2.jsp][http_localhost_8080_testJndiWeb_index2.jsp]

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="java.util.*" %>
    <%@ page import="javax.sql.*" %>
    <%@ page import="javax.naming.*" %>
    <%
    Context ctx = new InitialContext();
    DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/TestDB");
    request.setAttribute("ds", ds);
    
    Connection conn = ds.getConnection();
    Statement stt = conn.createStatement();
    ResultSet rs = stt.executeQuery("SELECT id, name FROM t_hello");
    List<Map<String, String>> list = new ArrayList<Map<String,String>>(); 
    while(rs.next()) {
        Map<String, String> map = new HashMap<String, String>();
        map.put("id", rs.getString(1));
        map.put("name", rs.getString(2));
        list.add(map);
    }
    conn.close();
    conn = null;
    request.setAttribute("list", list);
    %>
    <html>
    <head>
    <title>DB Test</title>
    </head>
    <body>
    	[ds=<c:out value="${ds }"></c:out>]<br/>
    	[list=<c:out value="${list }"></c:out>]<br/>
    </body>
    </html>

# 测试结果2 #

![在这里插入图片描述][20190528151013409.png]

[https_blog.csdn.net_qq_26264237_article_details_90636085]: https://blog.csdn.net/qq_26264237/article/details/90636085
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2MjY0MjM3_size_16_color_FFFFFF_t_70]: /images/20220126/385fa8bb09dd4dcb857abd5efbb763b8.png
[http_localhost_8080_testJndiWeb_index.jsp]: http://localhost:8080/testJndiWeb/index.jsp
[20190528140122489.png]: /images/20220126/e8c9066a10a24524b50e27eb21c47df6.png
[http_localhost_8080_testJndiWeb_index2.jsp]: http://localhost:8080/testJndiWeb/index2.jsp
[20190528151013409.png]: /images/20220126/90052d349f934cb5b0a44c0b5e409327.png