select count(*) from RFM_Portal_Product where spicture is not null
在sql server2005中明明是6913但是在下面程序返回的结果居然是6900
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();
}
在sql server2005中明明是6913但是在下面程序返回的结果居然是6900
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();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货