Struts2 - 답변형 게시판 만들기(1) 작성,리스트

Dev/Struts

Struts2 - 답변형 게시판 만들기(1) 작성,리스트

창문닦이 2019. 3. 22. 18:04

게시판 만들기 - 게시글 작성 기능 구현

1. DB에 테이블 생성

create table bbs

(boardNum number(9) not null,

name varchar2(20) not null,

pwd varchar2(10),

email varchar2(50),

subject varchar2(50) not null,

content varchar2(4000) not null,

ipAddr varchar2(20) not null,

groupNum number(9) not null,

depth number(9) not null,

orderNo number(9) not null,

parent number(9) not null,

hitCount number(9) not null,

created date,

constraint pk_board_boardNum primary key(boardNum));

2. DTO생성

package com.board;

public class BoardDTO {

private int listNum;//일렬번호

private int boardNum;

private String name;

private String pwd;

private String email;

private String subject;

private String content;

private String ipAddr;

private int groupNum;

private int depth;

private int orderNo;

private int parent;

private int hitCount;

private String created;

private String searchKey;

private String searchValue;

private String pageNum;

private String mode;

//세개의 기능을 하는 하나의 창을 만들것 create, update, 답글작성

Getter, Setter 생성

}

3. Action 클래스 생성

package com.board;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;

import com.opensymphony.xwork2.ModelDriven;

import com.opensymphony.xwork2.Preparable;

public class BoardAction extends ActionSupport

