BDaoImpl.java

package org.joonzis.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;
import org.joonzis.mybatis.config.DBService;
import org.joonzis.vo.BVO;

public class BDaoImpl implements BDao{
	// DAO 객체 생성
	private static BDaoImpl instance = null;
	private BDaoImpl() {}
	public static BDaoImpl getInstance() {
		if(instance == null) {
			instance = new BDaoImpl();
		}
		return instance;
	}
	
	// 필드
	private static SqlSession sqlsession = null;
	private synchronized static SqlSession getSqlSession() {
		if(sqlsession == null) {
			sqlsession = DBService.getFactory().openSession(false);
		}
		return sqlsession;
	}
	
	
	@Override
	public int getTotalRecordCount() {
		return getSqlSession().selectOne("total_count_of_bbs");
	}
	
	@Override
	public List<BVO> getList(Map<String, Integer> map) {
		return getSqlSession().selectList("select_by_map", map);
	}
	@Override
	public BVO getBBS(int b_idx) {
		return getSqlSession().selectOne("bbs_by_idx", b_idx);
	}	
	@Override
	public void getUpdateHit(BVO bvo) {
		getSqlSession().update("update_hit", bvo);
	}
	@Override
	public int getInsertBBS(BVO bvo) {
		int result = getSqlSession().insert("insert_bbs",bvo);
		if(result > 0) {
			getSqlSession().commit();
		}
		return result;
	}
	@Override
	public void updateBBS(BVO bvo) {
		getSqlSession().update("update_bbs",bvo);
	}
	@Override
	public int removeBBS(int b_idx) {
		int result = getSqlSession().delete("delete_bbs",b_idx);
		if(result > 0) {
			getSqlSession().commit();
		}
		return result;
	}
	
}