sql文的编写

/* Define SQL */
   final String STR_SQL_STATE = "SELECT COUNT(T137.KANRI_NO1) "
     + "FROM TWMT137 T137,TWMT138 T138 "
     + ((null == ownBean.getTwmct11901bean().getStrSitukaCd()) ? ("")
       : (",TWMT118 T118 "))
     + "WHERE T137.KANRI_NO1 = T138.KANRI_NO "
     + "AND T137.SAGYO_NO = T138.JOUTAI_SAGYO_NO "
     + "AND T137.JOUTAI_CD IN('001', '006') "
     + ((null == ownBean.getTwmct11901bean().getStrSitukaCd()) ? ("")
       : ("AND T118.KANRI_NO = T137.KANRI_NO1 "))
     + ((null == ownBean.getTwmct11901bean().getStrSitukaCd()) ? ("")
       : ("AND T118.SYOKUBAN IN (SELECT T119.SYOKUBAN FROM TWMT119 T119 WHERE T119.SITUKA_CD = ? AND T119.DEL_ID IS NULL) "))
     + "AND T137.KANRI_NO1 LIKE 'T%' "
     + "AND T137.DEL_ID IS NULL "
     + "AND T138.DEL_ID IS NULL "
     + ((null == ownBean.getTwmct11901bean().getStrSitukaCd()) ? ("")
       : ("AND T118.DEL_ID IS NULL"));
   // ^^^ SQL定義：画面毎に実装（終了）^^^^^^^^^^^^^^
  
  
   /* Create SQL Statement */
   preStmt = ownConnection.prepareStatement(STR_SQL_STATE);
   if (null != ownBean.getTwmct11901bean().getStrSitukaCd()){
    preStmt.setString(1, ownBean.getTwmct11901bean().getStrSitukaCd());
   }
   /* executeQuery */
   rs = preStmt.executeQuery();