测试存储过程的调用

1、实体类InfoVo

package org.ygwy.procedure.test;

public class InfoVo {
 private String id;
 private String journalNumber;
 private String rcName;
 private String houseNumber;
 private String hCName;
 private String ownerName;
 private String feeYearMonth;
 private String efsNum;
 private String efeNum;
 private String essNum;
 private String eseNum;
 private String etsNum;
 private String eteNum;
 private String etotal;
 private String ePrice;
 private String wfsNum;
 private String wfeNum;
 private String wssNum;
 private String wseNum;
 private String wtsNum;
 private String wteNum;
 private String wtotal;
 private String wPrice;
 private String dkm;
 private String dkmje;
 private String houseArea;
 private String propertyExpensePrice;
 private String wyje;
 private String lateFee;
 private String ultimoBalance;
 private String amountReceivable;
 private String realReceivable;
 private String repairFee;
 private String otherFee;
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getJournalNumber() {
  return journalNumber;
 }
 public void setJournalNumber(String journalNumber) {
  this.journalNumber = journalNumber;
 }
 public String getRcName() {
  return rcName;
 }
 public void setRcName(String rcName) {
  this.rcName = rcName;
 }
 public String getHouseNumber() {
  return houseNumber;
 }
 public void setHouseNumber(String houseNumber) {
  this.houseNumber = houseNumber;
 }
 public String getHCName() {
  return hCName;
 }
 public void setHCName(String name) {
  hCName = name;
 }
 public String getOwnerName() {
  return ownerName;
 }
 public void setOwnerName(String ownerName) {
  this.ownerName = ownerName;
 }
 public String getFeeYearMonth() {
  return feeYearMonth;
 }
 public void setFeeYearMonth(String feeYearMonth) {
  this.feeYearMonth = feeYearMonth;
 }
 public String getEfsNum() {
  return efsNum;
 }
 public void setEfsNum(String efsNum) {
  this.efsNum = efsNum;
 }
 public String getEfeNum() {
  return efeNum;
 }
 public void setEfeNum(String efeNum) {
  this.efeNum = efeNum;
 }
 public String getEssNum() {
  return essNum;
 }
 public void setEssNum(String essNum) {
  this.essNum = essNum;
 }
 public String getEseNum() {
  return eseNum;
 }
 public void setEseNum(String eseNum) {
  this.eseNum = eseNum;
 }
 public String getEtsNum() {
  return etsNum;
 }
 public void setEtsNum(String etsNum) {
  this.etsNum = etsNum;
 }
 public String getEteNum() {
  return eteNum;
 }
 public void setEteNum(String eteNum) {
  this.eteNum = eteNum;
 }
 public String getEtotal() {
  return etotal;
 }
 public void setEtotal(String etotal) {
  this.etotal = etotal;
 }
 public String getEPrice() {
  return ePrice;
 }
 public void setEPrice(String price) {
  ePrice = price;
 }
 public String getWfsNum() {
  return wfsNum;
 }
 public void setWfsNum(String wfsNum) {
  this.wfsNum = wfsNum;
 }
 public String getWfeNum() {
  return wfeNum;
 }
 public void setWfeNum(String wfeNum) {
  this.wfeNum = wfeNum;
 }
 public String getWssNum() {
  return wssNum;
 }
 public void setWssNum(String wssNum) {
  this.wssNum = wssNum;
 }
 public String getWseNum() {
  return wseNum;
 }
 public void setWseNum(String wseNum) {
  this.wseNum = wseNum;
 }
 public String getWtsNum() {
  return wtsNum;
 }
 public void setWtsNum(String wtsNum) {
  this.wtsNum = wtsNum;
 }
 public String getWteNum() {
  return wteNum;
 }
 public void setWteNum(String wteNum) {
  this.wteNum = wteNum;
 }
 public String getWtotal() {
  return wtotal;
 }
 public void setWtotal(String wtotal) {
  this.wtotal = wtotal;
 }
 public String getWPrice() {
  return wPrice;
 }
 public void setWPrice(String price) {
  wPrice = price;
 }
 public String getDkm() {
  return dkm;
 }
 public void setDkm(String dkm) {
  this.dkm = dkm;
 }
 public String getDkmje() {
  return dkmje;
 }
 public void setDkmje(String dkmje) {
  this.dkmje = dkmje;
 }
 public String getHouseArea() {
  return houseArea;
 }
 public void setHouseArea(String houseArea) {
  this.houseArea = houseArea;
 }
 public String getPropertyExpensePrice() {
  return propertyExpensePrice;
 }
 public void setPropertyExpensePrice(String propertyExpensePrice) {
  this.propertyExpensePrice = propertyExpensePrice;
 }
 public String getWyje() {
  return wyje;
 }
 public void setWyje(String wyje) {
  this.wyje = wyje;
 }
 public String getLateFee() {
  return lateFee;
 }
 public void setLateFee(String lateFee) {
  this.lateFee = lateFee;
 }
 public String getUltimoBalance() {
  return ultimoBalance;
 }
 public void setUltimoBalance(String ultimoBalance) {
  this.ultimoBalance = ultimoBalance;
 }
 public String getAmountReceivable() {
  return amountReceivable;
 }
 public void setAmountReceivable(String amountReceivable) {
  this.amountReceivable = amountReceivable;
 }
 public String getRealReceivable() {
  return realReceivable;
 }
 public void setRealReceivable(String realReceivable) {
  this.realReceivable = realReceivable;
 }
 public String getRepairFee() {
  return repairFee;
 }
 public void setRepairFee(String repairFee) {
  this.repairFee = repairFee;
 }
 public String getOtherFee() {
  return otherFee;
 }
 public void setOtherFee(String otherFee) {
  this.otherFee = otherFee;
 }

}
2、接口InfoDao

