160628: 73회차

종료하기 전 티스토리 네이버 로그아웃 할 것

1. 툴

동일

추가시: 

2. 폴더

동일

추가시:

3. 사용할 사이트

동일

추가시:

4. 공부하는 것

[08]Spring_blog ReplyDAOTest 생성

1. ReplyDAO.java

package spring.model.bbs;

 

import java.util.List;

import java.util.Map;

 

import org.mybatis.spring.SqlSessionTemplate;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

 

@Repository

public class ReplyDAO {

 

@Autowired

private SqlSessionTemplate sqlSessionTemplate;

 

public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {

this.sqlSessionTemplate = sqlSessionTemplate;

}

 

public boolean create(ReplyDTO dto) {

boolean flag = false;

 

int cnt = sqlSessionTemplate.insert("reply.create", dto);

if (cnt > 0)

flag = true;

 

return flag;

}

 

public ReplyDTO read(int rnum) {

 

return (ReplyDTO) sqlSessionTemplate.selectOne("reply.read", rnum);

 

}

 

public boolean update(ReplyDTO dto) {

boolean flag = false;

 

int cnt = sqlSessionTemplate.update("reply.update", dto);

if (cnt > 0)

flag = true;

 

return flag;

}

 

public List<ReplyDTO> list(Map map) {

 

return sqlSessionTemplate.selectList("reply.list", map);

}

 

public int total(int bbsno) {

return (Integer) sqlSessionTemplate.selectOne("reply.total", bbsno);

}

 

public boolean delete(int rnum) {

boolean flag = false;

int cnt = sqlSessionTemplate.delete("reply.delete", rnum);

if (cnt > 0)

flag = true;

 

return flag;

}

 

/** 하나의 글의 여러댓글들 삭제 */

public int bdelete(int bbsno) throws Exception {

return sqlSessionTemplate.delete("reply.bdelete", bbsno);

 

}

}


2. ReplyDAOTest.java 생성







package spring.testl.bbs;

 

import static org.junit.Assert.assertEquals;

import static org.junit.Assert.assertTrue;

import static org.junit.Assert.fail;

 

import java.util.HashMap;

import java.util.List;

import java.util.Map;

 

import org.junit.After;

import org.junit.AfterClass;

import org.junit.Before;

import org.junit.BeforeClass;

import org.junit.Ignore;

import org.junit.Test;

import org.springframework.beans.factory.BeanFactory;

import org.springframework.beans.factory.xml.XmlBeanFactory;

import org.springframework.core.io.ClassPathResource;

import org.springframework.core.io.Resource;

 

import spring.model.bbs.ReplyDAO;

import spring.model.bbs.ReplyDTO;

public class ReplyDAOTest {

private static BeanFactory beans;

@BeforeClass

public static void setUpBeforeClass() throws Exception {

 

Resource resource = new ClassPathResource("blog.xml");

 

beans = new XmlBeanFactory(resource);

 

}

 

@AfterClass

public static void tearDownAfterClass() throws Exception {

 

}

 

@Before

public void setUp() throws Exception {

}

 

@After

public void tearDown() throws Exception {

 

}

 

@Ignore @Test

public void testSetSqlSessionTemplate() {

fail("Not yet implemented");

}

 

@Test @Ignore

public void testCreate() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

ReplyDTO dto = new ReplyDTO();

dto.setBbsno(1);

dto.setContent("댓글2");

dto.setId("user1");

assertTrue(dao.create(dto));

}

 

@Test @Ignore

public void testRead() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

ReplyDTO dto = dao.read(1);

assertEquals(dto.getBbsno(),1L);

assertEquals(dto.getId(),"user1");

assertEquals(dto.getContent(),"의견입니다.");

 

}

 

@Test

public void testUpdate() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

ReplyDTO dto = new ReplyDTO();

dto.setBbsno(1);

dto.setContent("댓글2로변경");

dto.setId("user1");

dto.setRnum(1);

assertTrue(dao.update(dto));

 

}

 

@Test 

public void testList() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

Map map = new HashMap();

map.put("bbsno", 1);

map.put("sno", 1);

map.put("eno", 6);

List<ReplyDTO> list = dao.list(map);

assertEquals(list.size(),5);

}

 

@Test 

public void testTotal() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

int cnt = dao.total(1);

assertEquals(cnt,5);

}

 

@Test @Ignore

public void testDelete() {

ReplyDAO dao = (ReplyDAO) beans.getBean("rdao");

assertTrue(dao.delete(6));

}

 

@Test @Ignore

public void testBdelete() {

fail("Not yet implemented");

}

 

}

 

5. 수업

진도: 

hw: 

6. 할것