日期:2014-05-20  浏览次数:20865 次

java executeQuery()查询的问题
select count(*) from RFM_Portal_Product where spicture is not null
在sql server2005中明明是6913

但是在下面程序返回的结果居然是6900
Java code
Connection con = GolbalDbInfo1.getConnection();
        String sql = "select count(*) from RFM_Portal_Product where spicture is not null";
        try {
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            rs.next();
            System.out.println(rs.getString(1));
        } catch (SQLException e) {
            e.printStackTrace();
        }


------解决方案--------------------

------解决方案--------------------
接分~~