Springboot+easyUI分栏展示数据库信息及详细信息

信息及详细信息的展示

      本篇博客主要实现信息及用户信息详情的展示，也就是说将一个frame分成两部分，左边一部分显示数据库中的信息，右边一部分显示详细信息（也就是你点击左边一部分时，右边会通过获取左边选中行中的一个属性，作为查询的条件去数据库中另一张表进行检索。）

介绍

      数据库中的表信息如下所示：

表一 教学评价表

表二 教学评价教师信息表

表三 教学评价信息视图

教学评价信息视图语句

mapper代码

@Select("select count(*) from teaching_evaluate")
    public int getTeachingEvaluateNumber();

    @Select("select * from teaching_evaluate limit #{startRecord},#{pageSize}")
    public List<Teaching_Evaluate> getTeachingEvaluateinfoByPage(@Param("startRecord")int startRecord,@Param("pageSize")int pageSize);

    @Select("select count(*) from teachingevaluate where evaluateNo=#{evaluateNo}")
    public int getTeachingEvaluateListNumberByTno(@Param("evaluateNo") String evaluateNo);

    @Select("select evaluate_no from teaching_evaluate limit 1")
    public String getTeachingEvaluateFirstTrainNo();


    @Select("select * from teachingevaluate  where evaluateNo=#{evaluateNo}  limit #{startRecord},#{pageSize}")
    public List<TeachingEvaluate> getTeachingEvaluateListByTnoByPage(@Param("evaluateNo") String evaluateNo,@Param("startRecord")int startRecord,@Param("pageSize")int pageSize);

service代码

  public int getTeachingEvaluateNumber(){
        return managemapper.getTeachingEvaluateNumber();
    }

    public List<Teaching_Evaluate> getTeachingEvaluateinfoByPage(int startRecord,int pageSize){
        return managemapper.getTeachingEvaluateinfoByPage(startRecord, pageSize);
    }

    public int getTeachingEvaluateListNumberByTno(String evaluateNo){
        return managemapper.getTeachingEvaluateListNumberByTno(evaluateNo);
    }

    public String getTeachingEvaluateFirstTrainNo(){
        return managemapper.getTeachingEvaluateFirstTrainNo();
    }

    public List<TeachingEvaluate> getTeachingEvaluateListByTnoByPage