30초 만

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
   
   
    <!--
     datasource 설정(propertyConfigurer 활용)
     com.synervelly.common.web.dataaccess 여기서 다른 객체를 받는다.
    -->
    <alias name="dataSource-${First.DbType}"  alias="dataSource1" />
    <alias name="dataSource-${Second.DbType}" alias="dataSource2" /><!-- 다른 데이터 소스를 받을수 있음. -->
       
   
    <!-- Oracle -->
    <bean id="dataSource-oracle" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${First.DriverClassName}"/>
        <property name="url" value="${First.Url}" />
        <property name="username" value="${First.UserName}"/>
        <property name="password" value="${First.Password}"/>
        <property name="initialSize" value="10"/>
        <property name="maxActive" value="10"/>
        <property name="maxIdle" value="5"/>
        <property name="maxWait" value="10000"/>       
    </bean>
   
     <!-- MS-SQL2008 -->
    <bean id="dataSource-mssql" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${Second.DriverClassName}"/>
        <property name="url" value="${Second.Url}" />
        <property name="username" value="${Second.UserName}"/>
        <property name="password" value="${Second.Password}"/>
        <property name="initialSize" value="10"/>
        <property name="maxActive" value="10"/>
        <property name="maxIdle" value="5"/>
        <property name="maxWait" value="10000"/>       
    </bean>   
</beans> 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
    http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.1.xsd          
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd">

    <!-- lob Handler -->
    <bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />

    <!-- SqlMap setup for iBATIS Database Layer -->
    <bean id="sqlMapClient1" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocations">
            <list>
                <value>classpath:config/sqlmap/${First.DbType}/*.xml</value>
            </list>
        </property>
        <property name="dataSource" ref="dataSource-${First.DbType}"/>
        <property name="lobHandler" ref="lobHandler"/>
    </bean>
   
   
     <!-- SqlMap setup for iBATIS Database Layer -->
    <bean id="sqlMapClient2" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocations">
            <list>
                <value>classpath:config/sqlmap/${Second.DbType}/*.xml</value>
            </list>
        </property>
        <property name="dataSource" ref="dataSource-${Second.DbType}"/>
        <property name="lobHandler" ref="lobHandler"/>
    </bean>
   
   
   
  
     
</beans>   
 

public class WebAbstractSecondDAO  extends SqlMapClientDaoSupport {
  
    protected WebAbstractSecondDAO() {
           }

    /**
     * Annotation 형식으로 sqlMapClient 를 받아와 이를
     * super(SqlMapClientDaoSupport) 의 setSqlMapClient
     * 메서드를 호출하여 설정해 준다.
     * @param sqlMapClient  
     */
    @Resource(name = "sqlMapClient1")
    public void setSuperSqlMapClient(SqlMapClient sqlMapClient) {
        super.setSqlMapClient(sqlMapClient);
    }

     } 

ApplicationContext appContext = ContextLoaderListener.getCurrentWebApplicationContext();

(SqlMapClient) appContext.getBean("sqlMapClient"); 

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.util.FileCopyUtils;
import org.springframework.web.servlet.view.AbstractView;

public class FileDownloadView extends AbstractView {
 public FileDownloadView() {
  setContentType("application/download; charset=utf-8");
 }

 @Override
 protected void renderMergedOutputModel(Map<String, Object> model,
   HttpServletRequest request, HttpServletResponse response)
   throws Exception {
  File file = (File) model.get("downloadFile");
  response.setContentType(getContentType());
  response.setContentLength((int) file.length());
  String userAgent = request.getHeader("User-Agent");
  boolean ie = userAgent.indexOf("MSIE") > -1;
  String fileName = null;
  if (ie) {
   fileName = URLEncoder.encode(file.getName(), "utf-8");
  } else {
   fileName = new String(file.getName().getBytes("utf-8"),
     "iso-8859-1");
  }
  response.setHeader("Content-Disposition", "attachment; filename=\""
    + fileName + "\";");
  response.setHeader("Content-Transfer-Encoding", "binary");
  OutputStream out = response.getOutputStream();
  FileInputStream fis = null;
  try {
   fis = new FileInputStream(file);
   FileCopyUtils.copy(fis, out);
  } finally {
   if (fis != null)
    try {
     fis.close();
    } catch (IOException ex) {
    }
  }
  out.flush();
 }
} 

