DEVLOG DEVLOG

Mapper 작성 ... UPDATE board SET title=#{title}, content=#{content}, editTime=now() WHERE bno=#{bno} Dao 작성 // Dao/BoardDao.java ... //추가 public void updatePosts(BoardVo posts) throws Exception{ sqlSession.update(Namespace + ".update", posts); } 테스트케이스 작성 // test/boardDaoTest.java ... //추가 @Test public void testUpdatePosts() throws Exception{ BoardVo posts = new BoardVo(); posts.setBno(1); posts.s..

Mapper 작성 // mapper/BoardMapper.xml ... DELETE FROM board WHERE bno = #{bno} Dao 작성 // Dao/BoardDao.java ... //추가 public void deletePosts(int bno) throws Exception{ sqlSession.delete(Namespace + ".delete", bno); } 테스트 케이스 작성 // test/boardDaoTest.java ... //추가 @Test public void testDeletePosts() throws Exception{ int bno = 3; boardDao.deletePosts(bno); } Service 작성 //Service/BoardService.java .....

Mapper 작성 // mappers/BoardMapper.xml ... SELECT * FROM board WHERE bno = #{bno} Dao 작성 // Dao/BoardDao.java ... //추가 public BoardVo detailPosts(int bno) throws Exception{ return sqlSession.selectOne(Namespace + ".detail", bno); } 테스트 케이스 작성 // test/boardDaoTest.java ... //추가 @Test public void testDetailPosts() throws Exception{ int bno = 2; BoardVo post = boardDao.detailPosts(bno); logger.info(p..

게시글 작성 View 생성 // views/index.jsp NO TITLE WRITER COUNT DATE ${item.bno} ${item.title} ${item.writer} ${item.count} ${item.createTime} WRITE // views/write.jsp Title Content WRITE Mapper 작성 // mappers/BoardMapper.xml SELECT * FROM board INSERT INTO board (title, content, writer, createTime, editTime) VALUES (#{title}, #{content}, "writer", now(), now()) Dao 작성 // Dao/BoardDao.java ... //추가 publi..

Service 생성 // Service/BoardService.java @Service public class BoardService { @Inject private BoardDao boardDao; public List getBoardList() throws Exception{ return boardDao.getBoardList(); } } Controller 생성 // Controller/BoardController.java @Controller public class BoardController { @Inject private BoardService boardService; @RequestMapping(value="/boardList", method=RequestMethod.GET) public M..

테이블 생성 패키지 생성 VO 생성 // com.ms.board.Vo/boardVo public class boardVo { private int bno; private String title; private String content; private int count; private String writer; private LocalDate createTime; private LocalDate editTIme; ... //Getter Setter 생략 } SQL 쿼리 작성 SELECT * FROM board DAO 생성 // Dao/BoardDao.java @Repository("BoardDao") public class BoardDao { @Inject private SqlSession sqlSess..

프로젝트 생성 Spring Legacy Project -> Spring MVC Project 톰캣 설정 Character Encoding 설정 encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 forceEncoding true encodingFilter /* 스프링 환경 설정 servlet-context.xml를 [src/main/resources/]에 root-context.xml는 [src/main/resources/]에 spring이라는 폴더를 만들어 관리 contextConfigLocation classpath:spring/*-context.xml org.springframework.web.con..