Mybatis.xml模板

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

<!-- 获取所有的部门信息-->
<insert id="insertOrganzie" parameterType="com.test.bank.pojo.Organize">
  insert into tbl_scctn_organzie (ORGID,ORGCODE,ORGNAME,ORGTYPE,ORGADDR,PARENTORGID,STARTDATE,ENDDATE,STATUS,SORTNO,
  CREATETIME,LASTUPDATE,OPERTYPE,EHRID,ORGLEVEL,ORGSEQ,ZIPCODE,LINKTEL,WEBURL,AREA,FAXNO,CMSID,ISLEAF,SUBCOUNT,DUTIES)
  values (#{organize.ORGID},#{organize.ORGCODE},#{organize.ORGNAME},#{organize.ORGTYPE},#{organize.ORGADDR},#{organize.PARENTORGID},#{organize.STARTDATE},#{organize.ENDDATE},#{organize.STATUS},#{organize.SORTNO},
  #{organize.CREATETIME},#{organize.LASTUPDATE},#{organize.OPERTYPE},#{organize.EHRID},#{organize.ORGLEVEL},#{organize.ORGSEQ},#{organize.ZIPCODE},#{organize.LINKTEL},#{organize.WEBURL},#{organize.AREA},#{organize.FAXNO},#{organize.CMSID},#{organize.ISLEAF},#{organize.SUBCOUNT},#{organize.DUTIES});

<!-- 获取所有的部门信息-->
<insert id="insertOrganzie1" parameterType="com.test.bank.pojo.Organize">
  insert into tbl_scctn_organzie1 (ORGID,ORGCODE,ORGNAME,ORGTYPE,ORGADDR,PARENTORGID,STARTDATE,ENDDATE,STATUS,SORTNO,
  CREATETIME,LASTUPDATE,OPERTYPE,EHRID,ORGLEVEL,ORGSEQ,ZIPCODE,LINKTEL,WEBURL,AREA,FAXNO,CMSID,ISLEAF,SUBCOUNT,DUTIES)
  values (#{organize.ORGID},#{organize.ORGCODE},#{organize.ORGNAME},#{organize.ORGTYPE},#{organize.ORGADDR},#{organize.PARENTORGID},#{organize.STARTDATE},#{organize.ENDDATE},#{organize.STATUS},#{organize.SORTNO},
  #{organize.CREATETIME},#{organize.LASTUPDATE},#{organize.OPERTYPE},#{organize.EHRID},#{organize.ORGLEVEL},#{organize.ORGSEQ},#{organize.ZIPCODE},#{organize.LINKTEL},#{organize.WEBURL},#{organize.AREA},#{organize.FAXNO},#{organize.CMSID},#{organize.ISLEAF},#{organize.SUBCOUNT},#{organize.DUTIES});

select STATUS,ORGID,OPERTYPE from tbl_scctn_organzie; update tbl_scctn_organzie set STATUS=#{organize.STATUS},OPERTYPE=#{organize.OPERTYPE} where ORGID=#{organize.ORGID}; insert into tbl_scctn_user (EMPID,USERID,EMPCODE,EMPNAME,GENDER,EMPSTATUS,OTEL,OEMAIL,PEMAIL,MOBILENO,DEGREE,EMPTYPE,EHRID,ORGID,CREATETIME, LASTMODYTIME,OPERTYPE,REMARK,SORTNO,DEPTORGID,FAXNO,OPERTEL,DTEL,BRANCH,MSN,QQ,FAVOR,GOODAT,IMAGE,CMSID,BRANCHORGID,LASTMODYTIME2,ZEST,GOODA,JOBTITLES,HRCONF,MAJOR) values (#{user.EMPID},#{user.USERID},#{user.EMPCODE},#{user.EMPNAME},#{user.GENDER},#{user.EMPSTATUS},#{user.OTEL},#{user.OEMAIL},#{user.PEMAIL},#{user.MOBILENO},#{user.DEGREE},#{user.EMPTYPE},#{user.EHRID},#{user.ORGID},#{user.CREATETIME}, #{user.LASTMODYTIME},#{user.OPERTYPE},#{user.REMARK},#{user.SORTNO},#{user.DEPTORGID},#{user.FAXNO},#{user.OPERTEL},#{user.DTEL},#{user.BRANCH},#{user.MSN},#{user.QQ},#{user.FAVOR},#{user.GOODAT},#{user.IMAGE},#{user.CMSID},#{user.BRANCHORGID},#{user.LASTMODYTIME2},#{user.ZEST},#{user.GOODA},#{user.JOBTITLES},#{user.HRCONF},#{user.MAJOR}); select EMPSTATUS,EMPID,OPERTYPE from tbl_scctn_user; update tbl_scctn_user set OPERTYPE=#{user.OPERTYPE},EMPSTATUS=#{user.EMPSTATUS} where EMPID=#{user.EMPID}; insert into tbl_scctn_degree (ORGID,EMPID,ISMAIN,DEPTORGID,DEGREE) values (#{degree.ORGID},#{degree.EMPID},#{degree.ISMAIN},#{degree.DEPTORGID},#{degree.DEGREE}); select EMPID,ORGID,DEPTORGID from tbl_scctn_degree; update tbl_scctn_degree set OPERTYPE=#{user.OPERTYPE},EMPSTATUS=#{user.EMPSTATUS} where EMPID=#{user.EMPID};

<!-- 获取所有的字典明细信息-->
<insert id="insertDictEntry" parameterType="com.test.bank.pojo.DictEntry">
  insert into tbl_scctn_entry (DICTTYPEID,DICTID,DICTNAME,STATUS,SORTNO,RANK,SEQNO,PARENTID)
  values (#{dictEntry.DICTTYPEID},#{dictEntry.DICTID},#{dictEntry.DICTNAME},#{dictEntry.STATUS},#{dictEntry.SORTNO},#{dictEntry.RANK},#{dictEntry.SEQNO},#{dictEntry.PARENTID});

<!-- 查询字典明细信息-->
<select id="selectDictEntry" resultType="com.test.bank.pojo.DictEntry">
    select DICTTYPEID,DICTID  from tbl_scctn_entry;

<!-- 获取所有的字典主信息-->
<insert id="insertDictType" parameterType="com.test.bank.pojo.DictType">
  insert into tbl_scctn_type (DICTTYPEID,DICTTYPENAME,RANK,SEQNO,PARENTID)
  values (#{dictType.DICTTYPEID},#{dictType.DICTTYPENAME},#{dictType.RANK},#{dictType.SEQNO},#{dictType.PARENTID});

<!-- 查询字典主信息-->
<select id="selectDictType" resultType="com.test.bank.pojo.DictType">
    select DICTTYPEID  from tbl_scctn_type;

<!-- 获取所有的人员汇报链信息-->
<insert id="insertRelation" parameterType="com.test.bank.pojo.Relation">
  insert into tbl_scctn_relation (EMPCODE,DIRECTLEADER )
  values (#{relation.EMPCODE},#{relation.DIRECTLEADER});

<!-- 查询人员汇报链信息-->
<select id="selectRelation" resultType="com.test.bank.pojo.Relation">
    select EMPCODE  from tbl_scctn_relation;

insert into tbl_scctn_opprove (ID,ORGID,ORGNAME,USERID,USERCODE,USERNAME,FLAG) values (#{opprove.ID},#{opprove.ORGID},#{opprove.ORGNAME},#{opprove.USERID},#{opprove.USERCODE},#{opprove.USERNAME},#{opprove.FLAG});

<!-- 查询人员审批信息-->
<select id="selectOpprove" resultType="com.test.bank.pojo.Opprove">
    select ID   from tbl_scctn_opprove;

insert into tbl_scctn_check (createTime,tableName,status,id) values (#{check.createTime},#{check.tableName},#{check.status},#{check.id});

<!-- 更改辅助信息-->
<update id="updateCheck" parameterType="com.test.bank.pojo.Check">
  update tbl_scctn_check set status=#{check.status} where id=#{check.id};