BoardMapperTests.java

package org.joonzis.mapper;

import static org.junit.Assert.fail;
import static org.springframework.test.web.servlet.result.MockMvcResultMatchers.request;

import java.sql.Connection;
import java.util.List;

import javax.sql.DataSource;
import javax.swing.border.Border;

import org.apache.taglibs.standard.lang.jstl.test.beans.PublicBean1;
import org.joonzis.domain.BoardVO;
import org.joonzis.domain.Criteria;
import org.joonzis.persistence.DataSourceTests;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import lombok.Setter;
import lombok.extern.log4j.Log4j;

@Log4j
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
public class BoardMapperTests {

	@Setter(onMethod_ = @Autowired)
	BoardMapper mapper;
	/*
	@Test
	public void testGetList() {
		//mapper.getList().forEach(board -> log.info(board));
		//vo 출력
		List<BoardVO> list = mapper.getList();
		for(BoardVO vo : list) {
			log.info(vo);
		}
	}
	*/
	/*
	@Test
	public void getListWithPaging() {
		Criteria cri = new Criteria(1, 10);
		List<BoardVO> list = mapper.getListWithPaging(cri);
		for(BoardVO vo : list) {
			log.info(vo);
		}
	}
	
	@Test
	public void testInsert() {
		BoardVO vo = new BoardVO();
		vo.setTitle("새로운 제목");
		vo.setContent("새로운 내용");
		vo.setWriter("새로운 작성자");
		mapper.insert(vo);
		log.info(vo);
		
	}
	
	@Test
	public void Read() {
		BoardVO vo = new BoardVO();
		mapper.read(5);
		log.info(vo);
	}
	
	@Test
	public void Delete() {
		int result = mapper.delete(1);
		log.info("삭제된 행의 수 : " + result);
	}
	
	@Test
	public void update() {
		BoardVO vo = new BoardVO();
		vo.setTitle("제목 수정");
		vo.setContent("내용 수정");
		vo.setWriter("작성자 수정");
		vo.setBno(2);
		int result = mapper.update(vo);
		log.info("수정된 행의 수 : " + result);
	}
	
	*/
	@Test
	public void getTotalCount() {
		int result = mapper.getTotalCount();
		log.info("전체 개수 : " + result );
	}
	
}