jndi(Java Naming and Directory interface)

<database>
  <jndi-name>jdbc/mysql</jndi-name>
  <driver type="com.mysql.jdbc.Driver">
    <url>jdbc:mysql://localhost:3306/database</url>
    <user>user</user>
    <password>password</password>
  </driver>
  <prepared-statement-cache-size>64</prepared-statement-cache-size>
  <max-connections>20</max-connections>
  <max-idle-time>30s</max-idle-time>
</database>
 
<database>
  <jndi-name>jdbc/oracle</jndi-name>
  <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
    <url>jdbc:oracle:thin:@127.0.0.1:1521:xe</url>
    <user>user</user>
    <password>password</password>
    <connectionProperties>
      <SetBigStringTryClob>true</SetBigStringTryClob>
    </connectionProperties>
  </driver>
 
  <prepared-statement-cache-size>64</prepared-statement-cache-size>
  <max-connections>20</max-connections>
  <max-idle-time>30s</max-idle-time>
</database>
 
<database>
  <jndi-name>jdbc/mssql</jndi-name>
  <driver type="com.microsoft.sqlserver.jdbc.SQLServerDriver">
    <url>jdbc:sqlserver:// 127.0.0.1:1433;DatabaseName=database</url>
    <user>user</user>
    <password>password</password>
  </driver>
  <prepared-statement-cache-size>64</prepared-statement-cache-size>
  <max-connections>20</max-connections>
  <max-idle-time>30s</max-idle-time>
</database>
 
<database>
  <jndi-name>jdbc/db2</jndi-name>
  <driver type="com.ibm.db2.jcc.DB2Driver">
    <url>jdbc:db2://127.0.0.1:50000/database</url>
    <user>user</user>
    <password>password</password>
  </driver>
  <prepared-statement-cache-size>64</prepared-statement-cache-size>
  <max-connections>20</max-connections>
  <max-idle-time>30s</max-idle-time>
</database>

<%@ page contentType="text/html; charset=utf-8" %>
<%@ page import="javax.naming.*, java.sql.*, javax.sql.*" %>
<%
String jndi = "java:comp/env/jdbc/mysql";
InitialContext ctx = new InitialContext();    // 현재 실행중인 등록된 컨텍스트를 가져옴
DataSource ds = (DataSource)ctx.lookup(jndi); // 데이터소스 획득 
 
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
 
try
{
   conn = ds.getConnection();
   stmt = conn.createStatement();
   rs = stmt.executeQuery("SELECT name, email, age FROM tb_user");
   while(rs.next())
   {
      out.println(rs.getString("name") + "<br>");
   }
 
}
catch(Exception e)
{
   out.print(e);
}
finally // 리소스 반환
{
   if(rs != null) rs.close(); rs = null;
   if(stmt != null) stmt.close(); stmt = null;
   if(conn != null) conn.close(); conn = null;
}
%>

레진(Resin)에서 데이터베이스 연동하기