1 / 12

DAO

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.

courtney
Download Presentation

DAO

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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>

More Related