implements Preparable,ModelDriven<BoardDTO>{

private static final long serialVersionUID = 1L;

private BoardDTO dto;

//getter만 생성

public BoardDTO getDto() {

return dto;

}

@Override

public BoardDTO getModel() {

return dto;

}

@Override

public void prepare() throws Exception {

dto = new BoardDTO();

}

public String created() throws Exception {

HttpServletRequest request = ServletActionContext.getRequest();

if(dto==null||dto.getMode()==null||dto.getMode().equals("")){

//게시물 작성창 띄우기

request.setAttribute("mode", "created");

return INPUT;

}

//게시물 저장 시 리턴값 success

return SUCCESS;

}

public String list() throws Exception {

//게시물 리스트 조회시 리턴값 success

return SUCCESS;

}

4. webContent board (JSP 폴더)생성

5. created.jsp 작성 (게시판 작성 페이지)

<%@ page contentType="text/html; charset=UTF-8"%>

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

function sendIt(){

f = document.myForm;

str = f.subject.value;

str = str.trim();//util.js에 있는 trim함수 호출

if(!str){

alert("\n제목을 입력하세요.");//공백제거후 내용이 없으면

f.subject.focus();

return;

}

f.subject.value = str;

str = f.name.value;

str = str.trim();

if(!str){

alert("\n이름을 입력하세요.");

f.name.focus();

return;

}

f.name.value = str;

//이름 한글검사

if(!isValidKorean(str)){

alert("\n이름을 정확히 입력하세요.");

f.name.focus();

return;

}

if(f.email.value){

if(!isValidEmail(f.email.value)){

alert("\n정상적인 E-mail을 입력하세요");

f.email.focus();

return;

}

str = f.content.value;

str = str.trim();

if(!str){

alert("\n내용을 입력하세요.");

f.content.focus();

return;

}

f.content.value = str;

str = f.pwd.value;

str = str.trim();

if(!str){

alert("\n패스워드를 입력하세요.");

f.pwd.focus();

return;

}

f.pwd.value = str;

if(f.mode.value=="created"){

f.action = "<%=cp%>/bbs/created.action" ;

}else if(f.mode.value=="updated"){

f.action = "<%=cp%>/bbs/updated.action" ;

}else{

f.action = "<%=cp%>/bbs/reply.action";

}

f.submit();

}

</script>

</head>

<body>

게 시 판(Struts2 + iBatis)

</div>

<dl>

<dd>

</dd>

</dl>

</div>

<dl>

<dd>

</dd>

</dl>

</div>

<dl>

<dd>

</dd>

</dl>

</div>

<dl>

<dd>

${dto.content}

</textarea>

</dd>

</dl>

</div>

<dl>

<dd>

 (게시물 수정 및 삭제시 필요)

</dd>

</dl>

</div>

<input type="hidden" name="boardNum" value="${dto.boardNum }"/>

<input type="hidden" name="pageNum" value="${dto.pageNum }"/>

<input type="hidden" name="groupNum" value="${dto.groupNum }"/>

<input type="hidden" name="orderNo" value="${dto.orderNo }"/>

<input type="hidden" name="depth" value="${dto.depth }"/>

<input type="hidden" name="parent" value="${dto.parent }"/>

<input type="hidden" name="mode" value="${mode }">

<input type="button" value="등록하기" class="btn2" onclick="sendIt();" />

<input type="reset" value="다시입력" class="btn2"

onclick="document.myForm.subject.focus();" />

<input type="button" value="작성취소" class="btn2"

onclick="javascript:location.href='<%=cp %>/bbs/list.action';" />

</div>

</form>

</div>

</body>

</html>

6. struts-board.xml 매핑정보 등록

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"

"http://struts.apache.org/dtds/struts-2.0.dtd">

<result name="input">/board/created.jsp</result>

</action>

<result name="success">/board/list.jsp</result>

</action>

</package>

</struts>

7. struts.xml에 include 등록

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"

"http://struts.apache.org/dtds/struts-2.0.dtd">

<global-results>

<result name="error">/exception/error.jsp</result>

</global-results>

</package>

</struts>

스트럿츠 프로퍼티에 환경설정 파일을 struts.xml로 해놓았으므로 해당파일에 include를 추가하면 같이 반영된다.

8. DAO로 사용할 SQL Map 생성(iBatis 활용)

board_sqlMap.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap

PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"

"http://ibatis.apache.org/dtd/sql-map-2.dtd">

select nvl(max(boardNum),0) from bbs

</select>

insert into bbs (boardNum,name,pwd,email,subject,content,ipAddr,groupNum,

depth,orderNo,parent,hitCount,created) values

(#boardNum#,#name#,#pwd#,#email#,#subject#,#content#,#ipAddr#,#groupNum#,

#depth#,#orderNo#,#parent#,0,sysdate)

</insert>

</sqlMap>

9. sqlMap_config에 mapper등록

sqlMapConfig.xml

게시판 만들기 - 게시판 리스트 기능 구현

1. sqlMap 작성

board_sqlMap.xml

그룹넘버는 내림차순정렬 오더넘버는 오름차순정렬

select nvl(count(*),0) from bbs

where $searchKey$ like '%' || #searchValue# || '%'

</select>

select * from (

select rownum rnum, data.* from(

select boardNum,name,subject,depth,hitCount,

to_char(created,'YYYY-MM-DD') created from bbs

where $searchKey$ like '%' || #searchValue# || '%'

order by groupNum desc, orderNo asc) data)

<![CDATA[

where rnum>=#start# and rnum<=#end#

]]>

</select>

2. Action에 메소드 추가

public String list() throws Exception {

//게시물 리스트 조회

CommonDAO dao = CommonDAOImpl.getInstance();

MyUtil myUtil = new MyUtil();

HttpServletRequest request = ServletActionContext.getRequest();

String cp = request.getContextPath();

int numPerPage = 5;

int totalPage = 0;

int totalDataCount = 0;

int currentPage = 1;

if(dto.getPageNum()!=null&&dto.getPageNum().equals("")){

currentPage = Integer.parseInt(dto.getPageNum());

}

if(dto.getSearchValue()==null||dto.getSearchValue().equals("")){

dto.setSearchKey("subject");

dto.setSearchValue("");

}

if(request.getMethod().equalsIgnoreCase("GET")){

dto.setSearchValue(URLDecoder.decode(dto.getSearchValue(),"UTF-8"));

}

Map<String, Object> hMap = new HashMap<String, Object>();

hMap.put("searchKey",dto.getSearchKey());

hMap.put("searchValue",dto.getSearchValue());

totalDataCount = dao.getIntValue("board.dataCount",hMap);

if(totalDataCount!=0){

totalPage = myUtil.getPageCount(numPerPage, totalDataCount);

}

if(currentPage>totalPage)

currentPage = totalPage;

int start = (currentPage-1)*numPerPage+1;

int end = currentPage*numPerPage;

hMap.put("start", start);

hMap.put("end", end);

List<Object> lists = (List<Object>)dao.getListData("board.listData", hMap);

int listNum,n=0;

ListIterator<Object> it = lists.listIterator();

while(it.hasNext()){

BoardDTO vo = (BoardDTO)it.next();

listNum = totalDataCount-(start+n-1);

vo.setListNum(listNum);

n++;

}

String param = "";

String urlList = "";

String urlArticle = "";

if(!dto.getSearchValue().equals("")){

param = "searchKey="+dto.getSearchKey();

param += "&searchValue="+URLEncoder.encode(dto.getSearchValue(),"UTF-8");

}

urlList = cp + "/bbs/list.action";

urlArticle = cp + "/bbs/article.action?pageNum="+currentPage;

if(!param.equals("")){

//검색한경우

urlList += "?" + param;

urlArticle += "&" + param;

}

request.setAttribute("lists",lists);

request.setAttribute("totalDataCount",totalDataCount);

request.setAttribute("pageIndexList",myUtil.pageIndexList(currentPage, totalPage, urlList));

request.setAttribute("urlArticle",urlArticle);

return SUCCESS;

}

3.list.jsp 생성

<%@ page contentType="text/html; charset=UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

function searchData(){

var f = document.searchForm;

f.action = "<%=cp%>/bbs/list.action";

f.submit();

}

</script>

</head>

<body>

게 시 판(Struts2 + iBatis)

</div>

</select>

</form>

</div>

<input type="button" value=" 글올리기 " class="btn2"

onclick="javascript:location.href='<%=cp %>/bbs/created.action';"/>

</div>

<dl>

</dl>

</div>

<c:forEach var="dto" items="${lists }">

<dl>

<dd class="num">${dto.listNum }</dd>

<a href="${urlArticle }&boardNum=${dto.boardNum}">${dto.subject}</a>

</dd>

<dd class="created">${dto.created}</dd>

<dd class="hitCount">${dto.hitCount}</dd>

</dl>

</div>

</c:forEach>

<p>

<c:if test="${totalDataCount!=0 }">

${pageIndexList }

</c:if>

<c:if test="${totalDataCount==0 }">

등록된 페이지가 없습니다

</c:if>

</p>

</div>

</body>

</html>

저작자표시 비영리 변경금지

'Dev > Struts' 카테고리의 다른 글

Struts1/iBatis - 회원가입 및 수정/로그인/비밀번호찾기 기능 구현 (0)	2019.03.23
Struts2 - 답변형 게시판 만들기(2) 게시글조회/답변/수정/삭제 (2)	2019.03.22
Struts2 - 입출력 기능 구현, Struts1과2 비교 (0)	2019.03.22
Struts2 세팅 (0)	2019.03.21
Struts1/iBatis - 파일 업로드 기능 구현 (0)	2019.03.21

현재글Struts2 - 답변형 게시판 만들기(1) 작성,리스트

창문을 열심히 닦아요