참고영상 : https://youtu.be/Jc9UTY_lcrY
개발환경
언어 : JAVA (JDK 11)
서버 : Apache Tomcat 9.0
프레임워크 : Spring Framework 3.9.18, MyBatis 3.5.8, Bootstrap 5.2.3
DB : OracleXE 11gR2
IDE : sts-3.9.18.RELEASE, SQL Developler
구현내용
- 메인페이지 / 게시판 목록 구현
0. 새 프로젝트 (store) 생성(🐥)
- spring legacy project
- Java 11 / UTF-8
- pom.xml -> maven update project
- pom.xml -> 라이브러리 9개 추가 (aspectj + mybatis 4개)
- web.xml -> UTF-8
- Apache Tomcat v9.0 추가
1. 서버 - index.jsp 연결하기
1. index.do 호출하면 index.jsp로 이동 : IndexController클래스
board.controller패키지 - IndexController클래스
package board.controller;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
/**
* Handles requests for the application home page.
*/
// http://localhost:8090/myapp/index.do
@Controller
public class IndexController {
public IndexController() {
// TODO Auto-generated constructor stub
}
@RequestMapping(value="/index.do")
public String home() {
return "/index";
}
}//class HomeController 2. controller와 viewResolver 설정 : common-content.xml
WEB-INF - spring - appServlet폴더에 common-content.xml생성
- Spring Bean Configuration File
- controller연결
- viewResolver로 jsp를 연결해줄 경로 지정
<?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.xsd">
<!-- controller -->
<bean class="board.controller.IndexController" />
<!-- viewResolver -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="WEB-INF/views"></property>
<property name="suffix" value=".jsp"></property>
</bean>
</beans>3. Configuration File등록 및 url-pattern 설정 : web.xml
- common-context.xml 추가
- url-pattern을 *.do로 변경
<!-- Processes application requests -->
<servlet>
<servlet-name>appServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/common-context.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>appServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>4. 서버 연결
5. index.jsp
- 사진을 누르면 게시글목록으로 이동할 수 있도록 a태그 추가
- 이미지 경로 :
src="resources/images/mainphoto.png"
<body>
<div align="center">
<h2>게시판(click!)</h2>
<h1>↓</h1>
<a href="#">
<img src="resources/images/mainphoto.png" width="200" height="200"/>
</a>
</div>
</body>6. 실행확인
2. boardlist.jsp 연결하기
1. DB테이블, 작업관련 클래스,인터페이스 생성
1. DataBase : boardBasic 테이블 생성
--DROP TABLE boardBasic;
CREATE TABLE boardBasic(
num number CONSTRAINT boardBasic_num PRIMARY KEY,
writer varchar2(50),
title varchar2(50),
content varchar2(100),
regdate date,
readcount number default 0
);
--DROP SEQUENCE boardBasic_num_seq;
CREATE SEQUENCE boardBasic_num_seq
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;
INSERT INTO boardBasic
VALUES(boardBasic_num_seq.nextval, '박재언','첫번째 게시글','첫번째 게시글의 내용입니다',sysdate,0);
select * from boardBasic;
commit;2. board.dto패키지 - BoardDTO클래스
- 멤버변수 : 테이블 칼럼 6개 + getter/setter
- 기본생성자
- 매개변수 6개 생성자
3. board.service패키지 - BoardService인터페이스
4. board.service패키지 - BoardServiceImp클래스
- implements BoardService
- 멤버변수 : BoardDAO + setter
- 기본생성자
5. board.controller패키지 - BoardController클래스
- @Controller
- 멤버변수 : BoardService + setter
- 기본생성자
6. src/main/resources - mapper폴더 - boardMapper.xml
- dtd설치 / namespace
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace = "board">
</mapper>2. 환경설정
1. WEB-INF/spring - appServlet폴더 - common-context.xml (🐥)
- [1] DataSource 빈 선언
- [2] SqlSessionFactoryBean 빈 선언
- [3] SqlSessionTemplate
- [4], [5] 트랜잭션 처리(aop,tx)
- DAO, Service, Boardcontroller 설정
3. 게시글 목록 페이지(list.jsp) 연결
1. 게시판목록으로 이동하기 위한 하이퍼링크 추가 : index.jsp
${pageContext.request.contextPath}: pageContext라는 객체에서 contextPath를 가져옴 (리턴값 : 현재 프로젝트 경로 /myapp)
<div align="center">
<h2>게시판(click!)</h2>
<h1>↓</h1>
<a href="${pageContext.request.contextPath}/list.do">
<img src="resources/images/mainphoto.png" width="200" height="200"/>
</a>
</div>2. list.jsp생성
<body>
<div align="center">
<h2>여기는 게시판 입니다!!!</h2>
<a href="#">글쓰기</a>
</div>
</body>2. /board/list.do : BoardController클래스
//http://localhost:8090/myapp/list.do
@RequestMapping(value="/list.do")
public ModelAndView listExecute(ModelAndView mav) {
mav.setViewName("/board/list");
return mav;
}3. 실행 확인
4. DB와 연결하여 게시글 목록 보여주기
1. SELECT쿼리문 작성 : boardMapper.xml
<select id="list" resultType="board.dto.BoardDTO">
SELECT * FROM board
ORDER BY num ASC
</select>2. BoardDaoImp
@Override
public List<BoardDTO> list() {
return sqlSession.selectList("board.list");
}3. BoardServiceImp
@Override
public List<BoardDTO> listProcess() {
return boardDao.list();
}4. /board/list.do : BoardController클래스
//http://localhost:8090/myapp/board/list.do
@RequestMapping(value="/board/list.do")
public ModelAndView listExecute(ModelAndView mav) {
mav.addObject("aList",boardService.listProcess());
mav.setViewName("board/list");
return mav;
}5. list.jsp 수정
<title>Board List</title>
<style>
tr, td {text-align:center;}
</style>
</head>
<body>
<h2>게시판 목록</h2>
<table>
<a href="#">글쓰기</a>
<thead>
<tr align="center">
<th>#</th>
<th width="40%">제목</th>
<th>작성자</th>
<th width="30%">작성일</th>
<th>조회수</th>
</tr>
</thead>
<tbody>
<c:forEach items="${aList}" var="dto">
<tr>
<td>${dto.num}</td>
<td>${dto.title}</td>
<td>${dto.writer}</td>
<td>${dto.regdate}</td>
<td>${dto.readcount}</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>5. 실행
씩씩하게 공부중 (22.11~)