java - MySQL 查询限制子句中包含 Java 变量

Question

我正在用 Java 编写此程序，并尝试执行此查询，但存在语法错误。谁能告诉我问题出在哪里吗？谢谢

int initial;
int last;
this.initial=initial;
this.last = limit;
resultSet = statement.executeQuery("select * from weibo_olympics Limit '"+initial+"','"+last+"';");

Answer 1

请尝试这个:

int initial;
int last;
this.initial=initial;
this.last = limit;
resultSet = statement.executeQuery("select * from weibo_olympics Limit "+initial+","+last);

希望这有帮助