当前位置: 代码迷 >> Java Web开发 >> 新人求助 web分页mysql中sql语句出错
  详细解决方案

新人求助 web分页mysql中sql语句出错

热度:514   发布时间:2013-11-01 20:59:31.0
新人求助 web分页mysql中sql语句出错
//====================分页=============
            int pagesize = 3;//每页显示多少条记录
            int pagenow = 1;//希望显示第几页
            int rowcount = 0;//一共有多少条记录  查表的来
            int pagecount = 0;//一共有几页  计算的来
        
            //得到rowcount
            Class.forName("com.mysql.jdbc.Driver");
            cn = DriverManager.getConnection("jdbc:mysql://localhost/userlist", "root", "123");
            ps = cn.prepareStatement("select count(*) from userlist");
            rs = ps.executeQuery();
            
            if(rs.next()){
               
                rowcount = rs.getInt(1);
            }
            //计算pagecount
            if(rowcount%pagesize==0){
                pagecount = rowcount/pagesize;
            }else{
                pagecount = rowcount/pagesize+1;
            }
            String sql = "select * from userlist limit ("+pagenow+"-1)*"+pagesize+","+pagesize+"";
            //String sql = "select * from userlist limit 0,3";
            ps = cn.prepareStatement(sql);
            //ps.setInt(1, pagenow);
            //ps.setInt(2, pagesize);
            //ps.setInt(3, pagesize);
            
            rs = ps.executeQuery();
            
            pw.println("<table border=1>");
            pw.println("<tr><th>ID</th><th>NAME</th><th>PASSWD</th><th>EMAIL</th><th>GRADE</th></tr>");   
            while(rs.next()){
               
                pw.println("<tr>");
                pw.println("<td>"+rs.getInt(1)+"</td>");
                pw.println("<td>"+rs.getString(2)+"</td>");
                pw.println("<td>"+rs.getString(3)+"</td>");
                pw.println("<td>"+rs.getString(4)+"</td>");
                pw.println("<td>"+rs.getInt(5)+"</td>");
                pw.println("</tr>");
               
            }
            pw.println("</table>");


错误You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1-1)*3,3' at line 1
搜索更多相关的解决方案: localhost  sql语句  mysql  count  记录  

----------------解决方案--------------------------------------------------------
这是sql语法错误 select * from userlist limit ("+pagenow+"-1)*"+pagesize+","+pagesize+"";
select * from userlist limit +"("+pagenow+"-1)*"+pagesize+","+pagesize+"";

----------------解决方案--------------------------------------------------------
  相关解决方案