08b2cbf35fdf5b8c80aba469e7bbd357ccf229f9.svn-base 853 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?xml version="1.0" encoding='UTF-8'?>
  2. <queryMap desc="STEEL MAKING QUERY ">
  3. <query id="UIG010041_LD_INIT.insert" desc=" 包号查询 " fetchSize="10">
  4. <![CDATA[
  5. INSERT INTO TBG03_LADLE_PROG
  6. (
  7. LD_NO
  8. ,LD_EMP_WGT
  9. ,LD_CYC_CNT_LIMIT
  10. ,LD_GRADE
  11. ) VALUES (
  12. ?
  13. ,?
  14. ,?
  15. ,?
  16. )
  17. ]]>
  18. </query>
  19. <query id="UIG010041_LD_INIT.update" desc=" 包号查询 " fetchSize="10">
  20. <![CDATA[
  21. UPDATE TBG03_LADLE_PROG SET
  22. LD_EMP_WGT = ?
  23. , LD_CYC_CNT_LIMIT = ?
  24. , LD_GRADE = ?
  25. WHERE LD_NO = ?
  26. ]]>
  27. </query>
  28. <query id="UIG010041_INIT_select" desc=" 包号查询 " fetchSize="10">
  29. <![CDATA[
  30. SELECT LD_NO
  31. ,LD_EMP_WGT
  32. ,LD_CYC_CNT_LIMIT
  33. ,LD_GRADE
  34. FROM TBG03_LADLE_PROG
  35. WHERE LD_NO LIKE ? ||'%'
  36. ]]>
  37. </query>
  38. </queryMap>