목록JSP (284)
WON.dev
package org.joonzis.vo; import java.sql.Date; public class BVO { private int b_idx, hit; private String writer, title, content, pw, ip, filename; private Date reg_date; public BVO() {} public BVO(int b_idx, int hit, String writer, String title, String content, String pw, String ip, String filename, Date reg_date) { super(); this.b_idx = b_idx; this.hit = hit; this.writer = writer; this.title = t..
package org.joonzis.service; import org.joonzis.dao.MDao; import org.joonzis.dao.MDaoImpl; import org.joonzis.vo.MVO; public class MemServiceImpl implements MemService{ MDao mdao = MDaoImpl.getInstance(); @Override public int goJoin(MVO mvo) { return mdao.goJoin(mvo); } @Override public int ckMember(MVO mvo) { return mdao.ckMember(mvo); } @Override public MVO getMember(MVO mvo) { return mdao.get..
package org.joonzis.service; import org.joonzis.vo.MVO; public interface MemService { public int goJoin(MVO mvo); public int ckMember(MVO mvo); public MVO getMember(MVO mvo); }
package org.joonzis.service; import java.util.List; import org.joonzis.dao.CDao; import org.joonzis.dao.CDaoImpl; import org.joonzis.vo.CVO; public class CommentServiceImpl implements CommentService{ private CDao cdao = CDaoImpl.getInstance(); @Override public int commentCountByIdx(int b_idx) { return cdao.commentCountByIdx(b_idx); } @Override public int insertComment(CVO cvo) { return cdao.inse..
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..