DAO

1. interface interface service DAO 서비스 선언부 DAO 선언부 WEB-INF/conf + applicationContext-board.xml Inplements Inplements control Service.impl DAO.sqlmaps *.do Key 값선언부 서비스 구현부 J S P DAO 구현부 Parameter 값 Delegate Service,Dao define domain DAO.splmaps.maps beans

2. JSP등록시 추가할 부분 WEB-INF\conf\applicationContext-board.xml ①웹으로부터 <bean id="boardPropsResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver"> <property name="mappings"> <props> <prop key="/board/boardList.do">list</prop> <prop key="/board/boardView.do">view</prop> <prop key="/board/boardDelete.do">remove</prop> <prop key="/board/boardCode.do">code</prop> </props> </property> </bean> ② <bean id="boardDelegate" class="com.samsung.asw.web.board.BoardControl"> <property name="boardService"> <ref bean="boardService"/> </property> <property name="codeService"> <ref bean="codeService"/> </property> </bean> ③ <!-- Service define --> <bean id="codeService" parent="baseTransactionProxy"> <property name="target"> <bean class="com.samsung.asw.common.service.impl.CodeListServiceImpl"> <property name="codeDAO" ref="codeDAO"/> </bean> </property> </bean> ④ <!-- DAO define --> <bean id="codeDAO" class="com.samsung.asw.common.dao.sqlmaps.SqlMapCodeDAO"> <property name="dataSource" ref="aswDataSource"/> <property name="sqlMapClient" ref="sqlMapClient"/> </bean>

3. WEB-INF\conf\sqlMapContext.xml ⑤ <?xml version="1.0" encoding="euc-kr"?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="@MAX_REQUEST@" maxSessions="@MAX_SESSION@" maxTransactions="@MAX_TRANSACTION@" useStatementNamespaces="true"/> <typeAlias alias="hashMap" type="java.util.HashMap"/> <typeAlias alias="linkedMap" type="java.util.LinkedHashMap"/> <sqlMap resource="com/samsung/asw/board/dao/sqlmaps/maps/board.xml"/> <sqlMap resource="com/samsung/asw/project/dao/sqlmaps/maps/project.xml"/> <sqlMap resource="com/samsung/asw/common/dao/sqlmaps/maps/common-code.xml"/> ※sqlMap xml파일 등록시 등록해주는부분 </sqlMapConfig> Src.com.samsung.asw.web.board\BoardControl.java ⑥ private CodeService codeService = null; ※서비스 객체를 생성하고 초기화기켜준다. /*CodeList return*/ public ModelAndView code(HttpServletRequest request, HttpServletResponse response) throws Exception { Map map = RequestUtils.getMapParameter(request); ※ 파리미터값을 받아 맵형토로 만들어 넣는다 returnnew ModelAndView("board/CodeList", "codeList", codeService.getCodeList(map)); ※ Map담은 값을 서비스단으로 리턴한다 }

4. 패키지및추가파일 리스트 *Src.com.samsung.asw.common.dao CodeDAO.java *Src.com.samsung.asw.common.dao.sqlmaps SqlMapCodeDAO.java *src.com.samsung.asw.common.dao.sqlmaps.maps Common-code.xml *src.com.samsung.asw.common.domain CodeList.java *src.com.samsung.asw.common.service CodeService.java *src.com.samsung.asw.common.service.impl CodeListServiceImpl.java WEB-INF\jsp\ CodeList.java

5. *Src.com.samsung.asw.common.dao CodeDAO.java package com.samsung.asw.common.dao; /** *************************************************************************** *DAO선언부interface *@authorboyoung *@paramList(map) *@returnList(map) *@date2007.04.27 *************************************************************************** */ import java.util.List; import java.util.Map; import org.springframework.dao.DataAccessException; publicinterface CodeDAO { public List getCodeList(Map map) throws DataAccessException; ※ 리스트형태로 받는다. }

6. *Src.com.samsung.asw.common.dao.sqlmaps SqlMapCodeDAO.java package com.samsung.asw.common.dao.sqlmaps; /** *************************************************************************** *DAO구현부implements *@authorboyoung *@paramList(map) *@returnList(map) *@date2007.04.27 *************************************************************************** */ import java.util.List; import java.util.Map; import org.springframework.dao.DataAccessException; import com.samsung.asw.common.dao.CodeDAO; import com.samsung.asw.common.ibatis.ASWDAOSupport; publicclassSqlMapCodeDAOextends ASWDAOSupport implements CodeDAO { public List getCodeList(Map map) throws DataAccessException { System.out.println("test22222"); return getSqlMapClientTemplate().queryForList("asw.common.getCodeList",map); } }

