el

EL表达式详解

JSP 页面中,使用标签库代替传统的 Java 片段语言来实现页面的显示逻辑已经不是新技术了,然而,由自定义 标签很容易造成重复定义和非标准的实现。鉴于此,出现了 JSTL JSP Standard Tag Library )。大多数 JSP 页面逻辑提供了实现的 JSTL 技术,该技术本身就是一个标签库。

Sun 公司 Java 规范标准的 JSTL apache jakarta 组织负责维护。作为开源的标准技术,它一直在不断地完善。 JSTL 的发布包有两个版本: Standard-1.0 Taglib Standard-1.1 Taglib ,它们在使用时是不同的。

q         Standard-1.0 Taglib JSTL1.0 )支 持 Servlet2.3 JSP1.2 规范, Web 应用服务器 Tomcat4 支持这些规范,而它的发布也在 Tomcat 4.1.24 测试通过了。

q         Standard-1.1 Taglib JSTL1.1 )支 持 Servlet2.4 JSP2.0 规范, Web 应用服务器 Tomcat5 支持这些规范,它的发布在 Tomcat 5.0.3 测试通过了。

在本章的介绍中,将以由 Sun 发布的 Standard-1.1 Taglib 标签库为主,而 apache jakarta 组织发布的开源标签库,可以从 http://jakarta.apache.org/taglibs/ 找到所需要的帮助。 Sun 发布的标准 JSTL1.1 标签库有以下几个标签:

q         核心标签库:包含 Web 应用的常见工作,比如:循环、表达式赋值、基本输入输出等。

q         国际化标签库:用来格 式化显示数据的工作,比如:对不同区域的日期格式化等。

q         数据库标签库:可以做 访问数据库的工作。

q         XML 标 签库:用来访问 XML 文 件的工作,这是 JSTL 标 签库的一个特点。

q         函数标签库:用来读取 已经定义的某个函数。

此外, JSTL 还提供了 EL 表达式语言( Expression Language )来进行辅助的工作。

JSTL 标签 库由标 签库和 EL 表达式语言两个部分组成。 EL JSTL 1.0 规范中被引入,当时用来作为 Java 表达式来工作,而该表达式必须配合 JSTL 的标签库才能得到需要的结果。

说明:在 JSTL 1.1 规范中, JSP2.0 容器已经能够独立的理解任何 EL 表达式。 EL 可 以独立出现在 JSP 页面的任何角落。本文随后的内容将以 JSTL 1.1 规范作为介绍的重点。

 JSTL EL 表达式语言简介

EL 是从 JavaScript 脚本语言得到启发的一种表达式语言,它借鉴了 JavaScript 多类型转换无关性的特点。在使用 EL scope 中得到参数时可以自动转换类型,因此对于类型的限制更加宽松。 Web 服务器对于 request 请求参数通常会以 String 类型来发送,在得到时使用的 Java 语言脚本就应该是 request.getParameter(“XXX”) ,这样的话,对于实际应用还必须进行 强制类型转换。而 EL 就 将用户从这种类型转换的繁琐工作脱离出来,允许用户直接使用 EL 表达式取得的值,而不用关心它是什么类型。

下面的示例就是一个 EL 表达式,见例 1

1 :简单 EL 表达式

 

<% @ page contentType = " text/html; charset=UTF-8 " %>  

<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" >  

< html >  

 
< body >  

    ${sampleValue + 1} 
< br >  

 
</ body >  

</ html >  

 

这个示例将在 JSP 页面显示为“ 1 ”, EL 表达式必须以“ ${XXX} ”来表示,其中“ XXX ”部分就是具体表达式内容,“ ${} ”将这个表达式内容包含在其中作为 EL 表达式的定义。本示例可以在满足 JSP2.0 规范的任何 Web 应用服务器中使用。

 EL 表达式的默认变量

一个 EL 表达式包含变量和操作符两个内容。任何存在于 JSP 作用范围的 JavaBean 都可以被转化成 EL 表达式来使用,它所包含的默认变量如下:

1 .默认变量 pageScope requestScope sessionScope applicationScope

4 个默认变量包含 Scope 作用范围的参数集合,相当于被保存在 java.util.Map 中的某个参数。下面看简单的示例 2

2 :使用 sessionScope 变量的 EL 表达式

 

<% request.getSession().setAttribute( " sampleValue " new   Integer ( 10 )); %>  

${sessionScope.sampleValue} 

 

取得保存在 Session 中参数的 sessionScope 变量的 EL 表达式,“ . ”是 property 访问操作符,在这里表示从 Session 中取得“键”为“ sampleValue ”的参数,并显示出来。显示结果为“ 10 ”。

2 .默认变量 param paramValues

这两个默认变量包含请求参数的集合, param 表明请求包含的参数为单一控件, paramValues 表明请求包含的参数为控件数组。下面看一个简单示例 3

3 :提交请求的页面和接受的页面

