[SPRING] modelandview abstract 엑셀뷰 적용 방법

참조사이트
http://www.mkyong.com/spring-mvc/spring-mvc-export-data-to-excel-file-via-abstractexcelview/

1. APACHE POI 설정

   <!-- Excel library --> 
   <dependency>
 <groupId>org.apache.poi</groupId>
 <artifactId>poi</artifactId>
 <version>3.6</version>
   </dependency> 

2. XmlViewResolver for the Excel view. 


Markup

ㅇ<beans ...>

  <bean
  class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping" />

 <bean class="com.mkyong.common.controller.RevenueReportController" />

 <bean class="org.springframework.web.servlet.view.XmlViewResolver">
  <property name="location">
   <value>/WEB-INF/spring-excel-views.xml</value>
  </property>
 </bean>

</beans>


File : spring-excel-views.xml


Markup

   <bean id="ExcelRevenueSummary"
    class="com.mkyong.common.view.ExcelRevenueReportView">
   </bean>
이렇게 한후 컨트롤 단에서 return new MoedelAndView("excelView", "exceldata", ModelMap)
이렇게 호출하면됨

[JQGRID] 그리드내부 selectbox 동적으로 컨트롤하는법

function comInfoChange(data){
var temp1="";
                $.post('<%=contextRoot%>/comList.cni').done(function(data) {
                $.each(JSON.parse(data), function(i, data) {
                     temp1=temp1+data.companycd+":"+data.companynm+";";
                 });                                    
                $("#endingMngGrid").setColProp('companycd', { editoptions: { value: temp1.slice(0,-1)} });
              //마지막 ; 제거를 위해 slice 함
        });
       
}