[Source] Connection Test

<%@ page contentType="text/html; charset=euc-kr" %>   
<%@ page import="java.sql.*,java.text.*,java.util.*,java.text.Format.*"%> 
<%@ page import="javax.naming.*,javax.sql.*" %> 
<%
    String strsql   = "select count(*) from test_10"; 
    Connection conn = null; Statement stmt = null; 
    ResultSet rset = null;  
    
    try {         
        Context ctx = new InitialContext();         
        DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/SpringDS");           
        
        conn = ds.getConnection();
        out.println("conn :: " + conn);
        stmt = conn.createStatement();
        rset = stmt.executeQuery(strsql);
        
        while (rset.next()) {                 
        	out.println(rset.getString(1));         
        }   
    }catch(Exception e){
        out.println("Error : ");         
        out.println(e.getMessage());  
    } finally {         
        if ( rset != null ) rset.close();         
        if ( stmt != null ) stmt.close();         
        if ( conn != null ) conn.close(); 
    }
%>

---

https://hermeslog.tistory.com/628

[Source] JDBC Connection Test && JDBC Version 확인