SSM 下的查询

import java.util.List;

public class PageInfo<T> {
    private List<T> list;
    private int totalPage;
    private int size;
    private int totalCount;
    private int currentPage;

    public List<T> getList() {
        return list;
    }

    public void setList(List<T> list) {
        this.list = list;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getSize() {
        return size;
    }

    public void setSize(int size) {
        this.size = size;
    }

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public int getCurrentPage() {
        return currentPage;
    }

    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
}
@RequestMapping("/findAll.do")
    public ModelAndView fuzzyFindByUsername(@RequestParam(defaultValue = "1") int currentPage, String username) {
        PageInfo<User> pageInfo = userService.fuzzyFindByUsername(currentPage, username);
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("pageInfo", pageInfo);
        modelAndView.setViewName("user-list");
        return modelAndView;
    }
import com.bean.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserDao {
    List<User> findAll(@Param("start") int start,@Param("username") String username);
}

@Override
public PageInfo<User> findAll(int currentPage,String username) {
    PageInfo<User> pageInfo = new PageInfo<>();
    pageInfo.setSize(5);
    int to = userDao.getTotalCount(username);
    pageInfo.setTotalCount(to);
    int tp = (int)Math.ceil(to/5.0);
    pageInfo.setTotalPage(tp);
    if (currentPage<1){
        pageInfo.setCurrentPage(1);
    }else if (currentPage>tp){
        pageInfo.setCurrentPage(tp);
    }else{
        pageInfo.setCurrentPage(currentPage);
    }
    int start = (pageInfo.getCurrentPage() - 1)*5;
    List<User> userList = userDao.findAll(start,username);
    pageInfo.setList(userList);
    return pageInfo;
}

import com.bean.PageInfo;
import com.bean.User;

import java.util.List;

public interface IUserService {

    PageInfo<User> findAll(int currentPage,String username);
}

    <select id="findUserByUserName" parameterType="String" resultType="user">
        select * from tb_user where username=#{username}
    </select>
<form action="${pageContext.request.contextPath}/user/findAll.do?type=1"
	method="post">
		<div class="col-md-4 data1">
				<input type="text" class="form-control" name="username"
				 placeholder="username" value="">
		</div>
	<button type="submit" class="btn bg-maroon">搜索</button>
</form>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值