自动构建-IbatisSql

最新推荐文章于 2024-10-10 10:49:27 发布

a1000005aa

最新推荐文章于 2024-10-10 10:49:27 发布

阅读量84

点赞数

分类专栏：自动构建文章标签：操作系统数据库

本文链接：https://blog.csdn.net/a1000005aa/article/details/84168118

版权

自动构建专栏收录该内容

7 篇文章 0 订阅

订阅专栏


<?xml version="1.0" encoding="UTF-8"?>
<schema>
	<tables>
		<table name="user" key="id" desc="用户">
			<columns>
				<column name="id" type="Long" desc="用户id"/>
				<column name="name" type="String" desc="用户名称"/>
				<column name="gender" type="String" desc="用户性别"/>
				<column name="email" type="String" desc="用户Email"/>
			</columns>
		</table> 
		<table name="role" key="rid" desc="角色">
			<columns>
				<column name="rid" type="Long" desc="角色rid"/>
				<column name="name" type="String" desc="角色名称"/>
				<column name="level" type="String" desc="角色级别"/> 
				<!-- 简单的权限控制 -->
			</columns>
		</table> 
	</tables>
</schema>


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap
        PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
        "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="user">
    <typeAlias alias="user" type="org.ycl.base.dos.UserDO"/>

    <resultMap id="userResult" class="user">
		<result column="id" property="id"/>
		<result column="name" property="name"/>
		<result column="gender" property="gender"/>
		<result column="email" property="email"/>
    </resultMap>

	<!-- 数据库表字段 -->
	<sql id="user_columns.all"> 
		id
		,name
		,gender
		,email
	</sql>

    <select id="UserIbatisDAO.queryUser" resultMap="userResult" parameterClass="long">
        SELECT 
			<include refid="user_columns.all"/>
        FROM 
			user
        WHERE 
			id = #id#
    </select>

    <update id="UserIbatisDAO.updateUser" parameterClass="user">
        UPDATE 
			user
        SET 
			<isNotNull prepend="" property="id">id = #id#</isNotNull>
    		<isNotNull prepend="," property="name">name = #name#</isNotNull>
    		<isNotNull prepend="," property="gender">gender = #gender#</isNotNull>
    		<isNotNull prepend="," property="email">email = #email#</isNotNull>
        WHERE 
			id = #id#
    </update>

    <insert id="UserIbatisDAO.insertUser" parameterClass="user">
        INSERT INTO user(
			<include refid="user_columns.all"/>
        ) VALUES (
    		#id#
    		,#name#
    		,#gender#
    		,#email#
        )
        <selectKey resultClass="long" keyProperty="id" >
    		SELECT @@IDENTITY AS id
    	</selectKey>
    </insert>

</sqlMap>