基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

管理日常支出

@RequestMapping(value = "/recordselectBydate")

    public String selectByRecorddate(String userId, String time, @RequestParam(defaultValue = "10") Integer pageSize, @RequestParam(defaultValue = "1") Integer pageNo, Model model) {

        Integer uId = Integer.parseInt(userId);

DateFormatfmt = new SimpleDateFormat("yyyy-MM-dd");

        Date date1 = null;

        try { date1 = fmt.parse(time);} catch (ParseException e) {

e.printStackTrace(); }

        List<Record> list = recordservice.selectbyRecorddate(uId, date1, pageSize, ((pageNo - 1) * pageSize));

model.addAttribute("recordlist", list);

//收入总金额

model.addAttribute("income", recordservice.selectincome(uId, date1));

//支出总金额

model.addAttribute("pay", recordservice.selectpay(uId, date1));

        return "record/datarecord";

Mapper.xml

<select id="queryRecordbydate" resultMap="BaseResultMap">

        select * from records where user_id=#{userId}

<![CDATA[

      and DATE_FORMAT(time, '%Y-%m-%d') =  DATE_FORMAT(#{time}, '%Y-%m-%d')

        ]]>  limit #{pageNo},#{pageSize}

</select>

<select id="income" resultType="DOUBLE">

        select sum(value) FROM records where user_id=#{userId}

<![CDATA[

      and DATE_FORMAT(time, '%Y-%m-%d') =  DATE_FORMAT(#{time}, '%Y-%m-%d')

        ]]>  AND value&gt;0

</select>

<select id="pay" resultType="DOUBLE">

        select sum(value) FROM records where user_id=#{userId}

<![CDATA[

      and DATE_FORMAT(time, '%Y-%m-%d') =  DATE_FORMAT(#{time}, '%Y-%m-%d')

        ]]>  AND value &lt;=0

</select>