MAXIMO中调用SQL

 

Date currentDate = ((AppService) getMboServer()).getMXServer().getDate();

String currdate=DateUtil.SqlDateToString(currentDate);

String personid=ui.getPersonId();

String month =DateUtil.getDayOfMonth(currentDate)+"";

String year = DateUtil.getDayOfYear(currentDate)+"";

  String sql=""

  +"insert into carrfor(location,itemnum,binnum,lotnum,curbal,itemsetid,siteid,orgid,unitcost,currencycode,yinvoice,confirmcostdate,"

  +"carrforid,hasld,createby,createdate,changeby,changedate,cfdate,month,year)"

  +"select a.location,a.itemnum,a.binnum,a.lotnum,a.curbal,a.itemsetid,a.siteid,a.orgid,b.unitcost,b.currencycode,b.yoninvoice,b.confirmcostdate," 

  +"carrforidseq.nextval,1,'"+personid+"',to_date('"+currdate+"','yyyy-mm-dd hh24:mi:ss