大家看看我这个类里面的方法有没有错，最后的vo能不能return出来？
public class OpenOrdersDaoImpl implements OpenOrdersDao{
private JdbcTemplate jdbcTemplate;
private ResultSet mosMosaddResults ;
private ResultSet mosMospartResults ;
private ResultSet mosMosmiscResults ;
private ResultSet mosMosengResults ;
private ResultSet mosMosuserResults ;
private ResultSet mosMosmisccomResults ;
public MosDetailsVO getMosReport(final String mosId ,final String locId) {
MosDetailsVO vo=new MosDetailsVO() ;
try {
CallableStatementCallback csc = new CallableStatementCallback() {
public Object doInCallableStatement(
java.sql.CallableStatement cs) throws SQLException,
DataAccessException {
cs.setString(1,mosId);
cs.setString(2,locId);
cs.registerOutParameter(3, OracleTypes.CURSOR);
cs.registerOutParameter(4, OracleTypes.CURSOR);
cs.registerOutParameter(5, OracleTypes.CURSOR);
cs.registerOutParameter(6, OracleTypes.CURSOR);
cs.registerOutParameter(7, OracleTypes.CURSOR);
cs.registerOutParameter(8, OracleTypes.CURSOR);
cs.execute();
//mosDetailsResults
mosMosaddResults = (ResultSet)cs.getObject(3);
mosMospartResults = (ResultSet)cs.getObject(4);
mosMosmiscResults = (ResultSet)cs.getObject(5);
mosMosengResults = (ResultSet)cs.getObject(6);
mosMosuserResults = (ResultSet)cs.getObject(7);
mosMosmisccomResults = (ResultSet)cs.getObject(8);
return null;
}
};
jdbcTemplate.execute(CROSConstants.CRIF_REPAIR_STATUS_MOS_DETAILS,csc);
//mosadd
Object object = null;
object = mosMosaddResults.getObject(1);
if (null != object) {
vo.setServiceOperation(object.toString());
}
object = mosMosaddResults.getObject(2);
if (null != object) {
vo.setElectricCompany(object.toString());
}
object = mosMosaddResults.getObject(3);
if (null != object) {
vo.setToNumber(object.toString());
}
object = mosMosaddResults.getObject(4);
if (null != object) {
vo.setBlankNumber(object.toString());
}
object = mosMosaddResults.getObject(5);
if (null != object) {
vo.setWayNumber(object.toString());
}
object = mosMosaddResults.getObject(6);
if (null != object) {
vo.setAirLines(object.toString());
}
object = mosMosaddResults.getObject(7);
if (null != object) {
vo.setServiceRoad(object.toString());
}
object = mosMosaddResults.getObject(8);
if (null != object) {
vo.setAtlanta(object.toString());
}
object = mosMosaddResults.getObject(9);
if (null != object) {
vo.setUsa(object.toString());
}
object = mosMosaddResults.getObject(10);
if (null != object) {
vo.setAtlantaGa(object.toString());
}
object = mosMosaddResults.getObject(11);
if (null != object) {
vo.setBlankNumberBelow(object.toString());
}
object = mosMosaddResults.getObject(15);
if (null != object) {
vo.setShipRefNo(object.toString());
}
object = mosMosaddResults.getObject(16);
if (null != object) {
vo.setMsDate(object.toString());
}
object = mosMosaddResults.getObject(17);
if (null != object) {
vo.setShippedVia(object.toString());
}
object = mosMosaddResults.getObject(18);
if (null != object) {
vo.setTypeChrg(object.toString());
}
object = mosMosaddResults.getObject(19);
if (null != object) {
vo.setCharges(object.toString());
}
//mospart
object = mosMospartResults.getObject(1);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setStrCONumber(object.toString());
}
object = mosMospartResults.getObject(2);
if (null != object) {
vo.setStrPOLine(object.toString());
}
object = mosMospartResults.getObject(3);
if (null != object) {
vo.setStrClass(object.toString());
}
object = mosMospartResults.getObject(4);
if (null != object) {
vo.setStrQty(object.toString());
}
object = mosMospartResults.getObject(5);
if (null != object) {
vo.setStrOutPartNbr(object.toString());
}
object = mosMospartResults.getObject(6);
if (null != object) {
vo.setStrDesc(object.toString());
}
object = mosMospartResults.getObject(7);
if (null != object) {
vo.setStrInPartNbr(object.toString());
}
object = mosMospartResults.getObject(8);
if (null != object) {
vo.setStrCmpntCode(object.toString());
}
object = mosMospartResults.getObject(9);
if (null != object) {
vo.setStrPartSerNbr(object.toString());
}
object = mosMospartResults.getObject(10);
if (null != object) {
vo.setStrADNNbr(object.toString());
}
object = mosMospartResults.getObject(11);
if (null != object) {
vo.setStrCntryOfOrigin(object.toString());
}
object = mosMospartResults.getObject(12);
if (null != object) {
vo.setStrSONumber(object.toString());
}
object = mosMospartResults.getObject(13);
if (null != object) {
vo.setStrReqdDate(object.toString());
}
object = mosMospartResults.getObject(14);
if (null != object) {
vo.setStrMSLine(object.toString());
}
//mosmisc
object = mosMosmiscResults.getObject(1);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setExporterRecord(object.toString());
}
object = mosMosmiscResults.getObject(2);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setMarketValue(object.toString());
}
object = mosMosmiscResults.getObject(3);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setRepairCharge(object.toString());
}
object = mosMosmiscResults.getObject(4);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setImportBond(object.toString());
}
object = mosMosmiscResults.getObject(8);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setCountryOrigin(object.toString());
}
object = mosMosmiscResults.getObject(5);
if ((null != object)&&(!object.toString().equals(""))) {
vo.setWeightDimension(object.toString());
}
//moseng
object = mosMosengResults.getObject(1);
if (null != object) {
vo.setEngineModel(object.toString());
}
//mosuser
object = mosMosuserResults.getObject(1);
if (null != object) {
vo.setMsInitiatedBy(object.toString());
}
//mosmisccom
object = mosMosmisccomResults.getObject(5);
if (null != object) {
vo.setCmntTxt(object.toString());
}
} catch (DataAccessException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return vo;
}
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public ResultSet getMosMosaddResults() {
return mosMosaddResults;
}
public void setMosMosaddResults(ResultSet mosMosaddResults) {
this.mosMosaddResults = mosMosaddResults;
}
public ResultSet getMosMospartResults() {
return mosMospartResults;
}
public void setMosMospartResults(ResultSet mosMospartResults) {
this.mosMospartResults = mosMospartResults;
}
public ResultSet getMosMosmiscResults() {
return mosMosmiscResults;
}
public void setMosMosmiscResults(ResultSet mosMosmiscResults) {
this.mosMosmiscResults = mosMosmiscResults;
}
public ResultSet getMosMosengResults() {
return mosMosengResults;
}
public void setMosMosengResults(ResultSet mosMosengResults) {
this.mosMosengResults = mosMosengResults;
}
public ResultSet getMosMosuserResults() {
return mosMosuserResults;
}
public void setMosMosuserResults(ResultSet mosMosuserResults) {
this.mosMosuserResults = mosMosuserResults;
}
public ResultSet getMosMosmisccomResults() {
return mosMosmisccomResults;
}
public void setMosMosmisccomResults(ResultSet mosMosmisccomResults) {
this.mosMosmisccomResults = mosMosmisccomResults;
}