7. *src.com.samsung.asw.common.dao.sqlmaps.maps Common-code.xml <?xml version="1.0" encoding="euc-kr"?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" > <sqlMap namespace="asw.common"> <!-- --> <select id="getCodeList" resultClass="com.samsung.asw.common.domain.CodeList" parameterClass="map"> SELECT common_grp AS commonGrp , common_cd AS commonCd , common_cd_nm AS commonCdNm , ref_code1 AS refCode1 , ref_code2 AS refCode2 , ref_code3 AS refCode3 FROM tco_code_detail WHERE common_grp=#COMMONGRP# </select> </sqlMap>

8. *src.com.samsung.asw.common.domain CodeList.java package com.samsung.asw.common.domain; /** *************************************************************************** * *@authorboyoung *@param *@returnString *@date2007.04.27 *************************************************************************** */ publicclass CodeList { private String CommonGrp; //대분류(pk) private String CommonCd; //코드 private String CommonCdNm; //코드명 private String refCode1; //참조값1 private String refCode2; //참조값2 private String refCode3; //참조값3 public String getCommonCd() { returnCommonCd; } publicvoid setCommonCd(String commonCd) { CommonCd = commonCd; } public String getCommonCdNm() { returnCommonCdNm; } publicvoid setCommonCdNm(String commonCdNm) {

9. *src.com.samsung.asw.common.service CodeService.java package com.samsung.asw.common.service; /** *************************************************************************** *service선언부interface *@authorboyoung *@paramList(map) *@returnList(map) *@date2007.04.27 *************************************************************************** */ import java.util.List; import java.util.Map; import org.springframework.dao.DataAccessException; publicinterface CodeService { public List getCodeList(Map map) throws DataAccessException; }

10. *src.com.samsung.asw.common.service.impl CodeListServiceImpl.java package com.samsung.asw.common.service.impl; import java.util.List; import java.util.Map; import org.springframework.dao.DataAccessException; import com.samsung.asw.common.dao.CodeDAO; import com.samsung.asw.common.service.CodeService; publicclass CodeListServiceImpl implements CodeService { private CodeDAO codeDAO = null; public List getCodeList(Map map) throws DataAccessException { System.out.println("test11111"); returncodeDAO.getCodeList(map); } publicvoid setCodeDAO(CodeDAO codeDAO) { this.codeDAO = codeDAO; } }

11. WEB-INF\jsp\ CodeList.java <%@page contentType="text/html;charset=euc-kr" %> <%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%> <html> <head> <title>자료실 게시판 - 리스트</title> <link rel=stylesheet href="${pageContext.request.contextPath}/css/board.css"type="text/css"> </head> <body bgcolor=#FFFFFF text=#000000 leftmargin=0 topmargin=0 marginwidth=0 marginheight=0> <!-- list --> <table border="0" cellpadding="0" cellspacing="1" width="100%" bgcolor="BBBBBB"> <tr> <td align=center bgcolor="E6ECDE"> 대분류 </td> <td align=center bgcolor="E6ECDE"> 코드 </td> <td width=center align=center bgcolor="E6ECDE"> 코드명 </td> <td width=center align=center bgcolor="E6ECDE"> 참조값1 </td> <td width=center align=center bgcolor="E6ECDE"> 참조값2 </td> <td width=center align=center bgcolor="E6ECDE"> 참조값3 </td> </tr>

12. <c:forEach items="${codeList}"var="board"> <tr> <td width=100 align=center bgcolor="ffffff"> ${board.commonGrp} </td> <td width=100 align=center bgcolor="ffffff"> ${board.commonCd} </td> <td width=150 align=center bgcolor="ffffff" style="padding-left:10"> ${board.commonCdNm} </td> <td width=150 align=center bgcolor="ffffff" style="padding-left:10"> ${board.refCode1} </td> <td width=150 align=center bgcolor="ffffff" style="padding-left:10"> ${board.refCode2} </td> <td width=150 align=center bgcolor="ffffff" style="padding-left:10"> ${board.refCode3} </td> </tr> </c:forEach> </table> <!-- /list --> <table border="0" cellpadding="0" cellspacing="1" width="100%"> <tr> <td align="center"> ${pageDivideForm} </td> </tr> </table> <!-- button --> <table border="0" cellpadding="0" cellspacing="1" width="100%"> <tr> <td align="right"> <input type="button" value="게시물 생성" onClick="location.href='${pageContext.request.contextPath}/board/editBoard.do'"/> </td> </tr> </table> </body> </html>