MyBatis入门实例 ——Mapper.xml
来源:互联网 发布:web服务器软件下载 编辑:程序博客网 时间:2024/05/16 09:56
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com...persistence.usermanager.UserMapper">
<!-- 要对应到所有属性 才能使用-->
<!--<resultMap id="users" type="User">
<result property="userName" column="user_name"/>
</resultMap>-->
<!-- 这里namespace必须是UserMapper接口的路径,不然要运行的时候要报错 "is not known to the MapperRegistry" -->
<insert id="createUser" parameterType="User">
<![CDATA[ insert into
user_info (user_id, user_name, user_password,
user_email,user_role) values (#{userId},#{userName}
,#{userPassword},#{userEmail},#{userRole})]]>
<!-- 这里sql结尾不能加分号,否则报"ORA-00911"的错误 -->
</insert>
<!-- 这里的id必须和UserMapper接口中的接口方法名相同,不然运行的时候也要报错 -->
<delete id="deleteUser" parameterType="java.lang.String">
<![CDATA[ delete from user_info where id = #{id} ]]>
</delete>
<update id="updateUsers" parameterType="User">
<![CDATA[update user_info set
user_name = #{userName},
user_password = #{userPassword},
user_email = #{userEmail},
user_role = #{userRole}
where user_id = #{userId} ]]>
</update>
<select id="selectAllUsers" resultType="User">
<![CDATA[select * from user_info ]]>
</select>
<select id="selectUserById" resultType="User" parameterType="java.lang.String">
<![CDATA[select * from user_info where user_id = #{userId}]]>
</select>
<select id="selectUsers" resultType="User" parameterType="User">
<![CDATA[select * from user_info ]]>
<where>
<if test="userName!=null">
<![CDATA[And user_name like '%'||#{userName}||'%']]>
</if>
<if test="userRole!=null">
<![CDATA[And user_role like '%'||#{userRole}||'%']]>
</if>
</where>
</select>
<select id="selectUsersCount" resultType="int">
<![CDATA[select count(*) from user_info ]]>
</select>
<select id="selectUserByName" resultType="User" parameterType="java.lang.String">
<![CDATA[select * from user_info where user_name = #{userName}]]>
</select>
</mapper>
- MyBatis入门实例 ——Mapper.xml
- MyBatis入门实例 ——configuration.xml
- MyBatis入门实例 ——configuration.xml 分类: MyBatis
- 博为峰JavaEE技术文章 ——MyBatis Mapper XML
- Mybatis学习教程—— mapper.xml文件详解
- mybatis Mapper.xml 详解
- mybatis mapper.xml
- Mybatis(五)-Mapper.xml
- mybatis:Mapper XML Files
- Mybatis-mapper-xml-基础
- mybatis mapper.xml详解
- mybatis and mapper.xml
- mybatis的mapper XML
- MyBatis mapper.xml 详解
- MyBatis mapper.xml配置文件
- mybatis mapper.xml详解
- mybatis入门——mybatis使用实例
- mybatis入门——实例
- 基于 Android NDK 的学习之旅----- C调用Java
- Abstract factory
- Builder
- Windows内核开发调试环境配置详解
- JS如何获取明细表的的某个控件值
- MyBatis入门实例 ——Mapper.xml
- google+ 邀请
- Factory Methods
- [Freescale MPC]同步指令eieio、isync、sync简介
- Unix命令参考
- DirectShow系统初级指南
- 两个程序的进程间通信小结
- usePhasedInstantiation = false
- Struts常见错误的全面汇总