<% @ page contentType = " text/html; charset=UTF-8 " %>  

<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" >  

< html >  

 
< body >  

      
< form  action ="SampleJsp.jsp" >  

    
< input  type ="text"  name ="sampleValue"  value ="10" >  

    
< input  type ="text"  name ="sampleValue"  value ="11" >  

    
< input  type ="text"  name ="sampleValue"  value ="12" >  

    
< input  type ="text"  name ="sampleSingleValue"  value ="SingleValue" >  

    
< input  type ="submit"  value ="Submit" >  

    
</ form >  

 
</ body >  

</ html >  

 

在这个页面中定义了两组控件,控件名为“ sampleValue ”的是一套控件数组,控件名为“ sampleSingleValue ”的是单一控件,通过递交将请求参数 传送到 SampleJsp.jsp

<%@ page contentType="text/html; charset=UTF-8"%>

 

<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" >  

< html >  

 
< body >  

    ${paramValues.sampleValue[2]} 
< br >  

    ${param.sampleSingleValue} 
< br >  

 
</ body >  

</ html >  

 

这是请求转发到的页面,通过 EL 表达式的 paramValues 变量得到控件数组中最后一个控件的递交参数,通过 EL 表达式的 param 变量得到单一控件的递交参数。控件数组参数的 EL 表达式使用“ [] ”来指定数组下标。本示例 将显示控 件数组中最后一个控件的值“ 12 ” 和单一控件的值“ SingleValue ”。

3 .默认变量 header headerValues

这两个默认变量包含请求参数头部信息的集合, header 变量表示单一头部信息, headerValues 则表示数组型的头部信息。

4 .默认变量 cookie

包含所有请求的 cookie 集合,集合中的每个对象对应 javax.servlet.http.Cookie

5 .默认变量 initParam

包含所有应用程序初始化参数的集合。

6 .默认变量 pageContext

等价于 page 环境类 javax.servlet.jsp.PageContext 的实例,用来提供访问不同的请求参 数。

11 个默认变量 几乎包含 了 Web 应用的所有基本操作,若一个表达式 不使用 这些变量而直接使用参数 名,那么 就采用就近原则。该表达式将使用最近取得的参数值。

三.EL表达 式的操作符

EL 表达式中还有许多操作符可以帮助完成各种所需的操作,之前的示例中“ . ”、“ [] ”就是其中的两个,下面将用表 9.1 来展示所有操作符及它们各自的功能。

9.1 EL 表达式的操作符

操作符

功能和作用

.

访问一个 bean 属性或者 Map entry

[]

访问一个数组或者链表元素

()

对子表达式分组,用来改变赋值顺序

? :

条件语句,比如:条件 ?ifTrue:ifFalse

如果条件为真,表达式值为前者,反之为后者

+

数学运算符,加操作

-

数学运算符,减操作或者对一个值取反

*

数学运算符,乘操作

/ div

数学运算符,除操作

% mod

数学运算符,模操作 ( 取余 )

== eq

逻辑运算符,判断符号左右两端是否相等,如果相等返回 true ,否则返回 false

!= ne

逻辑运算符,判断符号左右两端是否不相等,如果不相等返回 true ,否则返回 false

< lt

逻辑运算符,判断符号左边是否小于右边,如果小于返回 true ,否则返回 false

> gt

逻辑运算符,判断符号左边是否大于右边,如果大于返回 true ,否则返回 false

<= le

逻辑运算符,判断符号左边是否小于 或者等于 右边,如果小于或者等于返回 true ,否则返回 false

>= ge

逻辑运算符,判断符号 左边是否 大于或者等于右边,如果大于或者等于返回 true ,否则返回 false

&& and

逻辑运算符,与操作赋。如果左右两边同为 true 返回 true ,否则返回 false

|| or

逻辑运算符,或操作赋。如果左右两边有任何一边为 true 返回 true ,否则返回 false

! not

逻辑运算符,非操作赋。如果对 true 取运算返回 false ,否则返回 true

empty

用来对一个空变量值进行判断 : null 、一个空 String 、空数组、 Map 、没有条目的 Collection 集合

func(args)

调用方法 , func 是方法名, args 是参数,可以没有,或者有一个、多个参数 . 参数间用逗号隔开

这些操作符都是极其有用的,下面通过几个示例来演示它们的使用方 法:

4 :几组操作符 的示例

 

${pageScope.sampleValue + 12}  < br >            // 显示 12 

${(pageScope.sampleValue + 12)/3} 
< br >      // 显示 4.0 

${(pageScope.sampleValue + 12) /3==4} 
< br >          // 显示 true 

${(pageScope.sampleValue + 12) /3>=5} 
< br >          // 显示 false 

< input  type ="text"  name ="sample1"  value ="${pageScope.sampleValue + 10}" >  // 显示值为 10 的 Text 控件 

 

