斷點

          每天進步一點點!
          posts - 174, comments - 56, trackbacks - 0, articles - 21

          項目開發中常用到的sql語句

          Posted on 2010-01-14 20:57 斷點 閱讀(433) 評論(0)  編輯  收藏 所屬分類: Java

          1.

          String hqlBase = " from AppBaseVO t where t.CAppNo ='" + CAppNo + "'";
                          rsList = this.commonDao.find(hqlBase);
                         
                          for(AppBaseVO rt : rsList){//只有一條數據。
                              baseCBrkrCde = rt.getCBrkrCde();
                              String hqlCusCha = " from CusChaVO t where t.CChaCde ='" + baseCBrkrCde + "'";
                              rsCusCha = this.commonDao.find(hqlCusCha);
                              for(CusChaVO rtCusCha : rsCusCha){//一條數據。
                                  name = rtCusCha.getCChaNme();
                              }
                          }

          --------------------------------------
          2.

          public Map<String, String> querySelectList(String str) throws DaoException {
                  List list = new ArrayList();
                  Map<String, String> map = new HashMap<String, String>();
                  try {
                      String sSQL = " FROM AbstractBaseVO  where  CPlyNo=?";
                      list = super.find(sSQL, str);

           

                StringBuffer hql = new StringBuffer();
                          hql.append(" FROM InqCreditIndivAuditVO");            
                          hql.append(" WHERE CExamMark = '1' ");   // 個人客戶,'1'為審核通過。
                          hql.append(" AND  CInqNo = ? ");
                          list2 = super.find(hql.toString(),CInqNo);


          super.search語句用問號。
          ---------------------------------------
           3.

          String CCoinsurerCde = map.get("CCoinsurerCde");
                      String sql = "SELECT C_SELF_MRK FROM WEB_RI_COM WHERE C_COM_CDE=?";
                      SQLPara sqlPara = new SQLPara();
                      sqlPara.add(CCoinsurerCde);
                      RowSet rs = this.commonDao.queryNativeSQL(sql, sqlPara, false);

                      boolean selfFlag = false;
                      while (rs.next()) {
                          String sCSelfMrk = rs.getString(1);
                          if ("1".equals(sCSelfMrk)) {
                              selfFlag = true;
                              break;
                          }
                      }
          -----------------------------------------
          4.

          List<PlyBaseVO> plyNo = this.find("FROM PlyBaseVO WHERE CAppNo = '" + appNo + "'");
                              if(plyNo.size() > 0 ){
             }


          posted @ 2009-11-25 14:28 斷點 閱讀(12) | 評論 (0)
          主站蜘蛛池模板: 永平县| 交口县| 堆龙德庆县| 赤峰市| 门头沟区| 潼南县| 永和县| 应城市| 丹寨县| 普格县| 龙里县| 乐山市| 滦平县| 乌拉特中旗| 林甸县| 闽侯县| 永清县| 聂荣县| 安丘市| 前郭尔| 镇远县| 闵行区| 阿鲁科尔沁旗| 临城县| 庆阳市| 青浦区| 宝兴县| 湘西| 丰县| 社旗县| 乐山市| 彭阳县| 陆河县| 六盘水市| 舟山市| 丰顺县| 新化县| 聊城市| 衡阳县| 孝感市| 云和县|