zhouer 发表于 2018-9-25 08:28:28

oracle，mysql真分页

　　又到了毕设的季节，有位同学问我真分页的问题，就写个例子参考参考吧
　　oracle语句使用ROWNUM真分页
　　sql = &quot;select * from ( select pid,name,price,amount,ROWNUM rn from product where ( name LIKE ? or price LIKE ? or amount LIKE ? ) AND ROWNUM < = ? order by pid ) temp where temp.rn > ?
　　pstmt = conn.prepareStatement(sql);
　　pstmt.setString(1,&quot;%&quot;+keyword+&quot;%&quot;);
　　pstmt.setString(2,&quot;%&quot;+keyword+&quot;%&quot;);
　　pstmt.setString(3,&quot;%&quot;+keyword+&quot;%&quot;);
　　pstmt.setString(4,&quot;%&quot;+keyword+&quot;%&quot;);
　　pstmt.setInt(5,&quot;%&quot;+keyword+&quot;%&quot;);
　　pstmt.setInt(6,&quot;%&quot;+keyword+&quot;%&quot;);
　　rs = pstmt.executeQuery();
　　相应的mysql真分页写法（用limit）
　　String sql = &quot;select * from product where name like ? or note like ? or price like ? or amount like ? order by pid LIMIT ?,?&quot;
　　this.pstmt = conn.prepareStatement(sql);
　　this.pstmt.setString(1,&quot;%&quot;+keyword+&quot;%&quot;);
　　this.pstmt.setString(2,&quot;%&quot;+keyword+&quot;%&quot;);
　　this.pstmt.setString(3,&quot;%&quot;+keyword+&quot;%&quot;);
　　this.pstmt.setString(4,&quot;%&quot;+keyword+&quot;%&quot;);
　　this.pstmt.setInt(5,(currentPage-1)*linesize);
　　this.pstmt.setInt(6,linesize);
　　ResultSet rs = pstmt.executeQuery();

页: [1]
查看完整版本: oracle，mysql真分页