Java开发学习(8)

人事管理系统从无到有7
EL表达式
EL表达式是一种JSP技术，能够代替JSP中原本要用Java语言进行显示的语句，使得代码更容易编写与维护。$表达式\ast \ast 执行运算\ast \ast 1.语法：${运算表达式}

2.常见运算符：==(eq) !=(ne) <(lt) >(gt) <=(le) >=(ge) &&(and) ||(or) !(not)

3.判断是否为空：${empty name }

4.三目运算符：${name == null?“null”:name }

今天分页出问题了 搞了一天，叫了个大哥帮忙看看，大哥这牛逼。
` public Pager paginate(int page, int pageSize, Dept dept) {
Pager pager =new Pager();
pager.setPageSize(pageSize);
pager.setPage(page);

    String sql = "SELECT COUNT(*) AS have FROM dept ";
    StringBuilder _where = new StringBuilder(" WHERE 1=1");
    List<Object> params = new ArrayList<>();
    if(dept != null){
        if(dept.getDeptname() != null && !"".equals(dept.getDeptname())){
            _where.append(" AND deptname LIKE ? ");
            params.add("%" +dept.getDeptname() + "%");
        }
        if(dept.getDeptmg() != null && !"".equals(dept.getDeptmg())){//主管名
            _where.append(" AND deptmg LIKE ? ");
            params.add("%" +dept.getDeptmg()+ "%");
        }
    }
    Connection conn = null;
    try {
        conn =MySqlDbUtil.getConnect();
        PreparedStatement pst = conn.prepareStatement(sql + _where.toString());
        for(int i=0; i<params.size();i++){
            pst.setObject(i+1,params.get(i));
        }
       ResultSet rs =pst.executeQuery();
        rs.next();
        int count = rs.getInt("have");
        rs.close();
        pst.close();

        pager.setRows(count);

        sql = "SELECT * FROM dept";
        pst = conn.prepareStatement(sql + _where.toString() +" LIMIT ?,?");
        int index =0;
        for(int i=0; i<params.size();i++){
            index ++;
            pst.setObject(i+1,params.get(i));
        }
        pst.setInt(++index  ,(pager.getPage()-1)*pager.getPageSize());
       pst.setInt(++index,pager.getPageSize());
      rs = pst.executeQuery();
      List<Object> depts =new ArrayList<>();
        while(rs.next()){
            Dept dept1 = new Dept();
            dept1.setDeptno(rs.getInt("deptno"));
            dept1.setDeptname(rs.getString("deptname"));
            dept1.setDeptloc(rs.getString("deptloc"));
            dept1.setDeptmg(rs.getString("deptmg"));

            depts.add(dept1);
        }
        pager.setData(depts);
        rs.close();
        pst.close();
        conn.close();

    } catch (Exception e) {
        e.printStackTrace();
    }

    return pager;
}`

WHERE 1=1前面要加空格。
rs.next();改了
++index改了

问题：<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
加上此标签后分页的导航条全部消失了。。 跳过