소스파일 다운로드 :
scheduler4.vol1.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";
}
