mysql+java实现分页显示的例子使用limit

最新推荐文章于 2024-07-24 09:00:00 发布

x1r2p3

最新推荐文章于 2024-07-24 09:00:00 发布

阅读量1.6k

点赞数

本文链接：https://blog.csdn.net/x1r2p3/article/details/8572650

版权

public List<Student> queryStudent(String sname,int currentPage){
       ArrayList<Student> students=new ArrayList<Student>();
       Connection con=null;
       PreparedStatement pre=null;
       ResultSet rs=null;
       DBUtil conns=new DBUtil();
       con=conns.getConnection();
       System.out.println(sname);
       try {
           pre=con.prepareStatement("SELECT * FROM student s LEFT JOIN grade g ON s.gid=g.gid WHERE sname LIKE ? AND SID NOT IN(SELECT t.sid FROM(select * from student where sname like ? limit ?)as t)");
           pre.setString(1, "%"+sname+"%");
           pre.setString(2, "%"+sname+"%");
           int a=(currentPage-1)*size;
           pre.setInt(3, a);

           rs=pre.executeQuery();
           while(rs.next()){
               Student student=new Student();
               student.setSname(rs.getString("sname"));
               student.setSid(rs.getString("sid"));
               student.setSaddress(rs.getString("saddress"));
               student.setAlikes(rs.getString("alikes"));
               Grade grade=new Grade();
               grade.setGid(rs.getString("gid"));
               grade.setGname(rs.getString("gname"));
               student.setGrade(grade);
               students.add(student);
           }
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }finally{
           try {
               con.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       return students;
   }