public class EgovExcelServiceImpl extends Object implements EgovExcelService, org.springframework.context.ApplicationContextAware
NOTE: 엑셀 서비스를 제공하기 위해 구현한 클래스이다.
== 개정이력(Modification Information) == 수정일 수정자 수정내용 ----------- -------- --------------------------- 2009.06.01 윤성종 최초 생성 2013.05.22 이기하 XSSF, SXSSF형식 추가(xlsx 지원) 2013.05.29 한성곤 mapBeanName property 추가 및 코드 정리 2014.05.14 이기하 코드 refactoring 및 mybatis 서비스 추가
| Constructor and Description |
|---|
EgovExcelServiceImpl() |
| Modifier and Type | Method and Description |
|---|---|
org.apache.poi.ss.usermodel.Workbook |
createWorkbook(org.apache.poi.ss.usermodel.Workbook wb,
String filepath)
Workbook 객체를 생성하여 엑셀파일을 생성한다.
|
protected org.springframework.context.MessageSource |
getMessageSource()
MessageSource 얻기.
|
org.apache.poi.ss.usermodel.Workbook |
loadExcelTemplate(String templateName)
엑셀 Template를 로딩하여 엑셀파일을 생성한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadExcelTemplate(String templateName,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀 Template를 로딩하여 엑셀파일을 생성한다.
|
org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(InputStream fileIn)
엑셀 파일을 로딩한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadWorkbook(InputStream fileIn,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀 파일을 로딩한다.
|
org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(String filepath)
엑셀 파일을 로딩한다.
|
org.apache.poi.xssf.usermodel.XSSFWorkbook |
loadWorkbook(String filepath,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀 파일을 로딩한다.
|
void |
setApplicationContext(org.springframework.context.ApplicationContext applicationContext) |
void |
setMapBeanName(String mapBeanName)
Excel Cell과 VO를 mapping 구현 Bean name (mapClass보다 우선함).
|
void |
setMapClass(String mapClass)
Excel Cell과 VO를 mapping 구현 클래스.
|
void |
setSqlMapClient(com.ibatis.sqlmap.client.SqlMapClient sqlMapClient)
ibatis 적용시 설정.
|
void |
setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)
mybatis 적용시 설정.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn)
엑셀파일을 저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
int start,
long commitCnt)
엑셀파일을 읽어서 DB upload 한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀파일을 읽어서 DB upload 한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
short sheetIndex,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
short sheetIndex,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
String sheetName,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
String sheetName,
int start,
long commitCnt,
org.apache.poi.xssf.usermodel.XSSFWorkbook wb)
xlsx 엑셀파일을 업로드하여 DB에 일괄저장한다.
|
Integer |
uploadExcel(String queryId,
InputStream fileIn,
org.apache.poi.xssf.usermodel.XSSFWorkbook type)
xlsx 엑셀파일을 저장한다.
|
Integer |
uploadExcel(String queryId,
org.apache.poi.ss.usermodel.Sheet sheet,
int start,
long commitCnt)
엑셀파일을 업로드하여 DB에 일괄저장한다.
|
public void setApplicationContext(org.springframework.context.ApplicationContext applicationContext)
throws org.springframework.beans.BeansException
setApplicationContext in interface org.springframework.context.ApplicationContextAwareorg.springframework.beans.BeansExceptionprotected org.springframework.context.MessageSource getMessageSource()
public void setSqlMapClient(com.ibatis.sqlmap.client.SqlMapClient sqlMapClient)
throws Exception
sqlMapClient - Exceptionpublic void setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)
throws Exception
sqlSessionTemplate - Exceptionpublic void setMapClass(String mapClass) throws egovframework.rte.fdl.cmmn.exception.BaseException
mapClass - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic void setMapBeanName(String mapBeanName) throws egovframework.rte.fdl.cmmn.exception.BaseException
mapBeanName - egovframework.rte.fdl.cmmn.exception.BaseExceptionpublic org.apache.poi.ss.usermodel.Workbook createWorkbook(org.apache.poi.ss.usermodel.Workbook wb,
String filepath)
throws egovframework.rte.fdl.cmmn.exception.BaseException,
FileNotFoundException,
IOException
createWorkbook in interface EgovExcelServicewb - filepath - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionFileNotFoundExceptionIOExceptionpublic org.apache.poi.ss.usermodel.Workbook loadExcelTemplate(String templateName) throws egovframework.rte.fdl.cmmn.exception.BaseException, FileNotFoundException, IOException
loadExcelTemplate in interface EgovExcelServicetemplateName - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionFileNotFoundExceptionIOExceptionpublic org.apache.poi.xssf.usermodel.XSSFWorkbook loadExcelTemplate(String templateName, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException, FileNotFoundException, IOException
loadExcelTemplate in interface EgovExcelServicetemplateName - wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionFileNotFoundExceptionIOExceptionpublic org.apache.poi.ss.usermodel.Workbook loadWorkbook(String filepath) throws egovframework.rte.fdl.cmmn.exception.BaseException, FileNotFoundException, IOException
loadWorkbook in interface EgovExcelServicefilepath - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionFileNotFoundExceptionIOExceptionpublic org.apache.poi.xssf.usermodel.XSSFWorkbook loadWorkbook(String filepath, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException, FileNotFoundException, IOException
loadWorkbook in interface EgovExcelServicefilepath - wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionFileNotFoundExceptionIOExceptionpublic org.apache.poi.ss.usermodel.Workbook loadWorkbook(InputStream fileIn) throws egovframework.rte.fdl.cmmn.exception.BaseException
loadWorkbook in interface EgovExcelServicefilepath - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic org.apache.poi.xssf.usermodel.XSSFWorkbook loadWorkbook(InputStream fileIn, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException
loadWorkbook in interface EgovExcelServicefileIn - wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, org.apache.poi.ss.usermodel.Sheet sheet, int start, long commitCnt) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - sheet - start - (default : 0)commitCnt - (default :0)Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, int start, long commitCnt) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - start(default - : 0)commitCnt(default - : 0)Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - start - commitCnt - wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, org.apache.poi.xssf.usermodel.XSSFWorkbook type) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, short sheetIndex, int start, long commitCnt) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - sheetIndex - start - (default : 0)commitCnt - (default : 0)Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, short sheetIndex, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - sheetIndex - start - (default : 0)commitCnt - (default : 0)wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, String sheetName, int start, long commitCnt) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - sheetName - start - (default : 0)commitCnt - (default : 0)Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionpublic Integer uploadExcel(String queryId, InputStream fileIn, String sheetName, int start, long commitCnt, org.apache.poi.xssf.usermodel.XSSFWorkbook wb) throws egovframework.rte.fdl.cmmn.exception.BaseException, Exception
uploadExcel in interface EgovExcelServicequeryId - fileIn - sheetName - start - (default : 0)commitCnt - (default : 0)wb - Exceptionegovframework.rte.fdl.cmmn.exception.BaseExceptionCopyright © 2015. All rights reserved.