package org.ygwy.procedure.test;

import java.util.List;

public interface InfoDao {
 public List<InfoVo> queryAll(String s,String e);
}
3、实现类InfoDaoImpl

package org.ygwy.procedure.test;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.ygwy.db.DBConn;

public class InfoDaoImpl implements InfoDao {

 public List<InfoVo> queryAll(String ss,String ee) {
  DBConn db=new DBConn();
  List<InfoVo> list=new ArrayList<InfoVo>();
  try {
   CallableStatement pc=db.getConn().prepareCall("{call pro_test(?, ?)}");
   pc.setString(1, ss);
   pc.setString(2, ee);
   ResultSet rs=pc.executeQuery();
   while(rs.next()){
   InfoVo info=new InfoVo();   
   info.setId(rs.getString("Id"));
   info.setAmountReceivable(rs.getString("AmountReceivable"));
   info.setDkm(rs.getString("Dkm"));
   info.setDkmje(rs.getString("Dkmje"));
   info.setEfeNum(rs.getString("EfeNum"));
   info.setEfsNum(rs.getString("EfsNum"));
   info.setEPrice(rs.getString("EPrice"));
   info.setEseNum(rs.getString("EseNum"));
   info.setEssNum(rs.getString("EssNum"));
   info.setEteNum(rs.getString("EteNum"));
   info.setEtotal(rs.getString("Etotal"));
   info.setEtsNum(rs.getString("EtsNum"));
   info.setFeeYearMonth(rs.getString("FeeYearMonth"));
   info.setHCName(rs.getString("HCName"));
   info.setHouseArea(rs.getString("HouseArea"));
   info.setHouseNumber(rs.getString("HouseNumber"));
   info.setJournalNumber(rs.getString("JournalNumber"));
   info.setLateFee(rs.getString("LateFee"));
   info.setOtherFee(rs.getString("OtherFee"));
   info.setOwnerName(rs.getString("OwnerName"));
   info.setPropertyExpensePrice(rs.getString("PropertyExpensePrice"));
   info.setRcName(rs.getString("RcName"));
   info.setRealReceivable(rs.getString("RealReceivable"));
   info.setRepairFee(rs.getString("RepairFee"));
   info.setUltimoBalance(rs.getString("UltimoBalance"));
   info.setWfeNum(rs.getString("WfeNum"));
   info.setWfsNum(rs.getString("WfsNum"));
   info.setWPrice(rs.getString("WPrice"));
   info.setWseNum(rs.getString("WseNum"));
   info.setWssNum(rs.getString("WssNum"));
   info.setWteNum(rs.getString("WteNum"));
   info.setWtotal(rs.getString("Wtotal"));
   info.setWtsNum(rs.getString("WtsNum"));
   info.setWyje(rs.getString("Wyje"));
   
   list.add(info);
   }

  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return list;
 }

}

 

4、测试类Test

package org.ygwy.procedure.test;

import java.util.Iterator;
import java.util.List;

public class Test {

 
 public static void main(String[] args) {
  InfoDao dao=new InfoDaoImpl();
  List list=dao.queryAll("200907", "200907");
  Iterator iter=list.iterator();
  while(iter.hasNext()){
   InfoVo info=(InfoVo)iter.next();
   System.out.println(info.getAmountReceivable()+","+info.getJournalNumber()+","+info.getRealReceivable());
  }

 }

}