Question

MYSQL语法最后的引号不知道怎么加

An error occurred at line: 62 in the jsp file: /fengye.jsp
Duplicate local variable rs
59: //判断起始页
60: spage = (cpage - 1) * ipage;
61: String sql="SELECT * FROM message Order By msgid Desc LIMIT "+spage+','+ipage+"'";
62: ResultSet rs = smt.executeQuery(sql);
63: %>
64:
65: <table width="500" border="0" align="center" cellpadding="0" cellspacing="0">

Answer 1

String sql="SELECT * FROM message Order By msgid Desc LIMIT "+spage+','+ipage+"'";

修改为：

String sql="SELECT * FROM message Order By msgid Desc LIMIT "+spage+','+ipage;

不需要末尾的引号。