读书人
栏目▼

求ibatis映射文件在java语言中标准格式

发布时间： 2012-01-10 21:26:50 作者： rapoo

求ibatis映射文件在java语言中标准格式？
ibatis框架在.net和java语言中的不同点？

在CodeSmith中生成的.net的ibatis的xml映射的代码为：
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap
namespace="VUser" xmlns="http://ibatis.apache.org/mapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >

<alias>
<typeAlias alias="VUser" type="USER.VUser, USER" />
</alias>

<resultMaps>
<resultMap id="SelectResult" class="VUser">
<result property="ID" column="ID" />
<result property="USERNAME" column="USERNAME" />
<result property="PASSWORD" column="PASSWORD" />
</resultMap>
</resultMaps>

<statements>

<select id="SelectAll" resultMap="SelectResult">
<![CDATA[
select
ID,
USERNAME,
PASSWORD
from V_USER
]]>
</select>

<select id="SelectById" extends="SelectAll" parameterClass="" resultMap="SelectResult">
<![CDATA[
where
1 = 1
]]>
</select>

<select id="SelectByParam" extends="SelectAll" parameterClass="VUser" resultMap="SelectResult">
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
<![CDATA[ ID = #ID# ]]>
</isNotNull>
<isNotEmpty prepend="AND" property="USERNAME">
<![CDATA[ USERNAME = #USERNAME# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="PASSWORD">
<![CDATA[ PASSWORD = #PASSWORD# ]]>
</isNotEmpty>
</dynamic>
</select>

<select id="SelectForPageing" extends="SelectAll" parameterClass="System.Collections.IDictionary">
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="ID">
<![CDATA[ ID = #ID# ]]>
</isNotNull>
<isNotNull prepend="AND" property="USERNAME">
<![CDATA[ USERNAME = #USERNAME# ]]>
</isNotNull>
<isNotNull prepend="AND" property="PASSWORD">
<![CDATA[ PASSWORD = #PASSWORD# ]]>
</isNotNull>
</dynamic>
</select>
<insert id="Insert" parameterClass="VUser">
<![CDATA[
insert into V_USER
(
ID,
USERNAME,
PASSWORD
)
values
(
#ID#,
#USERNAME#,
#PASSWORD#
)
]]>
</insert>
<update id="Update" parameterClass="VUser" >
<![CDATA[
update V_USER set
ID = #ID#,
USERNAME = #USERNAME#,
PASSWORD = #PASSWORD#
where
1=1
]]>
</update>
<delete id="Delete" parameterClass="VUser" >
<![CDATA[
delete from V_USER
where
1=1
]]>
</delete>
</statements>

</sqlMap>

但是这些代码复制到java中就不行了
请问ibatis的映射xml文件在java中标准格式是什么样子的？
谁能给我一个完整的实例？
谢谢

[解决办法]

XML code
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "/conf/dtd/sql-map-2.dtd"><sqlMap namespace="com.devtek.sys.pb.pojo.Pblog_ipmodify">    <typeAlias alias="Pblog_ipmodify"        type="com.devtek.sys.pb.pojo.Pblog_ipmodify" />    <resultMap id="Pblog_ipmodifyResult" class="Pblog_ipmodify">        <result column="id" property="id" javaType="java.lang.Integer"            jdbcType="int" nullValue="0" />        <result column="service_code" property="service_code"            javaType="java.lang.String" jdbcType="varchar" />                <result column="original_ip" property="original_ip"            javaType="java.lang.String" jdbcType="varchar" />        <result column="modify_ip" property="modify_ip"            javaType="java.lang.String" jdbcType="varchar" />        <result column="modify_time" property="modify_time" />            </resultMap>    <resultMap id="Pblog_iprs" class="Pblog_ipmodify">        <result column="id" property="id" javaType="java.lang.Integer"            jdbcType="int" nullValue="0" />        <result column="service_code" property="service_code"            javaType="java.lang.String" jdbcType="varchar" />        <result column="service_name" property="service_name"            javaType="java.lang.String" jdbcType="varchar" />            <result column="modify_ip" property="modify_ip"            javaType="java.lang.String" jdbcType="varchar" />            <result column="original_ip" property="original_ip"            javaType="java.lang.String" jdbcType="varchar" />        <result column="modify_time" property="modify_time" javaType="java.lang.String" jdbcType="varchar" />        <result column="cbs" property="countByServiceCode"            javaType="java.lang.String" jdbcType="int" />    </resultMap>    <resultMap id="getipModifyDetil" class="Pblog_ipmodify">        <result column="id" property="id" javaType="java.lang.Integer"            jdbcType="int" nullValue="0" />        <result column="original_ip" property="original_ip"            javaType="java.lang.String" jdbcType="varchar" />        <result column="modify_time" property="modify_time"            javaType="java.lang.String" jdbcType="varchar" />        <result column="modify_ip" property="modify_ip"            javaType="java.lang.String" jdbcType="varchar" />    </resultMap>    <sql id="where">        <dynamic prepend="where">            <isNotNull property="id">                <isGreaterEqual prepend="and" property="id"                    compareValue="0">                    id = #id:int#                </isGreaterEqual>            </isNotNull>            <isNotNull property="service_code">                <isNotEmpty prepend="and" property="service_code">                    service_code = #service_code:varchar#                </isNotEmpty>            </isNotNull>            <isNotNull property="original_ip">                <isNotEmpty prepend="and" property="original_ip">                    original_ip = #original_ip:varchar#                </isNotEmpty>            </isNotNull>            <isNotNull property="modify_ip">                <isNotEmpty prepend="and" property="modify_ip">                    modify_ip = #modify_ip:varchar#                </isNotEmpty>            </isNotNull>            <isNotNull property="modify_time">                <isNotEmpty prepend="and" property="modify_time">                    modify_time = #modify_time:datetime#                </isNotEmpty>            </isNotNull>            <isNotNull property="service_name">                <isNotEmpty prepend="and" property="service_name">                    a.service_name = #service_name:varchar#                </isNotEmpty>            </isNotNull>            <isNotNull property="start_time">                <isNotEmpty prepend="and" property="start_time">                    to_date(a.modify_time,'yyyy-MM-dd hh24:mi:ss') >= to_date('$start_time$ 00:00:00','yyyy-MM-dd hh24:mi:ss')                </isNotEmpty>            </isNotNull>            <isNotNull property="end_time">                <isNotEmpty prepend="and" property="end_time">                <![CDATA[     to_date(a.modify_time,'yyyy-MM-dd hh24:mi:ss') <= to_date('$end_time$ 23:59:59','yyyy-MM-dd hh24:mi:ss')]]>                </isNotEmpty>            </isNotNull>        </dynamic>    </sql>    <sql id="whereByLike">        <dynamic prepend="where">            <isNotNull prepend="and" property="service_code">                service_code like '%$service_code$%'            </isNotNull>            <isNotNull prepend="and" property="original_ip">                original_ip like '%$original_ip$%'            </isNotNull>            <isNotNull prepend="and" property="modify_ip">                modify_ip like '%$modify_ip$%'            </isNotNull>        </dynamic>    </sql>    <select id="select" resultMap="Pblog_iprs"        parameterClass="Pblog_ipmodify">        select * from (select        a.service_code,pi.service_name,b.modify_ip,b.original_ip,a.modify_time,a.cbs, b.id        from(select p.service_code,count(*) cbs,max(p.modify_time)        modify_time from pblog_ipmodify p where 1=1 group by p.service_code) a        left join pblog_ipmodify b on b.service_code=a.service_code and        a.modify_time=b.modify_time left join pb_isbnlist pi on        pi.service_code=a.service_code) a        <include refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.where" />    </select>    <select id="getIpModifyDetilByService" resultMap="getipModifyDetil"        parameterClass="Pblog_ipmodify">        select id,modify_ip,original_ip,modify_time from pblog_ipmodify        <include refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.where" />    </select>    <select id="selectCount" resultClass="int"        parameterClass="Pblog_ipmodify">        select count(*) from (select a.service_code,                       pi.service_name,                       b.modify_ip,                      b.original_ip,                       a.modify_time,                       a.cbs                  from (select p.service_code,                               count(*) cbs,                               max(p.modify_time) modify_time                          from pblog_ipmodify p                                               group by p.service_code) a                  left join pblog_ipmodify b on b.service_code =                                                a.service_code                                            and a.modify_time = b.modify_time                  left join pb_isbnlist pi on pi.service_code =                                              a.service_code ) a        <include refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.where" />    </select>    <select id="selectByLike" resultMap="Pblog_ipmodifyResult"        parameterClass="Pblog_ipmodify">        select * from pblog_ipmodify        <include            refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.whereByLike" />    </select>    <select id="selectByMap" resultMap="Pblog_ipmodifyResult"        parameterClass="java.util.Map">        select * from pblog_ipmodify    </select>    <select id="findLikeByMap" resultMap="Pblog_ipmodifyResult"        parameterClass="java.util.Map">        select * from pblog_ipmodify        <include            refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.whereByLike" />    </select>    <select id="findByMap" resultMap="Pblog_ipmodifyResult"        parameterClass="java.util.Map">        select * from pblog_ipmodify        <include refid="com.devtek.sys.pb.pojo.Pblog_ipmodify.where" />    </select>    </sqlMap> 
 
[解决办法]
贴的内容有限 网上有生产工具 你去找个
[解决办法]
<?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="MeatOutInfoBase">

<typeAlias alias="MeatOutInfoBase" type="com.sunraw.kunming.model.MeatOutInfoBase" />

<resultMap id="SelectResult" class="MeatOutInfoBase">
<result property="tranId" column="TRAN_ID" />
<result property="butcherFacId" column="BUTCHER_FAC_ID" />
<result property="butcherFacName" column="BUTCHER_FAC_NAME" />
<result property="transantionDate" column="TRANSANTION_DATE" />
<result property="sellerId" column="SELLER_ID" />
<result property="sellerName" column="SELLER_NAME" />
<result property="buyerId" column="BUYER_ID" />
<result property="buyerName" column="BUYER_NAME" />
<result property="dest" column="DEST" />
<result property="sendState" column="SEND_STATE" />
<result property="sendFailReson" column="SEND_FAIL_RESON" />
<result property="sendDate" column="SEND_DATE" />
</resultMap>

<select id="selectSQL" resultMap="SelectResult">
select
TRAN_ID,
BUTCHER_FAC_ID,
BUTCHER_FAC_NAME,
TRANSANTION_DATE,
SELLER_ID,
SELLER_NAME,
BUYER_ID,
BUYER_NAME,
DEST,
SEND_STATE,
SEND_FAIL_RESON,
SEND_DATE
from MEAT_OUT_INFO_BASE
</select>

<select id="selectPkSQL" parameterClass="string" resultMap="SelectResult">
select * from MEAT_OUT_INFO_BASE
where
TRAN_ID = #value#
</select>

<select id="selectListByPkSQL" parameterClass="java.lang.String"
resultMap="SelectResult">
select * from MEAT_OUT_INFO_BASE
where TRAN_ID like
'%'||#value#||'%'  and SEND_STATE is null and rownum<10 
</select>

<select id="selectParamSQL" parameterClass="MeatOutInfoBase"
resultMap="SelectResult">
select * from MEAT_OUT_INFO_BASE
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="tranId">
       <![CDATA[ TRAN_ID = #tranId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="butcherFacId">
       <![CDATA[ BUTCHER_FAC_ID = #butcherFacId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="butcherFacName">
       <![CDATA[ BUTCHER_FAC_NAME = #butcherFacName# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sellerId">
       <![CDATA[ SELLER_ID = #sellerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sellerName">
       <![CDATA[ SELLER_NAME = #sellerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="buyerId">
       <![CDATA[ BUYER_ID = #buyerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="buyerName">
       <![CDATA[ BUYER_NAME = #buyerName# ]]> 
 
</isNotEmpty>
<isNotEmpty prepend="AND" property="dest">
       <![CDATA[ DEST = #dest# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendState">
       <![CDATA[ SEND_STATE = #sendState# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendFailReson">
       <![CDATA[ SEND_FAIL_RESON = #sendFailReson# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendDate">
       <![CDATA[ SEND_DATE = #sendDate# ]]>
</isNotEmpty>
</dynamic>
</select>

<select id="selectByMapSQL" parameterClass="java.util.Map">
select * from MEAT_OUT_INFO_BASE
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="tranId">
       <![CDATA[ TRAN_ID = #tranId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="butcherFacId">
       <![CDATA[ BUTCHER_FAC_ID = #butcherFacId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="butcherFacName">
       <![CDATA[ BUTCHER_FAC_NAME = #butcherFacName# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sellerId">
       <![CDATA[ SELLER_ID = #sellerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sellerName">
       <![CDATA[ SELLER_NAME = #sellerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="buyerId">
       <![CDATA[ BUYER_ID = #buyerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="buyerName">
       <![CDATA[ BUYER_NAME = #buyerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="dest">
       <![CDATA[ DEST = #dest# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendState">
       <![CDATA[ SEND_STATE = #sendState# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendFailReson">
       <![CDATA[ SEND_FAIL_RESON = #sendFailReson# ]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="sendDate">
       <![CDATA[ SEND_DATE = #sendDate# ]]>
</isNotEmpty>
</dynamic>
</select>
<insert id="insertSQL" parameterClass="MeatOutInfoBase">
insert into MEAT_OUT_INFO_BASE
(
TRAN_ID,
BUTCHER_FAC_ID,
BUTCHER_FAC_NAME,
TRANSANTION_DATE,
SELLER_ID,
SELLER_NAME,
BUYER_ID,
BUYER_NAME,
DEST,
SEND_STATE,
SEND_FAIL_RESON,
SEND_DATE
)
values
(
#tranId#,
#butcherFacId#,
#butcherFacName#,
#transantionDate#,
#sellerId#,
#sellerName#,
#buyerId#,
#buyerName#,
#dest#,
#sendState#,
#sendFailReson#,
#sendDate#
)
</insert>
<update id="updateSQL" parameterClass="MeatOutInfoBase">
update MEAT_OUT_INFO_BASE
set
BUTCHER_FAC_ID = #butcherFacId#,
BUTCHER_FAC_NAME =#butcherFacName#,
TRANSANTION_DATE = #transantionDate#,
SELLER_ID =#sellerId#,
SELLER_NAME = #sellerName#,
BUYER_ID = #buyerId#,
BUYER_NAME= #buyerName#,
DEST = #dest#,
SEND_STATE = #sendState#,
SEND_FAIL_RESON =#sendFailReson#,
SEND_DATE=#sendDate#,
where
TRAN_ID = #tranId#
</update> 
 
<update id="updateByMapSQL" parameterClass="java.util.Map">
update MEAT_OUT_INFO_BASE set SEND_STATE ='0' where TRAN_ID ='1001'
<dynamic prepend="set">
<isNotEmpty prepend="," property="butcherFacId">
       <![CDATA[ BUTCHER_FAC_ID = #butcherFacId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="butcherFacName">
       <![CDATA[ BUTCHER_FAC_NAME = #butcherFacName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerId">
       <![CDATA[ SELLER_ID = #sellerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerName">
       <![CDATA[ SELLER_NAME = #sellerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerId">
       <![CDATA[ BUYER_ID = #buyerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerName">
       <![CDATA[ BUYER_NAME = #buyerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="dest">
       <![CDATA[ DEST = #dest# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendState">
       <![CDATA[ SEND_STATE = #sendState# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendFailReson">
       <![CDATA[ SEND_FAIL_RESON = #sendFailReson# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendDate">
       <![CDATA[ SEND_DATE = #sendDate# ]]>
</isNotEmpty>
</dynamic>
<dynamic prepend="where">
<isNotEmpty prepend="AND" property="tranId">
       <![CDATA[ TRAN_ID = #tranId# ]]>
</isNotEmpty>
</dynamic>
</update>
<update id="updateState" parameterClass="MeatOutInfoBase">
update MEAT_OUT_INFO_BASE
set SEND_STATE =#sendState#,
SEND_FAIL_RESON=#sendFailReson#,
SEND_DATE = #sendDate#
where TRAN_ID = #tranId#
</update>
<delete id="deleteSQL" parameterClass="MeatOutInfoBase">
delete from
MEAT_OUT_INFO_BASE
where
TRAN_ID = #tranId#
</delete>

</sqlMap>
读书人网 >J2ME开发

热点推荐

触屏版 | 电脑版

读书人网 m.reader8.net