<?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.bwie.dao.IWalletDao">
<!-- private int id;
private int uid;
private String userName;
private int version;
private Date createTime;
private double money;-->
<update id="modifyMoney" parameterType="Map" >
update tb_wallet set money =money +#{money} ,version =1+#{version}
where uid=#{uid} and version=#{version}
</update>
<select id="findWalletByUid" parameterType="int" resultType="wallet">
select * from tb_wallet where uid=#{uid}
</select>
</mapper>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bwie.dao.IWalletDao">
<!-- private int id;
private int uid;
private String userName;
private int version;
private Date createTime;
private double money;-->
<update id="modifyMoney" parameterType="Map" >
update tb_wallet set money =money +#{money} ,version =1+#{version}
where uid=#{uid} and version=#{version}
</update>
<select id="findWalletByUid" parameterType="int" resultType="wallet">
select * from tb_wallet where uid=#{uid}
</select>
</mapper>
本文介绍了一个基于MyBatis实现的钱包模块更新与查询功能。具体包括使用XML映射文件定义SQL语句,实现钱包余额的更新及通过用户ID查询钱包详情的功能。
765

被折叠的 条评论
为什么被折叠?



