/** * 이 소스는 Spring 프레임워크 워크북에서 사용한 예제 소스입니다. * 이 소스는 모든 개발자들이 자유롭게 수정 및 배포할 수 있습니다. * 단, 이 소스를 기반으로 새로운 애플리케이션을 개발할 경우 출처를 명시해 주시면 됩니다. */ package net.javajigi.board.service; import java.util.List; import net.javajigi.board.dao.BoardDAO; import net.javajigi.board.dao.BoardFileDAO; import net.javajigi.board.model.Board; import net.javajigi.board.model.BoardFile; import net.javajigi.common.util.DateTimeUtil; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.TransactionDefinition; import org.springframework.transaction.TransactionStatus; import org.springframework.transaction.support.DefaultTransactionDefinition; public class PragrammaticBoardService implements BoardService { protected final Log logger = LogFactory.getLog(getClass());; private PlatformTransactionManager transactionManager; private BoardDAO boardDAO = null; private BoardFileDAO boardFileDAO = null; public void setTransactionManager( PlatformTransactionManager transactionManager) { this.transactionManager = transactionManager; } public void setBoardDAO(BoardDAO newBoardDAO) { this.boardDAO = newBoardDAO; } public void setBoardFileDAO(BoardFileDAO newBoardFileDAO) { this.boardFileDAO = newBoardFileDAO; } private TransactionDefinition getDefinition(int isolationLevel, boolean isReadOnly) { DefaultTransactionDefinition def = new DefaultTransactionDefinition( TransactionDefinition.PROPAGATION_REQUIRED); def.setTimeout(5000); def.setReadOnly(isReadOnly); def.setIsolationLevel(isolationLevel); return def; } public Board addBoard(Board board) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, false)); Board result = null; try { board.setCreateDate(DateTimeUtil .getDateTimeByPattern("yyyyMMddHHmmss")); result = boardDAO.insert(board); if (logger.isDebugEnabled()) { logger.debug("added new board!!. New Board ID : " + result.getBoardNo()); } boardFileDAO.insert(result.getBoardNo(), board.getBoardFiles()); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } public Board updateBoard(Board board) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, false)); Board result = null; try { result = boardDAO.update(board); if (logger.isDebugEnabled()) { logger.debug("updated board!!. Update Board ID : " + result.getBoardNo()); } boardFileDAO.insert(result.getBoardNo(), board.getBoardFiles()); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } public int removeBoard(int boardNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, false)); int result = 0; try { boardFileDAO.deleteByBoardNo(boardNo); result = boardDAO.delete(boardNo); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } public Board findBoard(int boardNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, true)); Board result = null; try { result = boardDAO.findBoard(boardNo); result.setBoardFiles(boardFileDAO.findBoardFileList(boardNo)); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } public Board findBoardWithView(int boardNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, false)); Board result = null; try { boardDAO.updateHitCount(boardNo); result = findBoard(boardNo); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } /* * (non-Javadoc) * * @see net.javajigi.board.service.BoardService#findBoardFile(int) */ public BoardFile findBoardFile(int boardFileNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, true)); BoardFile result = null; try { result = boardFileDAO.findBoardFile(boardFileNo); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } /* * (non-Javadoc) * * @see net.javajigi.board.service.BoardService#findBoardList(int, int) */ public List findBoardList(int currentPage, int countPerPage) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, true)); List resultList = null; try { resultList = boardDAO.findBoardList(currentPage, countPerPage); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return resultList; } /* * (non-Javadoc) * * @see net.javajigi.board.service.BoardService#updateHitCount(int) */ public int updateHitCount(int boardNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, false)); int result = 0; try { result = boardDAO.updateHitCount(boardNo); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } /* * (non-Javadoc) * * @see net.javajigi.board.service.BoardService#removeBoardFile(int) */ public int removeBoardFile(int fileNo) { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, true)); int result = 0; try { result = boardFileDAO.deleteByBoardFileNo(fileNo); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } /* * (non-Javadoc) * * @see net.javajigi.board.service.BoardService#getTotalNo() */ public int getBoardTotalCount() { TransactionStatus status = transactionManager .getTransaction(getDefinition( TransactionDefinition.ISOLATION_READ_COMMITTED, true)); int result = 0; try { result = boardDAO.getTotalNo(); transactionManager.commit(status); } catch (Throwable t) { transactionManager.rollback(status); if (t instanceof RuntimeException) { throw (RuntimeException) t; } } return result; } }