Java统计数据库表中记录数

public static int count(String tableName) {
    int i = 0;
    Connection con = DB.getConnnection();
    try {
        Statement stmt = con.createStatement();
        ResultSet rset = stmt.executeQuery("select count(*)as totalCount from " + tableName);
        if (rset.next()) {
            i = rset.getInt("totalCount");
        }
    } catch (Exception e) {
        System.err.println("你确定你没有输错表明么???");
        e.printStackTrace();
    } finally {
        DB.closeConn(con);
    }
    System.out.println(i);
    return i;
}

 


版权声明:本文为umgsai原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。