c134b2da3a2e1287588da19e963d74f8be84e210.svn-base 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package xin.glue.ui.B.B02.O1;
  2. import java.sql.CallableStatement;
  3. import com.posdata.glue.biz.activity.PosActivity;
  4. import com.posdata.glue.biz.constants.PosBizControlConstants;
  5. import com.posdata.glue.context.PosContext;
  6. import com.posdata.glue.dao.PosGenericDao;
  7. import com.posdata.glue.dao.vo.PosParameter;
  8. import com.posdata.glue.dao.vo.PosRow;
  9. import com.posdata.glue.dao.vo.PosRowSet;
  10. public class SaveCretNoTOZB extends PosActivity
  11. {
  12. public String runActivity(PosContext context)
  13. {
  14. String[]CRET_NO = (String[])context.get("CRET_NO");
  15. PosGenericDao dao = this.getDao("mesdao");
  16. PosParameter param = new PosParameter();
  17. CallableStatement cstm = null;
  18. //
  19. // param.setValueParamter(0, CRET_NO[0]);
  20. // dao.insert("UIB021100_02.INSERT", param);
  21. try
  22. {
  23. cstm = dao.getCallableStatement("UIB021100_01.CALL");
  24. cstm.setString(1, CRET_NO[0]);//×¢Ò⣬ÐòºÅ´Ó1¿ªÊ¼
  25. cstm.registerOutParameter(2, java.sql.Types.VARCHAR);
  26. cstm.execute();
  27. // PosRowSet rowSet1 = mesdao.findByQueryStatement(selectTransL3);
  28. // while(rowSet1.hasNext()){
  29. //
  30. // param1 = new PosParameter();
  31. //
  32. // PosRow row1 = rowSet1.next();
  33. // row1.get
  34. // }
  35. }catch(Exception ex)
  36. {
  37. }
  38. return PosBizControlConstants.SUCCESS;
  39. }
  40. }