<?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="PlanExe"> <typeAlias alias="PlanExe" type="zhmt.keeper.model.PlanExe"/> <select id="PlanExe.getPlanExeById" resultClass="PlanExe" parameterClass="int"> SELECT id AS id, plan_id AS planId, title AS title, body AS body, create_time AS createTime, last_modify_time AS lastModifyTime FROM plan_exe WHERE id=#id#; </select> <insert id="PlanExe.insert" parameterClass="PlanExe"> INSERT INTO plan_exe (id,plan_id,title,body,create_time,last_modify_time) VALUES (#id#,#planId#,#title#,#body#,#createTime#,#lastModifyTime#) ; </insert> <update id="PlanExe.update" parameterClass="PlanExe"> UPDATE plan_exe SET id=#id#, plan_id=#planId#, title=#title#, body=#body#, create_time=#createTime#, last_modify_time=#lastModifyTime# WHERE id = #id# ; </update> </sqlMap>