OpenSource Framework

<?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="test">
  <typeAlias alias="Board" type="kr.co.hanbiteni.struts.board.vo.BoardVo"/>
 
  <resultMap id="ListBoardResult" class="Board">
    <result property="num" column="bnum" />
    <result property="writer" column="bwriter"/>
    <result property="title" column="btitle"/>
    <result property="fname" column="bfname"/>
    <result property="hit" column="bhit"/>
    <result property="writedate" column="bwritedate"/>
    <result property="level" column="blevel"/>
    <result property="rcnt" column="brcnt"/>   
  </resultMap> 
  <resultMap id="ViewBoardResult" class="Board">
    <result property="num" column="bnum" />
    <result property="writer" column="bwriter"/>
    <result property="title" column="btitle"/>
    <result property="content" column="bcontent"
      jdbcType="CLOB" javaType="java.lang.String" />
    <result property="pwd" column="bpwd"/>
    <result property="fname" column="bfname"/>
    <result property="hit" column="bhit"/>
    <result property="writedate" column="bwritedate"/>
    <result property="group" column="bgroup"/>
    <result property="step" column="bstep"/>
    <result property="level" column="blevel"/>
  </resultMap> 
 
  <select id="getRows" resultClass="int">
   select count(*) from board
  </select> 
  <select id="selectList" parameterClass="java.util.HashMap"
         resultMap="ListBoardResult">
 
   select bnum , bwriter, btitle, bfname ,
 bhit , to_char(bwritedate,'YYYY/MM/dd') bwritedate ,blevel,brcnt
 from (
 select bnum , bwriter, btitle, bfname ,
 bhit , bwritedate ,blevel,brcnt,rownum numb
 from (
 select bnum , bwriter, btitle, bfname , 
 bhit , bwritedate ,blevel,brcnt
 from board
 order by bgroup desc, bstep asc
 )
 )
 where numb between #start# and #end#
 
  </select>
  <update id="updateHit" parameterClass="int">
   update board set bhit = bhit+1 where bnum = #value#
  </update>
  <select id="selectView" parameterClass="int" resultMap="ViewBoardResult">
   select bnum, bwriter,btitle, bcontent,bpwd,bfname, bhit,
 to_char(bwritedate,'YYYY/MM/dd') bwritedate, bgroup,bstep,blevel
 from board
 where bnum = #value#
  </select>
  <update id="updateRcnt" parameterClass="int">
   update board set brcnt = brcnt + 1 where bnum = #value#
  </update>
 
  <select id="getNum" resultClass="int">
   select board_seq.nextval from dual
  </select>
 
 
  <update id="updateStep" parameterClass="java.util.HashMap">
   <![CDATA[
   update board set bstep = bstep + 1
   where bgroup = #originalGroup#  and bstep > #originalStep#
   ]]>
  </update>
  <insert id="saveBoard" parameterClass="Board">
   insert into board values(#num#,#writer#,#title#,#content:java.lang.String#,
   #pwd#,#fname#,0,sysdate,#group#,#step#,#level#,0) 
  </insert>
  <select id="getSearchRows" parameterClass="java.util.HashMap"
          resultClass="int">
   select count(*) from board
   <dynamic prepend="WHERE">   
  <isEqual prepend="AND" property="searchSort" compareValue="writer">
   bwriter like #searchWord#
  </isEqual>
  <isEqual prepend="AND" property="searchSort" compareValue="content">
   bcontent like #searchWord#
  </isEqual>
  <isEqual prepend="AND" property="searchSort" compareValue="title">
   btitle like #searchWord#
  </isEqual>
 </dynamic> 
  </select>
 
 
 
 
 
 
  <select id="selectSearch" parameterClass="java.util.HashMap"
  resultMap="ListBoardResult">
   select bnum , bwriter, btitle, bfname ,
 bhit , to_char(bwritedate,'YYYY/MM/dd') bwritedate ,blevel,brcnt
 from (
 select bnum , bwriter, btitle, bfname ,
 bhit , bwritedate ,blevel,brcnt,rownum numb
 from (
 select bnum , bwriter, btitle, bfname , 
 bhit , bwritedate ,blevel,brcnt
 from board
 <dynamic prepend="WHERE">   
  <isEqual prepend="AND" property="searchSort" compareValue="writer">
   bwriter like #searchWord#
  </isEqual>
  <isEqual prepend="AND" property="searchSort" compareValue="content">
   bcontent like #searchWord#
  </isEqual>
  <isEqual prepend="AND" property="searchSort" compareValue="title">
   btitle like #searchWord#
  </isEqual>
 </dynamic>
 order by bgroup desc, bstep asc
 )
 )
 where numb between #start# and #end#
  </select>
  <select id="isPwd" parameterClass="java.util.HashMap" resultClass="int">
   select count(*)
 from board
 where bnum = #num# and bpwd = #pwd#
  </select>
  <update id="updateBoard" parameterClass="Board">
   update board
 set bwriter = #writer# , btitle = #title#,
 bcontent = #content:java.lang.String#, bpwd=#pwd#,
 <dynamic>
  <isNotNull property="fname">
   bfname=#fname# ,
  </isNotNull>
 </dynamic>
 bwritedate = sysdate
 where bnum = #num#
  </update>
  <delete id="deleteBoard" parameterClass="java.lang.Integer" >
     { call del_board( #val# ) }
  </delete>

 
</sqlMap>

 

 

 

 

 

 

import java.util.Date;
import java.text.SimpleDateFormat;
import java.util.Locale;
//현재 시간을 미국식 날짜 표현 방법
Date d = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("EEE, d MMM yyyy HH:mm:ss Z",Locale.ENGLISH);
System.out.println(sdf.format(d));

//특정시간을 한국식으로 출력하는 방법
Date d1 = new Date("2009/12/31 09:30:52");
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String    pubDate = sdf1.format(d1);
System.out.println(pubDate);