求总数的函数怎么写

[chitu11]

我想从数据库当中求总数，但是不知道怎么写了

public int getMin(String str){
		int count =0;
		try {
			Statement stmt = SumCard.getConnection().createStatement();
			ResultSet rs  = stmt.executeQuery(str) ;
			
	 
	 
	 
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return count;
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new SumCard().getMin("select min(cjsj) from t_cards t ");
	}

[lostmarine]

new SumCard().getMin("select min(cjsj) as min1 , sum(cjsj) as sum1 from t_cards t ");

[chitu11]

[Quote=引用 1 楼 lostmarine 的回复:]

new SumCard().getMin("select min(cjsj) as min1 , sum(cjsj) as sum1 from t_cards t ");
[/Quote]

我想知道上面的那个函数怎么写，就是中间的空余部分怎么取

[shanxmxj]

你要求什么总数 把需求说清楚

[lostmarine]

Statement stmt = SumCard.getConnection().createStatement();
ResultSet rs = stmt.executeQuery(str) ;
double min = 0 ;
double sum = 0 ;
if(rs.next()){
min = Double.parseDouble(rs.getString("min1")) ;
sum = Double.parseDouble(rs.getString("sum1")) ;
}

[chitu11]

[Quote=引用 4 楼 lostmarine 的回复:]

Statement stmt = SumCard.getConnection().createStatement();
ResultSet rs = stmt.executeQuery(str) ;
double min = 0 ;
double sum = 0 ;
if(rs.next()){
min = Double.parseDouble……
[/Quote]
谢啦，我想起来了