错误代码是这样的 An error occurred at line: 66 in the jsp file: /news.jsp String literal is not properly closed by a double-quote 63: } 64: 65: 66: String sql = "select top" + ipage+ "* from news where id not in(select top 67: "+(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 68: ResultSet rs=one.executeQuery("sql"); 69: %>
String sql = "select top" + ipage+ "* from news where id not in(select top "+(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 这一句你是用两行显示的??
String sql = "select top" + ipage+ "* from news where id not in(select top "+ "+(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 改成这样看行不行咯
String sql = "select top" + ipage+ "* from news where id not in(select top "+ (cpage-1)*ipage+"id from news order by id desc)order by id desc"; 上面的还有点问题,应该这样可以吧
String sql = "select top " + ipage+ "* from news where id not in(select top "+(cpage-1)*ipage+ " id from news order by id desc)order by id desc";
top"+(cpage-1)*ipage+"id
双引号前后加空格试试看
这里的sql不应该用引号,应改为:
ResultSet rs=one.executeQuery(sql);
错误代码是这样的
An error occurred at line: 66 in the jsp file: /news.jsp
String literal is not properly closed by a double-quote
63: }
64:
65:
66: String sql = "select top" + ipage+ "* from news where id not in(select top
67: "+(cpage-1)*ipage+"id from news order by id desc)order by id desc";
68: ResultSet rs=one.executeQuery("sql");
69: %>
"+(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 这一句你是用两行显示的??
"+(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 改成这样看行不行咯
(cpage-1)*ipage+"id from news order by id desc)order by id desc"; 上面的还有点问题,应该这样可以吧