<opensymphony.sitemesh-version>2.4.2</opensymphony.sitemesh-version>

<dependency>
<groupId>opensymphony</groupId>
<artifactId>sitemesh</artifactId>
<version>${opensymphony.sitemesh-version}</version>
</dependency>

<?xml version="1.0" encoding="UTF-8"?>
<sitemesh>
    <property name="decorators-file" value="/WEB-INF/config/decorators.xml"/>
    <excludes file="${decorators-file}"/>

    <page-parsers>
        <parser content-type="text/html" class="com.opensymphony.module.sitemesh.parser.FastPageParser"/>
    </page-parsers>

    <decorator-mappers>

        <mapper class="com.opensymphony.module.sitemesh.mapper.PageDecoratorMapper">
            <param name="property.1" value="meta.decorator"/>
            <param name="property.2" value="decorator"/>
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.FrameSetDecoratorMapper">
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.AgentDecoratorMapper">
            <param name="match.MSIE" value="ie"/>
            <param name="match.Mozilla [" value="ns"/>
            <param name="match.Opera" value="opera"/>
            <param name="match.Lynx" value="lynx"/>
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.PrintableDecoratorMapper">
            <param name="decorator" value="printable"/>
            <param name="parameter.name" value="printable"/>
            <param name="parameter.value" value="true"/>
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.RobotDecoratorMapper">
            <param name="decorator" value="robot"/>
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.ParameterDecoratorMapper">
            <param name="decorator.parameter" value="decorator"/>
            <param name="parameter.name" value="confirm"/>
            <param name="parameter.value" value="true"/>
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.FileDecoratorMapper">
        </mapper>

        <mapper class="com.opensymphony.module.sitemesh.mapper.ConfigDecoratorMapper">
            <param name="config" value="${decorators-file}"/>
        </mapper>

    </decorator-mappers>

</sitemesh>  

 <?xml version="1.0" encoding="euc-kr"?>

<decorators defaultdir="/WEB-INF/jsp/layout">
 <excludes><!-- 예외 URL -->
  
  
    </excludes>

    <decorator name="cadmin-main" page="main-layout.jsp">
        <pattern>/main/*</pattern>
    </decorator>

   
   
</decorators>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="decorator" uri="http://www.opensymphony.com/sitemesh/decorator" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title><decorator:title default="제목없음" /></title>
<c:import url="/admin/include/style.do" />
<decorator:head />
</head>

<body onload="<decorator:getProperty property="body.onload" />">

<decorator:body />
</body>

</html> 

<org.apache.tiles-version>2.2.2</org.apache.tiles-version> 

<!-- tiles -->
  <dependency>
   <groupId>org.apache.tiles</groupId>
   <artifactId>tiles-core</artifactId>
   <version>${org.apache.tiles-version}</version>
  </dependency>
  <dependency>
   <groupId>org.apache.tiles</groupId>
   <artifactId>tiles-servlet</artifactId>
   <version>${org.apache.tiles-version}</version>
  </dependency>
  <dependency>
   <groupId>org.apache.tiles</groupId>
   <artifactId>tiles-jsp</artifactId>
   <version>${org.apache.tiles-version}</version>
  </dependency>

<bean id="tilesViewResolver" class="org.springframework.web.servlet.view.UrlBasedViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.tiles2.TilesView" />
<property name="order" value="1" />
</bean>
<!-- Tiles 2 definition lists. 20110916. -->
<bean id="tilesConfigurer" class="org.springframework.web.servlet.view.tiles2.TilesConfigurer">
<property name="definitions">
<list>
<value>classpath:/egovframework/tiles/layouts.xml</value>
</list>
</property>
</bean>
<!-- UrlBasedViewResolver InternalResourceViewResolver -->
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
<property name="order" value="2" />
</bean>