Question

oracle 查询语句转换成mysql语句

"SELECT * FROM "
+ "(SELECT deptno,dname,loc,ROWNUM rn FROM dept WHERE "
+ " (deptno LIKE ? OR dname LIKE ? OR loc LIKE ?) "
+ " AND ROWNUM<=" + (currentPage * lineSize) + ") temp"
+ " WHERE rn>" + (currentPage - 1) * lineSize;
我不会oracle语句，求大家帮忙转换一下！

Answer 1

oracle用的rownum分页 mysql用的limit分页

Answer 2

直接拿进去运行
select deptno,dname,loc from dept where deptno like ? or dname like ? or loc like ? limit (currentPage - 1) * lineSize,currentPage * lineSize;

追问

这句我之前试过啦，虽然也是MYSQL的分页查询，但是好像不能和上面那句完全替换，程序不能实现它之前的功能！

追答

select deptno,dname,loc from dept where deptno like ? or dname like ? or loc like ? limit (currentPage - 1) * lineSize,lineSize;

之前写错了...