jsp 显示mysql数据库信息

最新推荐文章于 2021-02-17 04:57:46 发布

jiuwentu6624

最新推荐文章于 2021-02-17 04:57:46 发布

阅读量433

点赞数

本文链接：https://blog.csdn.net/jiuwentu6624/article/details/53954954

版权

<%
    int pageSize = 10;
    int pageNow = 1;
    int rowCount = 0;
    int pageCount = 0;
    //对pagenow修改接手用户希望显示的页数
    String s_pageNow = request.getParameter("pageNow");
    if(s_pageNow != null){
        pageNow = Integer.parseInt(s_pageNow);
    }

      DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//驱动程序名

String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";

//密码

String userPasswd="liuxu1993";

//数据库名

String dbName="sss";

//表名

String tableName="user";

//联结字符串

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection ct=DriverManager.getConnection(url);

    Statement sm = ct.createStatement();
    ResultSet rs = sm.executeQuery("select count(*) from user ");
    if(rs.next()){
    rowCount = rs.getInt(1);
    }
    if(rowCount%pageSize == 0){
    pageCount = rowCount/pageSize;
    } else{
    pageCount = rowCount/pageSize+1;
    }
    rs = sm.executeQuery("select top "+pageSize+" * from user where userId not in(select top "+pageSize*(pageNow-1)+" userId from user)");
    %>

错误提示
org.apache.jasper.JasperException: An exception occurred processing JSP page /show1.jsp at line 76

73:     } else{
74:     pageCount = rowCount/pageSize+1;
75:     }
76:     rs = sm.executeQuery("select top "+pageSize+" * from user where userId not in(select top "+pageSize*(pageNow-1)+" userId from user)");
77:     %>
78:     <table>
79:     <tr><td>id</td><td>zhanghao</td><td>mima</td><td>dengji</td></tr>

我是按照视频教程做的怎么会有错