斷點

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

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

          Posted on 2010-01-14 20:57 斷點 閱讀(428) 評論(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)
          主站蜘蛛池模板: 雅安市| 洛浦县| 五家渠市| 疏勒县| 德庆县| 平安县| 贵阳市| 正定县| 江孜县| 横峰县| 社旗县| 阳新县| 肇东市| 阿克陶县| 军事| 米易县| 平阴县| 阿瓦提县| 黄梅县| 清水河县| 长兴县| 九龙坡区| 藁城市| 杭州市| 鹤山市| 彰化市| 邢台市| 九龙城区| 靖江市| 施甸县| 石阡县| 太谷县| 新巴尔虎右旗| 石河子市| 屏边| 托里县| 江川县| 开平市| 东明县| 朝阳市| 藁城市|