SSM框架基础操作：增删改查实战-优快云博客

本文详细介绍了使用SSM（Spring、SpringMVC、MyBatis）框架进行增删改查操作的步骤，包括创建Maven Web工程、配置文件设置、实体类、DAO、Mapper、Service、Controller的编写，以及前端页面展示。同时提供了结构图和关键配置文件的内容。

1.增删改查步骤

1.创建maven的web工程引入相关依赖

2.创建springmvc的配置文件

3.web.xml的配置

4.创建对应的实体类

5.创建dao和mapper映射文件

6.创建service和controller代码

7.查询所有员工并以表格形式显示

8.index.jsp请求转发到list界面

9.链表查询

10.删除功能

11.添加员工

12.修改时数据回显

13.修改数据

2.结构图

3.poxm文件

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <!--      spring webmvc依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.1.5.RELEASE</version>
    </dependency>
<!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.4</version>
    </dependency>
<!--    mysql依赖-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.31</version>
    </dependency>
<!--    druid连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.2.8</version>
    </dependency>
<!--    spring和mybatis整合依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.7</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.15.RELEASE</version>
    </dependency>
<!--    其他依赖-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.26</version>
    </dependency>
<!--    jstl标签库依赖-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
  </dependencies>

4.springmvc.xml配置

 <!--1.包扫描-->
 <context:component-scan  base-package="com.aaa.controller,com.aaa.service"/>
 <!--2.注解驱动-->
 <mvc:annotation-driven/>
 <!--3.静态资源放行-->
 <mvc:default-servlet-handler/>
 <!--4.视图解析器-->
<!-- views前加/走的是绝对路径,路径前面不加东西直接view-->
<!-- 不加斜杠前面会加,例如deptcontroller最上面的/dept-->
 <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  <property name="prefix" value="/views/"/>
  <property name="suffix" value=".jsp"/>
 </bean>
<!--5.配置数据源-->
<bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
 <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
 <property name="url" value="jdbc:mysql://localhost:3306/a"/>
 <property name="username" value="root"/>
 <property name="password" value="980412"/>
</bean>
<!-- 6.SqlSessionFactory 理解为mybatis文件-->
 <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <!-- spring整合mybatis:把mybatis配置文件得到内容整合过来-->
  <!-- 封装一个SqlSessionFactoryBean类,整合mybatis配置文件中内容-->
<!--  引用类型要用ref,ref对应5配置数据源里的id:datasource-->
  <property name="dataSource" ref="datasource"/>
  <!-- 指定mybatis映射文件得路径-->
  <property name="mapperLocations" value="classpath*:mapper/*.xml"/>
 </bean>
<!--7.设置dao接口的代理实现类-->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
  <!-- dao接口所在的包-->
  <property name="basePackage" value="com.aaa.dao"/>
 </bean>

5.web.xml配置

    <!--加载springmvc配置文件-->
         <servlet>
     <servlet-name>springmvc</servlet-name>
    <!--一启动就把DispatcherServlet加载到Tomcat容器,容器会去解析下方springmvc文件,然后自动创建bean交于spring管理-->
             <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
         <init-param>
             <param-name>contextConfigLocation</param-name>
             <param-value>classpath*:springmvc.xml</param-value>
         </init-param>
         </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    <!--编码过滤器-->
    <filter>
        <filter-name>encodingFilter</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>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

5.1web.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_3_1.xsd"
         version="3.1">
</web-app>

6.创建对应的实体类

7.创建dao和mapper映射文件

7.1Mapper文件

<?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.aaa.dao.StuDao">
 
</mapper>