Heaven helps those who help themselves. :: 40일차: ibatis로 간단한 게시판 짜기

40일차: ibatis로 간단한 게시판 짜기

Programing/Spring/Struts/iBatis 2009/08/22 15:30

com.mydomain.data 패키지 - BoardDAO.java, Board.xml, SqlMapConfig.xml

domain 패키지 - Board.java, SearchKey.java

WebContent 폴더 - delete.jsp, detail.jsp, insert_form.jsp, insert.jsp, list.jsp, update_form.jsp, update.jsp

SqlMapConfig.xml

Board.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">
    
<sqlMap namespace = "Board">
	<typeAlias alias="Board" type="domain.Board"/>
	<typeAlias alias="SearchKey" type="domain.SearchKey"/>
	
	<insert id="insertBoard" parameterClass="Board">
		insert into Board2(
			SEQ,
			TITLE,
			WRITER,
			CONTENTS,
			REGDATE,
			HITCOUNT
		)
		values(
			board_seq.NEXTVAL,
			#title#,
			#writer#,
			#contents#,
			SYSDATE,
			0
		)
	</insert>
	
	<select id="selectBoardList" resultClass="Board">
		select * from board2 order by seq desc
	</select>
	
	<select id="searchBoardList" parameterClass="String" resultClass="Board">
		select * from board2 where title like '%$search$%'
		
	</select>
	
	<select id="searchBoardList2" parameterClass="SearchKey" resultClass="Board">
		select * from board2
		<dynamic prepend=" where ">
			<iterate property="areas" conjunction="or"
				open="(" close=")">
				$areas[]$ like #searchKey# 
							
			</iterate>		
		</dynamic>
	</select>
	
	
	
	<select id="ex01">
		select * from table
		<dynamic prepend="where produtType IN">
			<iterate property="productTypes" open="(" close=")" conjunction=",">
				productType = #productTypes[]#
				
			</iterate>
		</dynamic>	
	</select>
	
	
	<update id="hitplus" parameterClass="int">
		update board2 set
			hitcount = hitcount+1 
		where
			seq = #seq#
	</update>
	
	<select id="detailBoard" parameterClass="int" resultClass="Board">		
		select * from board2 where seq = #seq#
	</select>
	
	<update id="updateboard" parameterClass="Board">
		update board2 set
			TITLE = #title#,			
			CONTENTS = #contents#			
		where
			SEQ = #seq#		
	</update>
	
	
	<delete id="deleteboard" parameterClass="int">
		delete from board2 where SEQ = #seq# 
	</delete>
	
	
</sqlMap>

BoardDAO.java

package com.mydomain.data;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.ibatis.common.resources.Resources;
import domain.*;
import java.util.*;

import java.io.Reader;
import java.io.IOException;

public class BoardDAO {
  
  private static SqlMapClient sqlMapper;

static {
    try {
      Reader reader = Resources.getResourceAsReader("com/mydomain/data/SqlMapConfig.xml");
      sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
      reader.close(); 
    } catch (IOException e) {
      // Fail fast.
      throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e);
    }
  } 
  
  public void insertBoard(Board board) throws Exception{
	sqlMapper.insert("insertBoard",board);  
  }
  
  public List selectAllBoards() throws Exception{
	  return sqlMapper.queryForList("selectBoardList");
  }
  
  public Board detailBoard(int seq) throws Exception{
	  return (Board)sqlMapper.queryForObject("detailBoard",seq);
  }
  
  public void hitPlus(int seq) throws Exception{
	  sqlMapper.update("hitplus",seq);
  }
  
  public void updateBoard(Board board) throws Exception{
	  sqlMapper.update("updateboard",board);
  }

public void deleteBoard(int seq) throws Exception{
	  sqlMapper.delete("deleteboard",seq);
  }
  
  public List searchAllBoards(String search)throws Exception{
	  return sqlMapper.queryForList("searchBoardList",search);
  }
  
  public List searchAllBoards2(SearchKey key)throws Exception{
	  return sqlMapper.queryForList("searchBoardList2",key); 
  }
}

Board.java

SearchKey.java

delete.jsp

detail.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import = "com.mydomain.data.*" %>
<%@ page import = "domain.*" %>
<%
	BoardDAO dao = new BoardDAO();
	int seq = Integer.parseInt(request.getParameter("seq"));
	dao.hitPlus(seq);
	Board b = dao.detailBoard(seq);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
