EL

本文详细介绍了Java Web应用程序的构建过程,包括实体类设计、Servlet处理逻辑及EL表达式的使用。通过创建Student和Course实体类,演示了如何在Servlet中设置属性,并在JSP页面上使用EL表达式来显示数据,同时展示了EL表达式的多种用法。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

package entity;

import java.io.Serializable;

public class Course implements Serializable {
    private Integer courseId;
    private String courseName;
    private Integer days;
    
    //对象属性:courseId
    //Bean属性:id
    public Integer getId() {
        return courseId;
    }
    public void setId(Integer courseId) {
        this.courseId = courseId;
    }
    public String getCourseName() {
        return courseName;
    }
    public void setCourseName(String courseName) {
        this.courseName = courseName;
    }
    public Integer getDays() {
        return days;
    }
    public void setDays(Integer days) {
        this.days = days;
    }

}

------------------------------------------------Student---------------------------------------------------------

 

package entity;

import java.io.Serializable;

public class Student implements Serializable {
            private String name;
            private  Integer age;
            private String sex;
            private String[] interests;
            private Course course;
            
            
            public String getName() {
                return name;
            }
            public void setName(String name) {
                this.name = name;
            }
            public Integer getAge() {
                return age;
            }
            public void setAge(Integer age) {
                this.age = age;
            }
            public String getSex() {
                return sex;
            }
            public void setSex(String sex) {
                this.sex = sex;
            }
            public String[] getInterests() {
                return interests;
            }
            public void setInterests(String[] interests) {
                this.interests = interests;
            }
            public Course getCourse() {
                return course;
            }
            public void setCourse(Course course) {
                this.course = course;
            }
            
    
    
}

---

---------------------------
---------------------------------------------------------------------DemoServlet-----------------

package web;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import entity.Course;
import entity.Student;

public class DemoServlet extends HttpServlet {

    @Override
    protected void service(HttpServletRequest req, 
            HttpServletResponse res) throws ServletException, IOException {
            //模拟查询学生数据
        Student s=new Student();
        s.setName("tian");
        s.setAge(18);
        s.setSex("f");
        s.setInterests(new String[] {"讲课","篮球","羽毛球"});
        Course c=new Course();
        c.setId(1);
        c.setCourseName("JAVA");
        c.setDays(80);
        s.setCourse(c);
        
        //转发到JSP
        //当前:/Jsp3/demo
        //目标: /Jsp3/demo.jsp
        req.setAttribute("stu", s);
        req.getRequestDispatcher("demo.jsp").forward(req, res);
        
    }
        
}
 

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

----------------------------------------------------web.xml-------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  <display-name>Jsp3</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
      <servlet>
          <servlet-name>demo</servlet-name>
          <servlet-class>web.DemoServlet</servlet-class>
      </servlet>
      <servlet-mapping>
          <servlet-name>demo</servlet-name>
          <url-pattern>/demo</url-pattern>
      </servlet-mapping>
  
</web-app>

-----------------------------------------------------------demo.jsp----------------------------------------

<%@page pageEncoding="utf-8"%>
<!doctype html>
<html>
<head>
    <meta charset="utf-8">
    <title>EL和JSTL</title>
</head>
    <body>
        <h1>EL</h1>
        <!-- EL用法1.获取Bean的属性 -->
        <!-- 下面代码相当于
        requset.getAttriibute("stu").getName() -->
        <p>姓名:${stu.name}</p>
        <p>年龄:${stu["age"]}</p>
        <!-- 下面代码相当于:requset.getAttribute("stu").
        getCourse().getId() -->
        <p>课程:${stu.course.id }</p>
        <!-- 2.进行运算 -->
        <p>年龄+5=:${stu.age+5 }</p>
        <p>年龄是否大于20?:${stu.age>20 }</p>
        <p>年龄介于10-20之间?${stu.age>10&&stu.age<20 }</p>
        <p>判断是否为空${empty stu }</p>
        <p>判空:${stu==null }</p>
        <!-- 3.获取请求参数 -->
        <p>参数:路径/demo?x=5:${param.x}</p>
        <!-- 4.EL从Bean中取值的规则 
              4.1默认从4个隐含对象(范围)中依次取值
              4.2这四个对象依次为
              page、request、session、application    
              4.3举例:
              有EL表达式${user},则EL按照如下规则取值
              首先看page.getAttribute("user")有没有
              然后request.getAttribute("user")
              其次session.getAttribute("user")
              最后application.getAttribute("user")
              4.4特例:若想打破该默认规则,希望从指定对象
              (范围)中取值,则需要指定时哪个对象:
              sessionScope.user-->
        <p>${requestScope.stu }</p>      
            
    </body>
</html>

 

我提供给你一段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、付费专栏及课程。

余额充值