Question

java中怎么把sql查询语句中的数值通过int类变量来表示?

比如：String sql = "select top (currentPageIndex * countPerPage)-((currentPageIndex-1) * countPerPage + 1)+1) * from mespane where(id not in(select top (n-1) id from mespane))";
currentPageIndex和countPerPage是int类型变量，我怎么在这句话中来使用呢？

Answer 1

能把sql塞入这么多计算表达式的人估计是个人才
int index=currentPageIndex * countPerPage)-((currentPageIndex-1) * countPerPage + 1)+1;

String sql = "select top ("+index+") * from mespane where(id not in(select top (n-1) id from mespane))";

不谢

Answer 2

oracle 是
to_number(currentPageIndex)

Answer 3

"select top (" + (currentPageIndex * countPerPage -((currentPageIndex-1) * countPerPage + 1)+1) +") * from mespane where(id not in(select top (n-1) id from mespane))";