9月25日微服务架构周二

最新推荐文章于 2024-12-22 01:41:17 发布

原创最新推荐文章于 2024-12-22 01:41:17 发布 · 126 阅读

0 ·

CC 4.0 BY-SA版权

2018 专栏收录该内容

337 篇文章

订阅专栏

本文详细解析了MyBatis映射文件的结构与使用方法，包括查询、插入、更新和删除操作的XML配置示例。通过具体案例，如店铺信息的增删改查及用户登录验证，展示了MyBatis在实际项目中的应用。

<?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.hao.mapper.IViewMapper">
	<select id="findShopList" resultType="com.hao.dto.Shop" parameterType="String">
		select * from t_shop0927 where name like concat(concat('%',#{mohu}),'%')
	</select>
	<insert id="add" parameterType="com.hao.dto.Shop">
		insert into t_shop0927 values(seq_t_shop0927.nextval,#{name},#{price},#{manname},#{manphone},#{saldate})
	</insert>
	
	<select id="getObj" parameterType="int" resultType="com.hao.dto.Shop">
		select * from t_shop0927 where id = #{id}
	</select>
	<update id="update" parameterType="com.hao.dto.Shop">
		update t_shop0927 set name = #{name},price = #{price},manname=#{manname},manphone=#{manphone},saldate=#{saldate} where id = #{id}
	</update>
	<delete id="del" parameterType="int">
		delete t_shop0927 where id = #{id}
	</delete>
	<select id="getSum" resultType="int">
		select sum(price) from t_shop0927
	</select>
	<select id="getData" resultType="map">
		select name,sum(price) sum from t_shop0927 group by name
	</select>
</mapper>

<?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.hao.mapper.IUserMapper">
	<select id="login" parameterType="com.hao.dto.User" resultType="com.hao.dto.User">
		select * from t_user0925 where username = #{username} and userpwd = #{userpwd}
	</select>
	<select id="findMenuList" parameterType="int" resultType="com.hao.dto.Menu">
		select m.id,m.pid,m.name,m.url,m.target from t_user0925 u 
       left join t_ur0925 ur on u.id = ur.userid
       left join t_role0925 r on ur.roleid = r.roleid
       left join t_rm0925 rm on r.roleid = rm.roleid
       left join t_menu0925 m on rm.menuid = m.id
       where u.id =  #{u.id}
	</select>
</mapper>

"世界上该做的事情何其之多，而一个人能做成的事情何其之少"。
《美国常春藤上的中国蜗牛》

——爱岑