Java统计数据库表中记录数

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
public static int count(String txyl_table) {// 获取用户数量
    int i = 0;// Store_Information
    Connection con = DB.getConnnection();
    try {
        Statement stmt = con.createStatement();
        ResultSet rset = stmt.executeQuery("select count(*)as totalCount from "+ txyl_table); 
        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;
}

  

posted @   商商-77  阅读(1252)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示