목록전체 글 (763)
WON.dev
package org.joonzis.service; import java.util.List; import org.joonzis.vo.CVO; public interface CommentService { public int commentCountByIdx(int b_idx); public int insertComment(CVO cvo); public List getCommentList(int b_idx); public void removeComment(int c_idx); public void removeCommentAll(int b_idx); }
package org.joonzis.service; import java.util.List; import java.util.Map; import org.joonzis.dao.BDao; import org.joonzis.dao.BDaoImpl; import org.joonzis.vo.BVO; public class BBSServiceImpl implements BBSService{ private BDao bdao = BDaoImpl.getInstance(); @Override public int recordCount() { return bdao.getTotalRecordCount(); } @Override public List getBBSList(Map map) { return bdao.getList(ma..
package org.joonzis.service; import java.util.List; import java.util.Map; import org.joonzis.vo.BVO; public interface BBSService { // 전체 게시물 수 public int recordCount(); // 페이징 처리된 게시글 public List getBBSList(Map map); // 상세 페이지 public BVO getBBS(int b_idx); // 조회수 증가 public void getUpdateHit(BVO bvo); // 게시글 작성 public int getInsertBBS(BVO bvo); // 게시글 수정 public void updateBBS(BVO bvo); // 게시글 삭제 ..
INSERT INTO MEMBER_T VALUES( member_seq.nextval, #{mid}, #{mpw}, #{mname}, #{mtel}, #{mage}, sysdate ) SELECT COUNT(*) FROM MEMBER_T WHERE MID=#{mid} AND MPW=#{mpw} SELECT * FROM MEMBER_T WHERE MID=#{mid} AND MPW=#{mpw}
SELECT COUNT(*) FROM COMMENT_T WHERE B_IDX=#{b_idx} INSERT INTO COMMENT_T VALUES( comment_seq.nextval, #{writer}, #{content}, #{pw}, #{ip}, sysdate, #{b_idx} ) SELECT * FROM COMMENT_T WHERE B_IDX=#{b_idx} DELETE FROM COMMENT_T WHERE C_IDX=#{c_idx} DELETE FROM COMMENT_T WHERE B_IDX=#{b_idx}
SELECT COUNT(*) FROM BBS_T SELECT * FROM (SELECT rownum r_num, A.* FROM (SELECT * FROM BBS_T ORDER BY B_IDX DESC)A) WHERE r_num BETWEEN #{begin} and #{end} SELECT * FROM BBS_T WHERE b_idx=#{b_idx} UPDATE BBS_T SET HIT=#{hit} WHERE B_IDX=#{b_idx} INSERT INTO BBS_T VALUES( bbs_seq.nextval, #{writer}, #{title}, #{content}, #{pw}, 0, #{ip}, #{filename}, sysdate ) UPDATE BBS_T SET title=#{title}, con..
package org.joonzis.mybatis.config; import java.io.InputStream; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class DBService {// factory를 만드는게 목적 // 필드 private static SqlSessionFactory factory = null; // 싱글톤 static { try { String resource = "org/joonzis/mybatis/config/sqlmap.xml"; Inpu..
package org.joonzis.model; public class Paging { // Field private int totalRecord = 0;// 전체 게시물의 개수 private int recordPerPage = 3;// 한 페이지당 표시할 게시물 개수 private int totalPage = 0;// 전체 페이지 개수 private int nowPage = 1;// 현재 페이지 번호 private int begin = 0;// 현재 페이지에 표시할 시작 게시물의 번호 private int end = 0;// 현재 페이지에 표시할 종료 게시물의 번호 private int pagePerBlock = 3; // 한 블록에 포함되는 페이지 수 (ex 1블록 : 1 2 3, 2블록: 4 5 6..
package org.joonzis.dao; import org.apache.ibatis.session.SqlSession; import org.joonzis.mybatis.config.DBService; import org.joonzis.vo.MVO; public class MDaoImpl implements MDao{ // DAO 객체 생성 private static MDaoImpl instance = null; private MDaoImpl() {} public static MDaoImpl getInstance() { if(instance == null) { instance = new MDaoImpl(); } return instance; } // 필드 private static SqlSession..