记录数
ResulteSet resultSet=stmt.executeQuery("select count(*) from LogAnalysis.dbo.LogData where Accout = 'zhangsan'");
resultSet.next();
int rowcount=resultSet.getInt(1);
或
int i=0;
while(resultSet.next())
{
System.out.println(resultSet.getInt("sum"));
i++;
}
ResulteSet resultSet=stmt.executeQuery("select count(*) from LogAnalysis.dbo.LogData where Accout = 'zhangsan'");
resultSet.next();
int rowcount=resultSet.getInt(1);
或
int i=0;
while(resultSet.next())
{
System.out.println(resultSet.getInt("sum"));
i++;
}
求dataSize的总和你可在在while里加一个
int sum;
sum=0;
while(resultSet.next())
{
sum=sum+resultSet.getInt("dataSize");
}