信息及详细信息的展示
本篇博客主要实现信息及用户信息详情的展示,也就是说将一个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