limit 后面如何用java变量赋值

Question

int pagesize =0; int sumnum=30;pagesize =sumnum/2;
// int tmpPage = 0;
// tmpPage = sumnum % 2 == 0 ? 0 : 1;
// pagesize = pagesize + tmpPage;
for(int i=1;i<=pagesize;i++){
String sql = "SELECT ID,name, url From websites limit i*2,2;";
ResultSet rs = stmt.executeQuery(sql);
limit后面需要将java i的变量赋值，麻烦再讲清楚些，怎么做，在我后面写上些代码刚刚接触编程呀，网上去找，都不对，大佬，拜托了。

Answer 1

String sql = "SELECT ID,name, url From websites limit "+(i*2)+",2;";