最好分成两个过程: CREATE PROCEDURE sp_output1 @date1 datetime, @date2 datetime, AS select sum(Total_1),sum(Subtotal_1) from lawer_input where Report_time >= @date1 and Report_time <= @date2 go CREATE PROCEDURE sp_output2 @date3 datetime, @date4 datetime AS select sum(Total_1),sum(Subtotal_1),sum(Support_1) from lawer_input where Report_time >= @date3 and Report_time <= @date4
public ResultSet processTransfer(String sql,java.sql.Date
date1,java.sql.Date date2){
try{
sqlStmt = con.prepareCall(sql);
//执行该存储过程并返回结果集
sqlStmt.setDate(1,date1);
sqlStmt.setDate(2,date2);
sqlRst = sqlStmt.executeQuery();
}catch(Exception e){
System.out.println("Error from processTransfer!"+e) ;
}finally{
return sqlRst;
}
}
CREATE PROCEDURE sp_output1
@date1 datetime,
@date2 datetime,
AS
select sum(Total_1),sum(Subtotal_1)
from lawer_input
where Report_time >= @date1
and Report_time <= @date2
go
CREATE PROCEDURE sp_output2
@date3 datetime,
@date4 datetime
AS
select sum(Total_1),sum(Subtotal_1),sum(Support_1)
from lawer_input
where Report_time >= @date3
and Report_time <= @date4