CDaoImpl.java

package org.joonzis.dao;

import java.util.List;

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

public class CDaoImpl implements CDao{
	// DAO 객체 생성
	private static CDaoImpl instance = null;
	private CDaoImpl() {}
	public static CDaoImpl getInstance() {
		if(instance == null) {
			instance = new CDaoImpl();
		}
		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 commentCountByIdx(int b_idx) {
		return getSqlSession().selectOne("comment_count_by_idx", b_idx);
	}
	@Override
	public int insertComment(CVO cvo) {
		int result = getSqlSession().insert("insert_comment", cvo);
		if(result > 0) {
			getSqlSession().commit();
		}
		return 0;
	}
	@Override
	public List<CVO> getCommentList(int b_idx) {
		return getSqlSession().selectList("select_comm_by_bidx", b_idx);
	}
	@Override
	public void removeComment(int c_idx) {
		int result = getSqlSession().delete("delete_comm_by_cidx", c_idx);
		if(result > 0) {
			getSqlSession().commit();
		}
	}
	@Override
	public void removeCommentAll(int b_idx) {
		int result = getSqlSession().delete("delete_all_comm", b_idx);
		if(result > 0) {
			getSqlSession().commit();
		}
	}
}