소스파일 다운로드 :

 scheduler4.vol1.egg

 scheduler4.vol2.egg

압축파일 비밀번호 : http://blog.naver.com/1xx707xx1/220722393843

Oracle 버전을 필요로 하시는 분들이 많아 Oracle 버전으로 만들어봤습니다.

수정사항 :

[query]

CREATE TABLE EVENTS (

EVENT_ID NUMBER(11) NOT NULL,

EVENT_NAME VARCHAR2(127),

START_DATE DATE NOT NULL,

END_DATE DATE NOT NULL,

PRIMARY KEY (EVENT_ID)

);

CREATE SEQUENCE SEQ_EVENTS

START WITH 1

MINVALUE 0

MAXVALUE 9223372036854775806;

INSERT INTO events VALUES (SEQ_EVENTS.NEXTVAL, 'Event from db #1', 

TO_DATE('2016-12-24 05:00:00', 'YYYY-MM-DD HH24:MI:SS'), 

TO_DATE('2016-12-25 09:00:00', 'YYYY-MM-DD HH24:MI:SS'));

[DB properties]

jdbc.driver=oracle.jdbc.driver.OracleDriver

jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl

jdbc.username=test

jdbc.password=1234567

[Ibatis sqlMap]

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

<!DOCTYPE sqlMap

    PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"

    "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="scheduler">

 <typeAlias alias="scheduler" type="com.scheduler.SchedulerVO" />

 <resultMap id="scheduler" class="scheduler">

  <result property="event_id" column="event_id"/>

  <result property="event_name" column="event_name"/>

  <result property="start_date" column="start_date"/>

  <result property="end_date" column="end_date"/>

 </resultMap>

 <select id="getEvent" resultMap="scheduler"> 

  SELECT event_id, event_name, start_date, end_date FROM events

 </select>

 <update id="updateEvent" parameterClass="scheduler"> 

  UPDATE 

  events 

  SET 

  event_name=#event_name#, 

  start_date=TO_DATE(#start_date#, 'YYYY-MM-DD HH24:MI:SS'),

  end_date=TO_DATE(#end_date#, 'YYYY-MM-DD HH24:MI:SS')

  WHERE 

  event_id=#event_id#

 </update>

 <insert id="insertEvent" parameterClass="scheduler">

  INSERT INTO 

  events (event_id, event_name, start_date, end_date) 

  VALUES (

  SEQ_EVENTS.NEXTVAL,

  #event_name#,

  TO_DATE(#start_date#, 'YYYY-MM-DD HH24:MI:SS'),

  TO_DATE(#end_date#, 'YYYY-MM-DD HH24:MI:SS')

  )

    <selectKey keyProperty="event_id" resultClass="Integer">

  SELECT SEQ_EVENTS.NEXTVAL FROM dual

  </selectKey>

 </insert>

  <delete id="deleteEvent" parameterClass="int">

   DELETE FROM events WHERE event_id=#event_id#

  </delete>

</sqlMap>

[Controller]

   @RequestMapping("/scheduler")

   public String scheduler(ModelMap model, HttpServletRequest request) throws Exception {

   DHXPlanner planner = new DHXPlanner("./codebase/", DHXSkin.TERRACE);

   planner.localizations.set("cr");

   planner.setWidth(900);

   planner.setInitialView("month");

   planner.config.setTimeStep(60);

   planner.config.setEventDuration(60);

   planner.config.setAutoEndDate(true);

   planner.config.setFirstHour(9);

   planner.config.setLastHour(19);

   planner.config.setStartOnMonday(false);

   planner.config.setMonthDate("%Y년 %M월");

   planner.config.setDefaultDate("%Y년 %M월 %j일");

   planner.config.setDayDate("%D");

   planner.data.dataprocessor.setURL("events.do");

   planner.parse(schedulerService.getEvent());

   model.addAttribute("schedule", planner.render());

      return "scheduler";

   }