layui表格+ssm实现一对一查询并显示结果

效果图

数据库表设计

学生表

create table student(
   sid int primary key,---编号
   snum int,--学号
   sname varchar2(20), ---学生姓名
   simg varchar2(40),---学生头像
   spaffiliation varchar2(20), ---学生政治面貌
   sidentify varchar2(30),---身份证号
   siphone varchar2(20),---手机号
   semail varchar2(20),---邮箱
   ssex varchar2(20),---性别
   sbirthday date,---出生日期
   saddress varchar2(40),---学生家庭住址
   scollage varchar2(20),---所在学院
   sdepartment varchar2(30),---所在院系
   sclass varchar2(20),---所在班级
   sadmission date, --- 入校时间
   sgraduate date, ---毕业时间
   sidentityinfo varchar2(20) -- 身份
)

课程表

create table courseInfo(
 cid int primary key,
 cnum int,
 cname varchar(20),
 ccount varchar2(20),
 ctotaltime varchar2(20),
 courseStyle varchar2(20),
 ctime varchar2(20)
 
)

成绩表

create table stuFinalExam(
   seid int primary key,
   ssid int,
   ssnum int,
   ssname varchar2(20),
   ssclass varchar2(20),
   scourse int,
   sexamscore int,
   sexamstyle varchar2(20),
   steacher varchar2(20)
)

三表之间的联系

alter table stuFinalExam add constraint fk_stuFinalExam_ssid  foreign key(ssid) references student(sid);
alter table stuFinalExam add constraint fk_stuFinalExam_scourse  foreign key(scourse) references courseInfo(cid);

控制层

   @RequestMapping("/getStudentScoreAndPeosonInfoAndCourseInfo")
    @ResponseBody
    public ResultMap<List<Object>> GetStudentScoreAndPeosonInfoAndCourseInfo(HttpServletRequest request, HttpServletResponse response){
        System.out.println("即将获得所有信息");
        int page = Integer.parseInt(request.getParameter("page"));
        int limit = Integer.parseInt(request.getParameter("limit"));
        List<Object> ssclist = this.stuFinalExamService.getStuFinalExamScoreAndStuInfoAndCourseInfo(page,limit);
        for (int i = 0; i < ssclist.size(); i++) {
            System.out.println(ssclist.get(i));
        }
        int counts = this.stuFinalExamService.getStuFinalExamScoreAndStuInfoAndCourseInfoCounts();
        return  new ResultMap<List<Object>>("",ssclist,0,counts);
    }

bean层

 private Integer seid;
    private Integer ssid;
    private Integer ssnum;
    private String ssname;
    private String ssclass;
    private Integer scourse;
    private int sexamscore;
    private String sexamstyle;
    private String steacher;
    private Student student;
    private CourseInfo courseInfo;

注：get，set方法省略。。。。。。

mapper.xml配置一对一关系

<resultMap id="BaseResultMap" type="com.chinaedu.bean.StuFinalExam">
        <!--配置实体类和数据库表明之间的联系-->
        <result column="seid" property="seid" jdbcType="INTEGER" javaType="java.lang.Integer" />
        <result column="ssid" property="ssid" jdbcType="INTEGER" javaType="java.lang.Integer" />
        <result column="ssnum" property="ssnum" jdbcType="INTEGER" javaType="java.lang.Integer" />
        <result column="ssname" property="ssname" jdbcType="VARCHAR" javaType="java.lang.String" />
        <result column="ssclass" property="ssclass" jdbcType="VARCHAR" javaType="java.lang.String" />
        <result column="scourse" property="scourse" jdbcType="INTEGER" javaType="java.lang.Integer" />
        <result column="sexamscore" property="sexamscore" jdbcType="INTEGER" javaType="java.lang.Integer" />
        <result column="sexamstyle" property="sexamstyle" jdbcType="VARCHAR" javaType="java.lang.String" />
        <result column="steacher" property="steacher" jdbcType="VARCHAR" javaType="java.lang.String" />

        <!--配置关联属性-->
        <association property="student" column="ssid" jdbcType="INTEGER"  javaType="com.chinaedu.bean.Student">
            <result column="sid" property="sid" jdbcType="INTEGER" javaType="java.lang.Integer" />
            <result column="snum" property="snum" jdbcType="INTEGER" javaType="java.lang.Integer" />
            <result column="sname" property="sname" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="simg" property="simg" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="spaffiliation" property="spaffiliation" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="sidentify" property="sidentify" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="siphone" property="siphone" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="semail" property="semail" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="ssex" property="ssex" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="sbirthday" property="sbirthday" jdbcType="DATE" javaType="java.util.Date" />
            <result column="saddress" property="saddress" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="scollage" property="scollage" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="sdepartment" property="sdepartment" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="sclass" property="sclass" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="sadmission" property="sadmission" jdbcType="DATE" javaType="java.util.Date" />
            <result column="sgraduate" property="sgraduate" jdbcType="DATE" javaType="java.util.Date" />
            <result column="sidentityinfo" property="sidentityinfo" jdbcType="VARCHAR" javaType="java.lang.String" />
        </association>
        <association property="courseInfo" column="scourse"  jdbcType="INTEGER" javaType="com.chinaedu.bean.CourseInfo">
            <result column="cid" property="cid"  jdbcType="INTEGER" javaType="java.lang.Integer" />
            <result column="cnum" property="cnum" jdbcType="INTEGER" javaType="java.lang.Integer" />
            <result column="cname" property="cname" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="ccount" property="ccount" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="ctotaltime" property="ctotaltime" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="courseStyle" property="courseStyle" jdbcType="VARCHAR" javaType="java.lang.String" />
            <result column="ctime" property="ctime" jdbcType="VARCHAR" javaType="java.lang.String" />
        </association>
    </resultMap>

layui页面表格

{
            field: 'snum',
            title: '学生学号',
            width: 100,
            templet:function(data){return data.student.snum;}