spring-boot测试JNDI

今天药忘吃喽~ 2022-01-26 08:17 192阅读 0赞

### spring-boot测试JNDI ###

*  环境
 *  使用外置tomcat，tomcat9 配置 JNDI
 *  项目结构
 *  maven依赖
 *  spring-boot配置文件
 *  TestJndi2Application
 *  HelloController
 *  测试结果

# 环境 #

*  tomcat9
 *  JDK8
 *  spring-boot 2.1.3

# 使用外置tomcat，tomcat9 配置 JNDI #

[https://blog.csdn.net/qq\_26264237/article/details/90636085][https_blog.csdn.net_qq_26264237_article_details_90636085]  
![在这里插入图片描述][20190528160640740.png]

# 项目结构 #

![20190529102851705.png][]

# maven依赖 #

<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-jdbc</artifactId>
    		</dependency>

# spring-boot配置文件 #

application.yml

spring:
      datasource:
        jndi-name: jdbc/TestDB

# TestJndi2Application #

@SpringBootApplication
    public class TestJndi2Application extends SpringBootServletInitializer{ 
    
    	public static void main(String[] args) { 
    		SpringApplication.run(TestJndi2Application.class, args);
    	}
    	@Override
    	protected SpringApplicationBuilder configure(SpringApplicationBuilder application) { 
    		return application.sources(TestJndi2Application.class);
    	}
    }

# HelloController #

@Controller
    @RequestMapping("/hello")
    public class HelloController { 
    	
    	@Autowired
    	DataSource dataSource;
    
    	@GetMapping("index")
    	@ResponseBody
    	Object index() throws Exception { 
    		Connection conn = dataSource.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();
    		return "" + list;
    	}
    }

# 测试结果 #

[http://localhost:8080/test-jndi2/hello/index][http_localhost_8080_test-jndi2_hello_index]  
![在这里插入图片描述][20190529102754587.png]

[https_blog.csdn.net_qq_26264237_article_details_90636085]: https://blog.csdn.net/qq_26264237/article/details/90636085
[20190528160640740.png]: /images/20220126/8c8dd0a145324340833d9837c4198849.png
[20190529102851705.png]: /images/20220126/7f306b1bed36442792c722883028faf1.png
[http_localhost_8080_test-jndi2_hello_index]: http://localhost:8080/test-jndi2/hello/index
[20190529102754587.png]: /images/20220126/f5c40f87b2b44070a179d6ee8c67a23a.png