可以看到,对于这些示例,程序设计者完全无需管理它们的类型转 换,在表达式内部都已经处理了。有了 EL 表达式,在 JSP 页 面的编程变得更灵活,也更容易。

 

 

------------------------------------

总结如下

1. 取值形式:  ${}

2. 属性访问:  .或者[];当属性名为变量或含有特殊字符必须用[]进行访问,如:${bean[a-b]}

3. 默认变量:  page/request/session/application/param/paramValues/header/headerValues/cookie/initParam/pageContext

4. 运算符:    略

我提供给你一段sql,你需要修改一下,要求是所有关于查询el_requirement_apply和el_comp_info表的语句均需要增加del_flag = '0'的条件,修改完成后你需要将完整的代码返回给我,完整的sql如下: SELECT gen_random_uuid() AS id, (( SELECT count(1) AS count FROM el_comp_info WHERE ((substr((el_comp_info.unified_code)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_comp_info.unified_code)::text = (feiminying.uniscid)::text)))) AND ((el_comp_info.del_flag)::text = '0'::text) AND ((el_comp_info.audit_status)::text = 'AUDITED'::text))))::numeric AS registeredenterprisenum, COALESCE(( SELECT count(1) AS count FROM el_granting_credit, el_financial_institution, el_requirement_apply WHERE (((el_requirement_apply.id)::text = (el_granting_credit.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS creditenterprisenum, COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS loanenterprisenum, COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS loanmicroenterprisenum, COALESCE(( SELECT sum(el_granting_credit.granting_amount) AS sum FROM el_granting_credit, el_financial_institution, el_requirement_apply WHERE (((el_requirement_apply.id)::text = (el_granting_credit.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS creditamount, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_requirement_apply, el_financial_institution WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS loanamount, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_requirement_apply, el_financial_institution WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS inclusivemicroenterpriseloanamount, COALESCE(( SELECT count(1) AS count FROM el_loan_grant, el_requirement_apply, el_financial_institution WHERE (((el_requirement_apply.id)::text = (el_loan_grant.apply_id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS loannum, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS creditloanamount, COALESCE(( SELECT count(1) AS count FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS creditloannum, COALESCE(( SELECT sum(el_requirement_info.amount) AS sum FROM el_requirement_info, el_requirement_apply, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text))), (0)::numeric) AS financingneedsamount, COALESCE(( SELECT count(1) AS count FROM el_requirement_info, el_requirement_apply, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_financial_institution.id)::text = (el_requirement_apply.institution_id)::text))), (0)::bigint) AS financingneedsnum, COALESCE(( SELECT trunc(avg(to_number((el_loan_grant.loan_rate)::text, '0.00'::text)), 2) AS trunc FROM el_loan_grant, el_requirement_apply WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))))), (0)::numeric) AS averagelendingrate, COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.user_id)::text = (el_loan_grant.create_by)::text))), (0)::bigint) AS monthloanenterprisenum, COALESCE(( SELECT count(1) AS count FROM el_user_info rr, el_financial_institution tt WHERE (((rr.id)::text = (tt.user_id)::text) AND ((rr.user_type)::text = 'FI'::text) AND ((tt.parent_id)::text <> '-1'::text))), (0)::bigint) AS settledinfinancialinstitutionnum, COALESCE(( SELECT count(1) AS count FROM el_financial_product, el_financial_institution WHERE ((el_financial_product.create_by)::text = (el_financial_institution.user_id)::text)), (0)::bigint) AS financialproductsnum, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_financial_institution, el_requirement_apply WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthloanamount, COALESCE(( SELECT count(1) AS count FROM el_loan_grant, el_financial_institution, el_requirement_apply WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS monthloannum, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthcreditloanamount, COALESCE(( SELECT count(1) AS count FROM el_loan_grant, el_requirement_info, el_financial_institution WHERE ((substr((el_requirement_info.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_info.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::bigint) AS monthcreditloannum, COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum FROM el_loan_grant, el_requirement_apply, el_financial_institution WHERE (((el_loan_grant.apply_id)::text = (el_requirement_apply.id)::text) AND (substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)) AND ((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text))), (0)::numeric) AS monthinclusivemicroenterpriseloanamount, COALESCE(( SELECT sum(el_requirement_info.amount) AS sum FROM el_requirement_info, el_requirement_apply, el_financial_institution WHERE ((substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthfinancingneedsamount, COALESCE(( SELECT count(1) AS count FROM el_requirement_info, el_requirement_apply, el_financial_institution WHERE ((substr((el_requirement_apply.unisc_id)::text, 0, 3) = '91'::text) AND ( (EXISTS ( SELECT 1 from (select unified_code as uniscid from el_comp_info where private_enterprises = 'Y') feiminying WHERE ((el_requirement_apply.unisc_id)::text = (feiminying.uniscid)::text)))) AND ((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::bigint) AS monthfinancingneedsnum, '2023-06-20 08:00:00'::text AS statisticsbegintime, now() AS statisticsendtime
07-26
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值