springboot+vue+mybatisplus项目实战-学生成绩管理系统04

Mapper

scoreMapper.java

package com.shrimpking.mapper;

import com.shrimpking.pojo.Score;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 * 成绩表 Mapper 接口
 * </p>
 *
 * @author shrimpking
 * @since 2023-11-04
 */
public interface ScoreMapper extends BaseMapper<Score> {

}

studentMapper.java

package com.shrimpking.mapper;

import com.shrimpking.pojo.Student;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 * 学生表 Mapper 接口
 * </p>
 *
 * @author shrimpking
 * @since 2023-11-04
 */
public interface StudentMapper extends BaseMapper<Student> {

}

userMapper.java

package com.shrimpking.mapper;

import com.shrimpking.pojo.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 * 用户表 Mapper 接口
 * </p>
 *
 * @author shrimpking
 * @since 2023-11-04
 */
public interface UserMapper extends BaseMapper<User> {

}

Mapper.xml

scoreMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.shrimpking.mapper.ScoreMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.shrimpking.pojo.Score">
        <id column="id" property="id" />
        <result column="student_id" property="studentId" />
        <result column="exam_name" property="examName" />
        <result column="score_cn" property="scoreCn" />
        <result column="score_en" property="scoreEn" />
        <result column="socre_math" property="socreMath" />
        <result column="is_deleted" property="isDeleted" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, student_id, exam_name, score_cn, score_en, socre_math, is_deleted
    </sql>

</mapper>

studentMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.shrimpking.mapper.StudentMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.shrimpking.pojo.Student">
        <id column="id" property="id" />
        <result column="number" property="number" />
        <result column="real_name" property="realName" />
        <result column="enroll_time" property="enrollTime" />
        <result column="is_deleted" property="isDeleted" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, number, real_name, enroll_time, is_deleted
    </sql>

</mapper>

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.shrimpking.mapper.UserMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.shrimpking.pojo.User">
        <id column="id" property="id" />
        <result column="user_name" property="userName" />
        <result column="pwd" property="pwd" />
        <result column="is_deleted" property="isDeleted" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, user_name, pwd, is_deleted
    </sql>

</mapper>