Mybatis

最新推荐文章于 2023-12-09 12:00:00 发布

lysunki

最新推荐文章于 2023-12-09 12:00:00 发布

阅读量66

点赞数

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/lysunki/article/details/84724245

版权

java 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

public class Person  implements Serializable {

	private static final long serialVersionUID = 1L;

	//用户账号
	private String userid;
	//用户名
	private String username;
	//缴纳费用
	private BigDecimal incomes;
	//账户费用
	private BigDecimal single;
	//剩余
	private BigDecimal rest;
......


public interface ConsumeMapper {
public List<Person> searchPersonList();
}

<select id="searchPersonList" resultType="Person"> select u.userid, u.username, t2.incomes, t1.single, t2.incomes - ifnull(t1.single,0) as rest from t_user u LEFT JOIN (select a.userid, sum(c.unit) as single from t_customer c, t_attend a where c.cusid = a.cusid GROUP BY a.userid) t1 on u.userid = t1.userid LEFT JOIN (select c.userid, sum(c.income) as incomes from t_account c GROUP BY c.userid) t2 on u.userid = t2.userid </select>

想返回List<String> 可设置resultType="String"

<select id="find" parameterType="java.util.Map" resultType="String" >

请求参数List

<update id="updateValue" parameterType="java.util.List">
   UPDATE T_TABLE
     SET VALUE = 0
   WHERE ID in
      <foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
          #{item,jdbcType=VARCHAR}
      </foreach> 
  </update>

请求参数为Map

<select id="countByProperties" parameterType="java.util.Map" resultType="java.lang.Long" >
     ....
    <if test="_parameter.containsKey('id')" >
        BANNER_TITLE = #{id,jdbcType=VARCHAR} AND
      </if>

请求参数为普通值

<select id="searchDate"  resultType="String">
    SELECT ID FROM T_TABLE WHERE STATUS = '0'
    <![CDATA[AND EDATE <= #{expiryDate,jdbcType=TIMESTAMP} ]]>
  </select>