request.getRequestDispatcher("/ReportEmitter?rpt=contractState.brt").forward(request, response);
2.繼承ContractStateDataSet，將結果集放到報表中
package bios.report.user.dev.demo.dataset;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import javax.servlet.http.HttpSession;
import bios.report.engine.api.CustomDataSet;
import bios.report.engine.api.UserContext;
import com.dhcc.itsm.document.model.Contract;
import com.dhcc.itsm.document.model.ContractPay;
import com.dhcc.itsm.document.model.ContractSettlement;
/**
* @author dhcc
*/
public class ContractStateDataSet implements CustomDataSet{
private String[] metaData;
private List<Contract> conList = new ArrayList<Contract>();
@SuppressWarnings("unchecked")
private List data;
public String[] getMetaData() {
return metaData;
}
public int getRowCount() {
return data.size();
}
public Object[] getRowData(int rowIndex) {
return (Object[])data.get(rowIndex);
}
@SuppressWarnings("unchecked")
public void applyParams(Object[] arg0) {
HttpSession req = UserContext.getCurrentUserContext().getRequest().getSession();
conList = (List<Contract>) req.getAttribute("list");
metaData = new String[]{"合同名稱","合同金額","結算日期","結算金額","結算合計","付款日期","付款金額","付款合計","施工單位"};
data = new ArrayList();
try {
if(conList != null && !conList.isEmpty()){
for(int i=0;i<conList.size();i++){
Contract con = conList.get(i);
String[] settleStr = getSettle(con.getSettleSet());//結款信息放到字符串中
String[] payStr = getPay(con.getPaySet()); //付款信息放到字符串中
data.add(new Object[]{con.getContractName(),con.getMoney(),settleStr[0],settleStr[1],
Double.parseDouble(settleStr[2]),payStr[0],payStr[1],Double.parseDouble(payStr[2]),con.getYiFang()});
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
public List<Contract> getConList() {
return conList;
}
public void setConList(List<Contract> conList) {
this.conList = conList;
}
/**
* 結款信息放到放到字符串中
* @param settleList
* @return
*/
@SuppressWarnings("unchecked")
private String[] getSettle(Set<ContractSettlement> settleSet){
String[] settleStr = new String[3];
String settleTemp = "\n";//結算日期
String moneyStr ="\n";//結算金額
double settleSum = 0;//結款總金額
if(settleSet != null && !settleSet.isEmpty()){
Iterator it = settleSet.iterator();
while(it.hasNext()){
ContractSettlement settle = (ContractSettlement) it.next();
settleTemp += settle.getBalanceDate() +"\n\n";
moneyStr += settle.getMoney()+"\n\n";
settleSum +=Double.parseDouble(settle.getMoney());
}
}
settleStr[0]=settleTemp;
settleStr[1]=moneyStr;
settleStr[2]=String.valueOf(settleSum);
return settleStr;
}
/**
* 付款信息放到放到字符串中
* @param settleList
* @return
*/
@SuppressWarnings("unchecked")
private String[] getPay(Set<ContractPay> paySet){
String[] payStr = new String[3];
String payTemp = "\n";//
String moneyStr ="\n";
double paySum = 0;//付款總金額
if(paySet != null && !paySet.isEmpty()){
Iterator it = paySet.iterator();
while(it.hasNext()){
ContractPay pay = (ContractPay) it.next();
payTemp += pay.getPayDate() +"\n\n";
moneyStr += pay.getMoney()+"\n\n";
paySum +=Double.parseDouble(pay.getMoney());
}
}
payStr[0]=payTemp;
payStr[1]=moneyStr;
payStr[2]=String.valueOf(paySum);
return payStr;
}