Name Id
aa 1
bb 5我使用它从id列中获取所有值。
SELECT id FROM name_table;我想对id列中的值求和。为了清楚起见,我正在制作一个财务应用程序,希望将msql数据库中记录的所有资金相加。
发布于 2021-10-04 11:38:45
如果您只想获得所有ID值的总和,那么这将是可行的:
SELECT SUM(id) FROM name_table发布于 2021-10-04 12:01:23
int sum = 0;
while (res.next()) {
int i = res.getInt(1); or rs.getString("id "); //using column name
sum = sum + i;
System.out.println(sum);
OR
String q= "SELECT SUM(id) as totalSum FROM tableName";
PreparedStatement pst = connectio.prepareStatement(q);
ResultSet rs = pst.executeQuery();
if (rs.next()) {
sum = rs.getString("totalSum");
System.out.print("total sum" + sum);
} else {
System.out.print("Query didn't return any results");
}https://stackoverflow.com/questions/69435286
复制相似问题