1、修改 //条数更改和修改@Update("update ss set " + "bt = #{bt} , tt = #{tt} , update_date = #{updateDate} WHERE id = #{id}")void upDateByBalanceCountAndTotalCountAndUpdateDate(@Param("id") int id, @Param("bt") int balanceCount, @P
1、修改
//条数更改和修改@Update("update ss set " + "bt = #{bt} , tt = #{tt} , update_date = #{updateDate} WHERE id = #{id}")void upDateByBalanceCountAndTotalCountAndUpdateDate(@Param("id") int id, @Param("bt") int balanceCount, @Param("tt") int tt, @Param("updateDate") int updateDate);解释：where条件比较多时最好写在一行 否则查询失败2、 多条件查询
@Select(" <script> SELECT id," "p_t pT," + " WHERE " + "1+1"+ " and s = #{pa.s}"+ " <if test=\"#{pa.d} != null\">and uid = #{pa.d} </if> "+ " <if test=\"#{pa.d} != null \">and brand_id = #{pa.d} </if> "+ " <if test=\"#{pa.d1} != null \">and id limit #{pa.d1},#{pa.d2} </if> </script>")List<CpMsgPayDetail> findByid1Andid3 (@Param("pa") Map<String, Object> pa);解释：一定要加上脚本<script> 否则查询失败