Guest User

Untitled

a guest
Jan 29th, 2019
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. <insert id="registerNewPenalty" parameterType="TbAdhPenaltyTreatVO">
  2. INSERT INTO
  3. TB_ADH_PENALTYTREAT
  4. VALUES (
  5. (
  6. SELECT
  7. TO_CHAR(NVL(MAX(HISTNO), 0) + 1) AS MAXSEQ
  8. FROM
  9. TB_ADH_PENALTYTREAT
  10. ),
  11. #{penaltytpcd, jdbcType=VARCHAR},
  12. #{regdt, jdbcType=DATE},
  13. #{occurdt, jdbcType=DATE},
  14. #{runvioltpcd, jdbcType=DATE},
  15. #{compid, jdbcType=INTEGER},
  16. #{routeid, jdbcType=INTEGER},
  17. #{busid, jdbcType=INTEGER},
  18. 'bmscenter',
  19. NULL,
  20. #{treat_detail, jdbcType=VARCHAR},
  21. '0'
  22. )
  23. </insert>
  24.  
  25. public class TbAdhPenaltyTreatVO {
  26. private String histno; // NUMBER(10,0) Yes 1
  27. private String penaltytpcd; // VARCHAR2(1 BYTE) Yes 2
  28. private String regdt; // DATE Yes 3
  29. private String occurdt; // DATE Yes 4
  30. private String runvioltpcd; // VARCHAR2(2 BYTE) Yes 5
  31. private String compid; // NUMBER(6,0) Yes 6
  32. private String routeid; // NUMBER(9,0) Yes 7
  33. private String busid; // NUMBER(9,0) Yes 8
  34. private String treat_userid; // VARCHAR2(20 BYTE) Yes 9
  35. private String treat_orgnm; // VARCHAR2(20 BYTE) Yes 10
  36. private String treat_detail; // VARCHAR2(100 BYTE) Yes 11
  37. private String treatyn; // VARCHAR2(1 BYTE) Yes 12
  38.  
  39.  
  40. ... getters and setters below
  41.  
  42. INSERT INTO tb_adh_penaltytreat
  43. VALUES (1,
  44. '1',
  45. SYSDATE,
  46. To_date('2017/11/02 04:40:47', 'YYYY/MM/DD HH24:MI:SS'),
  47. '13',
  48. '164003',
  49. '165000310',
  50. '7012268',
  51. 'bmscenter',
  52. NULL,
  53. '......',
  54. '0');
  55.  
  56. [2019-01-29 16:03:17] DEBUG: org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
  57. [2019-01-29 16:03:17] DEBUG: org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@777f6077]
  58. [2019-01-29 16:03:17] DEBUG: org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [jdbc:oracle:thin:@10.10.10.20:1521:orcl, UserName=ICBIS_AGO, Oracle JDBC driver] will be managed by Spring
  59. [2019-01-29 16:03:17] DEBUG: PENALTY.registerNewPenalty - ==> Preparing: INSERT INTO TB_ADH_PENALTYTREAT VALUES ( ( SELECT TO_CHAR(NVL(MAX(HISTNO), 0) + 1) AS MAXSEQ FROM TB_ADH_PENALTYTREAT ), ?, ?, ?, ?, ?, ?, ?, 'bmscenter', NULL, ?, '0' )
  60. [2019-01-29 16:03:17] DEBUG: PENALTY.registerNewPenalty - ==> Parameters: 1(String), null, 2017-11-02 05:54:35.0(String), 13(String), 166012(String), 165000067(String), 7016047(String), this is for test.(String)
  61. [2019-01-29 16:03:17] DEBUG: org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@777f6077]
Add Comment
Please, Sign In to add comment