1、项目开发中常用到的 sql 语句 Posted on 2010-01-14 20:57 断点 阅读(73) 评论(0) 编辑 收藏 所属分类: Java 1.String hqlBase = “ from AppBaseVO t where t.CAppNo =“ + CAppNo + “;rsList = monDao.find(hqlBase);for(AppBaseVO rt : rsList)/只有一条数据。baseCBrkrCde = rt.getCBrkrCde();String hqlCusCha = “ from CusChaVO t where t.CChaCde =“ +
2、baseCBrkrCde + “;rsCusCha = monDao.find(hqlCusCha);for(CusChaVO rtCusCha : rsCusCha)/一条数据。name = rtCusCha.getCChaNme();-2.public Map querySelectList(String str) throws DaoException List list = new ArrayList();Map map = new HashMap();try String sSQL = “ FROM AbstractBaseVO where CPlyNo=?“;list = supe
3、r.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
4、 sql = “SELECT C_SELF_MRK FROM WEB_RI_COM WHERE C_COM_CDE=?“;SQLPara sqlPara = new SQLPara();sqlPara.add(CCoinsurerCde);RowSet rs = monDao.queryNativeSQL(sql, sqlPara, false);boolean selfFlag = false;while (rs.next() String sCSelfMrk = rs.getString(1);if (“1“.equals(sCSelfMrk) selfFlag = true;break;-4.List plyNo = this.find(“FROM PlyBaseVO WHERE CAppNo = “ + appNo + “);if(plyNo.size() 0 )