<script type="text/javascript">
function fn_goList() {
	location.href = "list.jsp";
}
function fn_goUpdateForm() {
	location.href = "update_form.jsp?seq=<%=seq%>";
}
function fn_goDelete() {
	location.href = "delete.jsp?seq=<%=seq%>";
}
</script>
<link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://elvo.tistory.com/api?rsd" /><link rel="stylesheet" type="text/css" href="http://s1.daumcdn.net/cfs.tistory/v/111130102906/blog/style/menubar.css"/></head>
<body>
<center>
<h3>글 내용</h3>
<hr>

</table>
<br />
<input type="button" value="글목록" onclick="fn_goList()">
<input type="button" value="글수정" onclick="fn_goUpdateForm()">
<input type="button" value="글삭제" onclick="fn_goDelete()">

</center>
<script charset="utf-8" type="text/javascript" src="http://d1.daumcdn.net/tiara/tracker/tiara.min.js"></script>

__pageTracker.__setTitle("Heaven helps those who help themselves. :: 40일차: ibatis로 간단한 게시판 짜기");
	__pageTracker.__addParam("svcdomain","user.tistory.com");
	__pageTracker.__addParam("category","");
	__pageTracker.__addParam("articleno","96");
	__pageTracker.__addParam("date","2009-08-22 15:30:24");
	__pageTracker.__addParam("author","elvo");
	__pageTracker.__addParam("length ","13475");
	__pageTracker.__addParam("isauthor","N");
	__pageTracker.__addParam("ishidden","1");
	__pageTracker.__addParam("comments","0");
	__pageTracker.__addParam("param1","0");
	__pageTracker.__addParam("param2","e");
	__pageTracker.__addParam("param3","");

window.setTimeout("try { __pageTracker.__trackPageview(\"http://elvo.tistory.com/\"); } catch(e) {}", 1);
//]]>-->
</script></body>
</html>

insert_form.jsp

insert.jsp

list.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import = "com.mydomain.data.*" %>
<%@ page import = "java.util.*" %>
<%@ page import = "domain.*" %>
<%
	request.setCharacterEncoding("euc-kr");
	String searchKey = request.getParameter("searchKey");//검색어
	String areas[] = request.getParameterValues("area");//체크박스 값(title,contents)
		
	BoardDAO dao = new BoardDAO();
	List list = null;
	if(searchKey != null)	{
		SearchKey key = new SearchKey();
		key.setAreas(areas);
		key.setSearchKey("%"+searchKey+"%");
		list = dao.searchAllBoards2(key); //검색으로 list 구하기
	}else{
		list = dao.selectAllBoards(); //그냥 list 구하기
	}
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
<link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://elvo.tistory.com/api?rsd" /><link rel="stylesheet" type="text/css" href="http://s1.daumcdn.net/cfs.tistory/v/111130102906/blog/style/menubar.css"/></head>
<body>
<center>
<h3>글 목록</h3>
<hr>
	
	<a href="insert_form.jsp">글쓰기</a>

<form action="list.jsp" method="post">
		<input type="checkbox" name="area" value="title" checked="checked">제목
		<input type="checkbox" name="area" value="contents">내용
		<input name="searchKey" size="10">
		<input type="submit" value="검색">
	</form>
<table border="1">
	<tr>
		<td width="50">번호</td>
		<td width="150">제목</td>
		<td width="100">등록자</td>
		<td width="100">등록일</td>
	</tr>
	<%		
		for(int i=0; i<list.size();i++){
			Board b = (Board)list.get(i);
			out.println("<tr>
");
			out.println("<td>"+b.getSeq()+"</td>
");
			out.println("<td><a href='detail.jsp?seq="+b.getSeq()+"'>"
					+ b.getTitle() + "</a></td>
");
			
			out.println("<td>"+b.getWriter()+"</td>
");
			out.println("<td>"+b.getRegdate()+"</td>
");
			out.println("</tr>
");
		}	
	%>

</table>

</center>
<script charset="utf-8" type="text/javascript" src="http://d1.daumcdn.net/tiara/tracker/tiara.min.js"></script>

window.setTimeout("try { __pageTracker.__trackPageview(\"http://elvo.tistory.com/\"); } catch(e) {}", 1);
//]]>-->
</script></body>
</html>

update_form.jsp

update.jsp

tags : iBATIS, JSP, JSP / Servlet / Bean, 게시판, 프레임워크

Trackback 0 : Comment 0

◀ PREV : [1] : [2] : [3] : [4] : [5] : ... [91] : NEXT ▶

티스토리 툴바

Heaven helps those who help themselves.

40일차: ibatis로 간단한 게시판 짜기