SqlSession은 반드시 close해서 파괴해야 한다...

package dao.mybatis;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.session.SqlSession;

import pbean.Board;

import utils.MyBatisManager;

import dao.BoardDAO;

public class BoardDAOImpl implements BoardDAO {

public List<Board> getBoardList() {

List<Board> list = null;

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

try {

list = sqlSession.selectList("getBoardList");

} catch(Exception e) {

e.printStackTrace();

} finally {

sqlSession.close();

}

return list;

}

public Board getBoard(int num) {

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

return sqlSession.selectOne("getBoard", num);

}

public void addArticle(Board board) {

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

sqlSession.insert("insertBoard", board);

sqlSession.commit();

}

public void updArticle(Board board) {

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

sqlSession.update("updateBoard", board);

sqlSession.commit();

}

public void delArticle(int num) {

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

sqlSession.delete("deleteBoard", num);

sqlSession.commit();

}

public List<Board> getBoardList(Map<String, Object> map) {

//SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

//return sqlSession.selectList("getBoardListPaging", map);

List<Board> list = null;

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

try {

list = sqlSession.selectList("getBoardListPaging", map);

} catch(Exception e) {

e.printStackTrace();

} finally {

sqlSession.close();

}

return list;

}

public int getBoardCnt() {

int cnt = 0;

SqlSession sqlSession = MyBatisManager.getSqlSession().openSession();

try {

cnt = sqlSession.selectOne("getBoardCount");

} catch(Exception e) {

e.printStackTrace();

} finally {

sqlSession.close();

}

return cnt;

}

}