Java学习之路（三）

代码

Dao层

public Result userxfz() {
    String sql = "select u.username,IFNULL(sum(o.money),0)\n" +
            "from `user` u LEFT JOIN `order` o\n" +
            "ON u.userid  = o.userid\n" +
            "GROUP BY  u.username ";
    List<Map<String, Object>> listmap = DB.getListMap(sql);
    return new Result(listmap);
}

public Result usermoney(double money) {
    String sql = "select * from ";
    if (checkNotEmpty(money)) {
        sql += " `user` u INNER JOIN `order` o \n" +
                "ON u.userid =o.userid GROUP BY u.username HAVING sum(o.money) > " + money;
    }
    System.out.println(sql);
    List<Map<String, Object>> listmap = DB.getListMap(sql);
    return new Result(listmap);
}

public Result userpage(int pagesize ,int pagenum) {
    String sql = "SELEC