Spring+Spring MVC+MyBatis-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_48578877/article/details/127235267

Spring+Spring MVC+MyBatis

在这里插入图片描述

1.创建数据库

#clazz班级
#course课程
#holder职位
#profession专业
#student学生
#teacher老师
#section选课
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.40 : Database - days1009
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`days1009` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `days1009`;

/*Table structure for table `clazz` */

DROP TABLE IF EXISTS `clazz`;

CREATE TABLE `clazz` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(20) NOT NULL,
  `pname` varchar(20) NOT NULL,
  `cdesc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  UNIQUE KEY `cname` (`cname`),
  KEY `pname` (`pname`),
  CONSTRAINT `clazz_ibfk_1` FOREIGN KEY (`pname`) REFERENCES `profession` (`pname`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `clazz` */

insert  into `clazz`(`cid`,`cname`,`pname`,`cdesc`) values (1,'软工001','软件工程','隶属于软件工程专业的班级'),(2,'软工002','软件工程','隶属于软件工程专业的班级'),(3,'机械001','机械自动化','隶属于机械自动化的班级'),(4,'机械002','机械自动化','隶属于机械自动化的班级'),(5,'土木001','土木工程','隶属于土木工程专业的班级'),(6,'土木002','土木工程','隶属于土木工程专业的班级'),(7,'车辆001','车辆工程','隶属于车辆工程专业的班级'),(8,'车辆002','车辆工程','隶属于车辆工程专业的班级');

/*Table structure for table `course` */

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(20) NOT NULL,
  `cscore` int(11) DEFAULT NULL,
  `cdesc` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  UNIQUE KEY `cname` (`cname`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `course` */

insert  into `course`(`cid`,`cname`,`cscore`,`cdesc`) values (1,'计算机',100,'计算机课程'),(2,'物理',99,'物理课程');

/*Table structure for table `holder` */

DROP TABLE IF EXISTS `holder`;

CREATE TABLE `holder` (
  `hid` int(11) NOT NULL AUTO_INCREMENT,
  `hname` varchar(20) NOT NULL,
  `hdesc` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`hid`),
  UNIQUE KEY `hname` (`hname`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `holder` */

insert  into `holder`(`hid`,`hname`,`hdesc`) values (1,'正教授','代表着高校的最高教学水准'),(2,'副教授','代表着高校的第二教学水准'),(3,'研究员','代表着高校的最高研究水准'),(4,'高级教师','代表着高校的高级教师水准'),(5,'普通教师','代表着高校的标准教学水准');

/*Table structure for table `profession` */

DROP TABLE IF EXISTS `profession`;

CREATE TABLE `profession` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `pname` varchar(20) NOT NULL,
  `pdesc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pid`),
  UNIQUE KEY `pname` (`pname`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `profession` */

insert  into `profession`(`pid`,`pname`,`pdesc`) values (1,'软件工程','一门学习软件工程的专业'),(2,'机械自动化','一门学习机械自动化的专业'),(3,'土木工程','一门学习土木工程的专业'),(4,'车辆工程','一门学习车辆工程的专业');

/*Table structure for table `section` */

DROP TABLE IF EXISTS `section`;

CREATE TABLE `section` (
  `seid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `tid` int(11) DEFAULT NULL,
  `clid` int(11) DEFAULT NULL,
  `score` double DEFAULT NULL,
  `sdesc` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`seid`),
  KEY `cid` (`cid`),
  KEY `tid` (`tid`),
  KEY `clid` (`clid`),
  CONSTRAINT `section_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `course` (`cid`),
  CONSTRAINT `section_ibfk_2` FOREIGN KEY (`tid`) REFERENCES `teacher` (`tid`),
  CONSTRAINT `section_ibfk_3` FOREIGN KEY (`clid`) REFERENCES `clazz` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `section` */

insert  into `section`(`seid`,`cid`,`tid`,`clid`,`score`,`sdesc`) values (1,1,1,1,100,'222'),(2,2,3,4,200,'222');

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(20) NOT NULL,
  `susername` varchar(20) NOT NULL,
  `spass` varchar(20) NOT NULL,
  `sex` varchar(20) NOT NULL,
  `cname` varchar(20) NOT NULL,
  PRIMARY KEY (`sid`),
  UNIQUE KEY `susername` (`susername`),
  KEY `cname` (`cname`),
  CONSTRAINT `student_ibfk_1` FOREIGN KEY (`cname`) REFERENCES `clazz` (`cname`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `student` */

insert  into `student`(`sid`,`sname`,`susername`,`spass`,`sex`,`cname`) values (1,'111','xyr201016','123456','男','软工001'),(7,'222','ljs123456','123456','男','土木002'),(8,'3333','zx123456','123456','男','软工001'),(9,'4444','zz123456','123456','男','车辆001'),(10,'555','ys123456','123456','男','土木002');

/*Table structure for table `teacher` */

DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `tanme` varchar(20) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `hname` varchar(20) DEFAULT NULL,
  `tusername` varchar(20) NOT NULL,
  `tpass` varchar(20) NOT NULL,
  `tdesc` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  UNIQUE KEY `tusername` (`tusername`),
  KEY `hname` (`hname`),
  CONSTRAINT `teacher_ibfk_1` FOREIGN KEY (`hname`) REFERENCES `holder` (`hname`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `teacher` */

insert  into `teacher`(`tid`,`tanme`,`sex`,`hname`,`tusername`,`tpass`,`tdesc`) values (1,'雷电将军','女','正教授','ld123','123456','统治着稻妻全境'),(2,'钟离','男','副教授','zl123','123456','护佑着璃月全境'),(3,'温迪','男','普通教师','wd123','123456','观望着蒙德全境'),(4,'纳西妲','女','研究员','nxd123','123456','保护着须弥全境'),(5,'丽莎','女','高级教师','ls123','123456','保护着须弥全境');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

2.搭建SSM环境

在这里插入图片描述

2.1pom.xml导入相关依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com</groupId>
    <artifactId>days65SSMPro</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <spring-version>5.1.6.RELEASE</spring-version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.6.8</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.8</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.16</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.2</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <!-- define the project compile level -->
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.6.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>

        </plugins>
    </build>

</project>

2.新建web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">

    <servlet>
        <servlet-name>mvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
    </servlet>

    <servlet-mapping>
        <servlet-name>mvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <filter>
        <filter-name>characterEncode</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>

    <filter-mapping>
        <filter-name>characterEncode</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

3.创建Sping-mvc.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <context:component-scan base-package="com.qfedu.controller" />
    <context:component-scan base-package="com.qfedu.service" />

    <mvc:annotation-driven />

    <mvc:default-servlet-handler />

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/view/" />
    </bean>

    <!--
        引入spring-mybatis的配置文件
            ssm整合的特点是将mybatis交给spring管理
    -->
    <import resource="classpath:spring-mybatis.xml" />
</beans>

4.创建spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!--context:property-placeholder 用来配置数据库链接在字符串资源-->
    <context:property-placeholder location="classpath:db.properties" />

    <!--Druid数据源的配置-->
    <bean id="ds" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="url" value="${url}" />
        <property name="driverClassName" value="${driver}" />
        <property name="username" value="${user}" />
        <property name="password" value="${pass}" />
    </bean>

    <!--
        配置SqlSessionFactoryBean,用来获取SqlSession对象
            SqlSession使用SqlSessionFactory来获取，mybatis交给spring管理后，使用SqlSessionFactoryBean来创建对应的对象
            而且高度封装后，不再看到SqlSession，都是controller-service-dao的操作。
            配置了四个属性：
                typeAliasesPackage：指明要扫描的pojo的包，该包下的所有类，都可以使用类名来简写
                dataSource：指明了数据源
                mapperLocations：ssm整体使用的是mybatis的xml+接口的方式，所以需要对应的xml文件，指定xml文件的匹配规则和路径
                configLocation：配置路径，可以用来配置单独的mybatis的配置信息
    -->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sf">
        <property name="typeAliasesPackage" value="com.qfedu.entity" />
        <property name="dataSource" ref="ds" />
        <property name="mapperLocations" value="classpath:mapper/*Dao.xml" />
        <property name="configLocation" value="classpath:mybatis.xml" />
    </bean>

    <!--
        MapperScannerConfigurer：配置映射扫描，可以扫描dao包下的所有资源
            basePackage：设置扫描dao包
            sqlSessionFactoryBeanName：指定SqlSessionFactorybean的文件
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.qfedu.dao" />
        <property name="sqlSessionFactoryBeanName" value="sf" />
    </bean>

    <!--
        DataSourceTransactionManager：数据源事务管理器
            设置事务数据源管理器的数据源
    -->
    <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="txm">
        <property name="dataSource" ref="ds" />
    </bean>

    <!--
        配置事务管理
    -->
    <tx:advice transaction-manager="txm" id="tx">
        <tx:attributes>
            <!--
               分别以save、delete、update和add开头的方法都将被切面识别
                声明式事务的配置，配置事务的规则
            -->
            <tx:method name="save*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" />
            <tx:method name="delete*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" />
            <tx:method name="update*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" />
            <tx:method name="add*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" />
        </tx:attributes>
    </tx:advice>

    <!--
        定义切面
    -->
    <aop:config>
        <aop:pointcut id="mpt" expression="execution(* com.qfedu.service.*.*(..))"/>
        <aop:advisor advice-ref="tx" pointcut-ref="mpt" />
    </aop:config>
</beans>

5.新建db.properties文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/days1009?useSSL=false&serverTimezone=UTC&characterEncoding=UTF-8
user=root
pass=root

6.创建mybatis.xml的配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!--日志-->
        <setting name="logImpl" value="LOG4J"/>
    </settings>
</configuration>

7.编码

7.1利用逆向工程easycode插件逆向生成

package com.entity;

import java.io.Serializable;

/**
 * (Student)实体类
 *
 * @author makejava
 * @since 2022-10-08 15:52:10
 */
public class Student implements Serializable {
    private static final long serialVersionUID = 828138724496500845L;

    private Integer sid;

    private String sname;

    private String susername;

    private String spass;

    private String sex;

    private String cname;


    public Integer getSid() {
        return sid;
    }

    public void setSid(Integer sid) {
        this.sid = sid;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSusername() {
        return susername;
    }

    public void setSusername(String susername) {
        this.susername = susername;
    }

    public String getSpass() {
        return spass;
    }

    public void setSpass(String spass) {
        this.spass = spass;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getCname() {
        return cname;
    }

    public void setCname(String cname) {
        this.cname = cname;
    }

}

package com.entity;

import java.io.Serializable;

/**
 * (Teacher)实体类
 *
 * @author makejava
 * @since 2022-10-08 15:50:18
 */
public class Teacher implements Serializable {
    private static final long serialVersionUID = -89599064070834680L;

    private Integer tid;

    private String tanme;

    private String sex;

    private String hname;

    private String tusername;

    private String tpass;

    private String tdesc;


    public Integer getTid() {
        return tid;
    }

    public void setTid(Integer tid) {
        this.tid = tid;
    }

    public String getTanme() {
        return tanme;
    }

    public void setTanme(String tanme) {
        this.tanme = tanme;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getHname() {
        return hname;
    }

    public void setHname(String hname) {
        this.hname = hname;
    }

    public String getTusername() {
        return tusername;
    }

    public void setTusername(String tusername) {
        this.tusername = tusername;
    }

    public String getTpass() {
        return tpass;
    }

    public void setTpass(String tpass) {
        this.tpass = tpass;
    }

    public String getTdesc() {
        return tdesc;
    }

    public void setTdesc(String tdesc) {
        this.tdesc = tdesc;
    }

}

7.2dao层

自动生成

package com.dao;

import com.entity.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * (Student)表数据库访问层
 *
 * @author makejava
 * @since 2022-10-08 15:52:09
 */
public interface StudentDao {

    /**
     * 通过ID查询单条数据
     *
     * @param sid 主键
     * @return 实例对象
     */
    Student queryById(Integer sid);

    /**
     * 查询指定行数据
     *
     * @param student  查询条件
     * @param pageable 分页对象
     * @return 对象列表
     */
//    List<Student> queryAllByLimit(Student student, @Param("pageable") Pageable pageable);

    /**
     * 统计总行数
     *
     * @param student 查询条件
     * @return 总行数
     */
    long count(Student student);

    /**
     * 新增数据
     *
     * @param student 实例对象
     * @return 影响行数
     */
    int insert(Student student);

    /**
     * 批量新增数据（MyBatis原生foreach方法）
     *
     * @param entities List<Student> 实例对象列表
     * @return 影响行数
     */
    int insertBatch(@Param("entities") List<Student> entities);

    /**
     * 批量新增或按主键更新数据（MyBatis原生foreach方法）
     *
     * @param entities List<Student> 实例对象列表
     * @return 影响行数
     * @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参
     */
    int insertOrUpdateBatch(@Param("entities") List<Student> entities);

    /**
     * 修改数据
     *
     * @param student 实例对象
     * @return 影响行数
     */
    int update(Student student);

    /**
     * 通过主键删除数据
     *
     * @param sid 主键
     * @return 影响行数
     */
    int deleteById(Integer sid);

}

studentDao.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.dao.StudentDao">

    <resultMap type="com.entity.Student" id="StudentMap">
        <result property="sid" column="sid" jdbcType="INTEGER"/>
        <result property="sname" column="sname" jdbcType="VARCHAR"/>
        <result property="susername" column="susername" jdbcType="VARCHAR"/>
        <result property="spass" column="spass" jdbcType="VARCHAR"/>
        <result property="sex" column="sex" jdbcType="VARCHAR"/>
        <result property="cname" column="cname" jdbcType="VARCHAR"/>
    </resultMap>

    <!--查询单个-->
    <select id="queryById" resultMap="StudentMap">
        select sid,
               sname,
               susername,
               spass,
               sex,
               cname
        from student
        where sid = #{sid}
    </select>

    <!--查询指定行数据-->
    <select id="queryAllByLimit" resultMap="StudentMap">
        select
        sid, sname, susername, spass, sex, cname
        from student
        <where>
            <if test="sid != null">
                and sid = #{sid}
            </if>
            <if test="sname != null and sname != ''">
                and sname = #{sname}
            </if>
            <if test="susername != null and susername != ''">
                and susername = #{susername}
            </if>
            <if test="spass != null and spass != ''">
                and spass = #{spass}
            </if>
            <if test="sex != null and sex != ''">
                and sex = #{sex}
            </if>
            <if test="cname != null and cname != ''">
                and cname = #{cname}
            </if>
        </where>
        limit #{pageable.offset}, #{pageable.pageSize}
    </select>

    <!--统计总行数-->
    <select id="count" resultType="java.lang.Long">
        select count(1)
        from student
        <where>
            <if test="sid != null">
                and sid = #{sid}
            </if>
            <if test="sname != null and sname != ''">
                and sname = #{sname}
            </if>
            <if test="susername != null and susername != ''">
                and susername = #{susername}
            </if>
            <if test="spass != null and spass != ''">
                and spass = #{spass}
            </if>
            <if test="sex != null and sex != ''">
                and sex = #{sex}
            </if>
            <if test="cname != null and cname != ''">
                and cname = #{cname}
            </if>
        </where>
    </select>

    <!--新增所有列-->
    <insert id="insert" keyProperty="sid" useGeneratedKeys="true">
        insert into student(sname, susername, spass, sex, cname)
        values (#{sname}, #{susername}, #{spass}, #{sex}, #{cname})
    </insert>

    <insert id="insertBatch" keyProperty="sid" useGeneratedKeys="true">
        insert into student(sname, susername, spass, sex, cname)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.sname}, #{entity.susername}, #{entity.spass}, #{entity.sex}, #{entity.cname})
        </foreach>
    </insert>

    <insert id="insertOrUpdateBatch" keyProperty="sid" useGeneratedKeys="true">
        insert into student(sname, susername, spass, sex, cname)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.sname}, #{entity.susername}, #{entity.spass}, #{entity.sex}, #{entity.cname})
        </foreach>
        on duplicate key update
        sname = values(sname),
        susername = values(susername),
        spass = values(spass),
        sex = values(sex),
        cname = values(cname)
    </insert>

    <!--通过主键修改数据-->
    <update id="update">
        update student
        <set>
            <if test="sname != null and sname != ''">
                sname = #{sname},
            </if>
            <if test="susername != null and susername != ''">
                susername = #{susername},
            </if>
            <if test="spass != null and spass != ''">
                spass = #{spass},
            </if>
            <if test="sex != null and sex != ''">
                sex = #{sex},
            </if>
            <if test="cname != null and cname != ''">
                cname = #{cname},
            </if>
        </set>
        where sid = #{sid}
    </update>

    <!--通过主键删除-->
    <delete id="deleteById">
        delete
        from student
        where sid = #{sid}
    </delete>

</mapper>

手动创建teacher的dao层

package com.dao;

import com.entity.Teacher;

import java.util.List;

public interface ITeacherDao {

    List<Teacher> getAllTeacher();
}

TeacherDao.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.dao.ITeacherDao">

    <!--查询单个-->
    <select id="getAllTeacher" resultType="teacher">
        select * from teacher
    </select>
</mapper>

SectionDao.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.qfedu.dao.ISectionDao">

    <!--查询单个-->
    <insert id="saveSection">
        insert into section values(null, #{course.cid}, #{teacher.tid}, #{clazz.cid}, #{score}, #{sdesc});
    </insert>
</mapper>

7.3service层

package com.service;

import com.entity.Student;

/**
 * (Student)表服务接口
 *
 * @author makejava
 * @since 2022-10-08 15:52:15
 */
public interface StudentService {

    /**
     * 通过ID查询单条数据
     *
     * @param sid 主键
     * @return 实例对象
     */
    Student queryById(Integer sid);
    /**
     * 新增数据
     *
     * @param student 实例对象
     * @return 实例对象
     */
    Student insert(Student student);

    /**
     * 修改数据
     *
     * @param student 实例对象
     * @return 实例对象
     */
    Student update(Student student);

    /**
     * 通过主键删除数据
     *
     * @param sid 主键
     * @return 是否成功
     */
    boolean deleteById(Integer sid);

}

package com.service;

import com.entity.Teacher;

import java.util.List;

public interface ITeacherService {

    List<Teacher> getAllTeacher();
}

service实现类

package com.service.impl;

import com.entity.Student;
import com.dao.StudentDao;
import com.service.StudentService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * (Student)表服务实现类
 *
 * @author makejava
 * @since 2022-10-08 15:52:16
 */
@Service("studentService")
public class StudentServiceImpl implements StudentService {
    @Resource
    private StudentDao studentDao;

    /**
     * 通过ID查询单条数据
     *
     * @param sid 主键
     * @return 实例对象
     */
    @Override
    public Student queryById(Integer sid) {
        return this.studentDao.queryById(sid);
    }


    /**
     * 新增数据
     *
     * @param student 实例对象
     * @return 实例对象
     */
    @Override
    public Student insert(Student student) {
        this.studentDao.insert(student);
        return student;
    }

    /**
     * 修改数据
     *
     * @param student 实例对象
     * @return 实例对象
     */
    @Override
    public Student update(Student student) {
        this.studentDao.update(student);
        return this.queryById(student.getSid());
    }

    /**
     * 通过主键删除数据
     *
     * @param sid 主键
     * @return 是否成功
     */
    @Override
    public boolean deleteById(Integer sid) {
        return this.studentDao.deleteById(sid) > 0;
    }
}

package com.service.impl;

import com.dao.ITeacherDao;
import com.entity.Teacher;
import com.service.ITeacherService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class TeacherServiceImpl implements ITeacherService {

    @Autowired
    private ITeacherDao itd;

    public List<Teacher> getAllTeacher(){
        return itd.getAllTeacher();
    }
}

7.4controller层

package com.controller;

import com.entity.Student;
import com.service.StudentService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * (Student)表控制层
 *
 * @author makejava
 * @since 2022-10-08 15:52:08
 */
@RestController
@RequestMapping("student")
public class StudentController {
    /**
     * 服务对象
     */
    @Resource
    private StudentService studentService;

//    public List<Student> getAllStudents(){
//
//    }

    @GetMapping("/{sid}")
    public Student getStudentBySid(@PathVariable int sid){
        return studentService.queryById(sid);
    }
}

package com.controller;

import com.entity.Teacher;
import com.service.ITeacherService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("teacher")
public class TeachaerController {

    @Autowired
    private ITeacherService its;

    @GetMapping("all")
    public List<Teacher> getAllTeacher(){
        return its.getAllTeacher();
    }
}

sectionController.java其他代码同teacher类似，在这里演示选课的操作

package com.controller;

import com.entity.Section;
import com.service.IClazzService;
import com.service.ICourseService;
import com.service.ISectionService;
import com.service.ITeacherService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
@RequestMapping("section")
public class SectionController {

    @Autowired
    private ISectionService iss;

    @Autowired
    private IClazzService ics;

    @Autowired
    private ITeacherService its;

    @Autowired
    private ICourseService iccs;

    @PostMapping("save")
    @ResponseBody
    public boolean saveSection(Section section){
        return iss.saveSection(section);
    }

    @GetMapping("save")
    public String saveSection(Model m){

        m.addAttribute("allTeacher", its.getAllTeacher());
        m.addAttribute("allClazz", ics.getAllClazz());
        m.addAttribute("allCourse", iccs.getAllCourse());

        return "saveSection.jsp";
    }
}

8.前端页面

saveSection.jsp

<%--
  Created by IntelliJ IDEA.
  User: mac
  Date: 2022/10/8
  Time: 17:09
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>saveSection</title>
</head>
<body>
<h1>saveSection</h1>
<form method="post" action="/section/save">
    clid:
    <select name="clazz.cid">
        <c:forEach items="${allClazz}" var="t">
            <option value="${t.cid}">${t.cname}</option>
        </c:forEach>
    </select><p />
    tid: <select name="teacher.tid">
            <c:forEach items="${allTeacher}" var="t">
            <option value="${t.tid}">${t.tanme}</option>
            </c:forEach>
            </select><p />
    cid:
    <select name="course.cid">
        <c:forEach items="${allCourse}" var="t">
            <option value="${t.cid}">${t.cname}</option>
        </c:forEach>
    </select><p />
    score: <input type="text" name="score" /><p />
    sdesc: <input type="text" name="sdesc" /><p />
    <input type="submit" value="submit" /><p />
</form>
</body>
</html>

实现效果

8.前端页面

saveSection.jsp

<%--
  Created by IntelliJ IDEA.
  User: mac
  Date: 2022/10/8
  Time: 17:09
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>saveSection</title>
</head>
<body>
<h1>saveSection</h1>
<form method="post" action="/section/save">
    clid:
    <select name="clazz.cid">
        <c:forEach items="${allClazz}" var="t">
            <option value="${t.cid}">${t.cname}</option>
        </c:forEach>
    </select><p />
    tid: <select name="teacher.tid">
            <c:forEach items="${allTeacher}" var="t">
            <option value="${t.tid}">${t.tanme}</option>
            </c:forEach>
            </select><p />
    cid:
    <select name="course.cid">
        <c:forEach items="${allCourse}" var="t">
            <option value="${t.cid}">${t.cname}</option>
        </c:forEach>
    </select><p />
    score: <input type="text" name="score" /><p />
    sdesc: <input type="text" name="sdesc" /><p />
    <input type="submit" value="submit" /><p />
</form>
</body>
</html>

实现效果

在这里插入图片描述