<data-sources>
  <data-source key="mysql" type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="defaultAutoCommit" value="true"/>
   <set-property property="defaultReadOnly" value="false"/>
   <set-property property="description" value="Tomcat Data Source"/>
   <set-property property="driverClassName" value="com.mysql.jdbc.Driver"/>
   <set-property property="maxActive" value="30"/>
   <set-property property="maxIdle" value="10"/>
   <set-property property="maxWait" value="10000"/>
   <set-property property="username" value="unicorn"/>
   <set-property property="password" value="unicorn"/>
   <set-property property="url" value="jdbc:mysql://localhost/goodbug"/>
  </data-source>
 </data-sources>

<%@ page contentType="text/html;charset=EUC_KR" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="org.apache.struts.config.ModuleConfig" %>
<%@ page import="org.apache.struts.util.*" %>
<%@ page import="java.sql.*" %>

<%!

/*

*   @key : datasource에 정의된 key 값

*/
public Connection getConnection(HttpServletRequest request, String key) throws Exception {
    ServletContext context = getServletContext();
    ModuleConfig moduleConfig = ModuleUtils.getInstance().getModuleConfig(request, context);
    DataSource dataSource = (DataSource)context.getAttribute(key + moduleConfig.getPrefix());
    return (dataSource.getConnection());
}
 %>

<%
Connection connection = null;
try {
    connection = getConnection(request, "mysql");
    out.println(connection);

} catch (Exception e) {
    e.getStackTrace();
} finally {
    if (connection != null) try { connection.close(); } catch (Exception e) {}
}
%>