SSM整合篇】一. Spring+SpringMvc+MyBatis简单案例_使用springmvc+spring+mybatis完成一个简单的留言板-优快云博客

本文链接：https://blog.youkuaiyun.com/TheNew_One/article/details/103830107

Spring+SpringMvc+MyBatis简单案例

github源码（day53-ssm）https://github.com/1196557363/ideaMavenProject

1. pom.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>ssm</groupId>
  <artifactId>day53-ssm</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>day53-ssm Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <spring.version>5.2.1.RELEASE</spring.version>
    <logback.version>1.2.3</logback.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!-- 1.springMVC -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- 2.mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>
    <!-- 3.mybatis和spring整合包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.3</version>
    </dependency>

    <!-- 4.spring支持orm框架(mybatis) -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- 5.mysql驱动 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.39</version>
    </dependency>

    <!-- 6.lombox -->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.8</version>
      <scope>provided</scope>
    </dependency>

    <!-- 7.logback -->
    <dependency>
      <groupId>ch.qos.logback</groupId>
      <artifactId>logback-classic</artifactId>
      <version>${logback.version}</version>
      <scope>compile</scope>
    </dependency>

    <!-- 8.logback相关包 -->
    <dependency>
      <groupId>ch.qos.logback</groupId>
      <artifactId>logback-access</artifactId>
      <version>${logback.version}</version>
      <scope>compile</scope>
    </dependency>

    <!-- 9.日志接口 -->
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>1.7.25</version>
    </dependency>

    <!-- 10.druid连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.20</version>
    </dependency>

    <!-- 11.spring 切面支持包 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!-- 12.json格式支持 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.62</version>
    </dependency>

    <!-- 13.servlet包 -->
    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
      <scope>provided</scope>
    </dependency>


  </dependencies>

  <build>
    <finalName>day53-ssm</finalName>
    <pluginManagement>
    <!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

2. 创建配置文件 (main/resources/)

2.1 spring-context.xml

在main/java下创建包目录com.wpj (如果没有自己创建，右键 --》 Mark Directory as --》 Sources Root改为蓝色目录)

<?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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd 
        http://www.springframework.org/schema/context 
        https://www.springframework.org/schema/context/spring-context.xsd">

    <!-- spring扫描包，支持依赖和注入的注解 -->
    <context:component-scan base-package="com.wpj" />

</beans>

2.2 spring-mvc.xml

在main/resources下创建包目录mappers (如果没有自己创建，右键 --》 Mark Directory as --》 Resources Root)

<?xml version="1.0" encoding="UTF-8"?>
<beans default-lazy-init="true"
       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-4.3.xsd
           http://www.springframework.org/schema/mvc
           http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.3.xsd" >

    <!-- spring扫描包，支持依赖和注入的注解 -->
    <context:component-scan base-package="com.wpj" />
    <!-- 开启 SpringMvc的注解支持-->
    <mvc:annotation-driven>
        <!-- 消息转换器 -->
        <mvc:message-converters register-defaults="false">
            <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
                <!-- 加入支持的媒体类型：返回contentType -->
                <property name="supportedMediaTypes">
                    <list>
                        <!-- 这里顺序不能反，一定先写text/html,不然IE下会出现下载提示 -->
                        <value>text/html;charset=UTF-8</value>
                        <value>application/json;charset=UTF-8</value>
                    </list>
                </property>
                <property name="fastJsonConfig">
                    <bean class="com.alibaba.fastjson.support.config.FastJsonConfig">
                        <property name="features">
                            <list>
                                <value>AllowArbitraryCommas</value>
                                <value>AllowUnQuotedFieldNames</value>
                                <value>DisableCircularReferenceDetect</value>
                            </list>
                        </property>
                        <!--配置特定的日期格式-->
                        <property name="dateFormat" value="yyyy-MM-dd HH:mm:ss"/>
                    </bean>
                </property>
            </bean>
        </mvc:message-converters>
    </mvc:annotation-driven>
</beans>

2.2.1 创建db.properties

	db.driver=com.mysql.jdbc.Driver
	db.url=jdbc:mysql://localhost:3306/day53-ssm
	db.username=root
	db.pwd=123456

2.3 spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans default-lazy-init="true"
       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-4.3.xsd
           http://www.springframework.org/schema/mvc
           http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.3.xsd" >
    <!-- 通过spring容器加载 properties文件 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 加载mapper.xml配置文件并初始化数据库连接池 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="mapperLocations" value="classpath:mappers/**/*.xml" />
        <property name="dataSource" ref="dataSource" />
        <property name="typeAliasesPackage" value="com.wpj.bean"/>
    </bean>

    <!-- 把mapper接口的配置文件对象 交由spring容器创建-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 配置mapper接口的包 -->
        <property name="basePackage" value="com.wpj.dao"/>
        <!-- 指向mapper.xml配置文件 -->
        <property name="sqlSessionFactoryBeanName" value="" />
    </bean>

    <!--配置 druid 连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
    	<property name="driverClassName" value="${db.driver}" /> 
        <property name="url" value="${db.url}" />
        <property name="username" value="${db.username}" />
        <property name="password" value="${db.pwd}" />

        <property name="filters" value="stat" />

        <property name="maxActive" value="20" />
        <property name="initialSize" value="1" />
        <property name="maxWait" value="60000" />
        <property name="minIdle" value="1" />

        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        <property name="minEvictableIdleTimeMillis" value="300000" />

        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />

        <property name="poolPreparedStatements" value="true" />
        <property name="maxOpenPreparedStatements" value="20" />

        <property name="asyncInit" value="true" />
    </bean>
</beans>

3. web.xml

	<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
  <display-name>Archetype Created Web Application</display-name>

  <!-- 加载spring相关配置文件 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-*.xml</param-value>
  </context-param>
  <!-- 监听器 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!-- springMVC的核心控制器 -->
  <servlet>
    <servlet-name>dispatcherServlet</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>
    <!--<load-on-startup>1</load-on-startup>-->
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  <servlet-mapping>
    <servlet-name>default</servlet-name>
    <url-pattern>*.html</url-pattern>
  </servlet-mapping>

</web-app>

4. 创建表和定义bean

创建表

create table user(
	u_id int auto_increment primary key comment '用户id',
	username varchar(32) unique not null comment '用户名',
	password varchar(32) not null comment '密码',
	is_delete tinyint not null default 1 comment '1代表存在，0代表删除'
)

package com.wpj.bean;

import lombok.*;

/**
 * ClassName: User
 * Description:
 *
 * @author JieKaMi
 * @version 1.0
 * @date: 2020\1\4 0004 10:24
 * @since JDK 1.8
 */
@Data
public class User {
    private Integer u_id;
    private String username;
    private String password;
}

5. 定义Dao和对应的mapper.xml文件

package com.wpj.dao;

import com.wpj.bean.*;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.*;

/**
 * ClassName: IUserDao
 * Description:
 *
 * @author JieKaMi
 * @version 1.0
 * @date: 2020\1\4 0004 10:26
 * @since JDK 1.8
 */
@Repository
public interface IUserDao {

    /**
     * 添加功能
     * @param user 添加的对象
     * @return
     */
    Integer insertUser(@Param("user") User user);
    
}

在java/resources目录下创建UserMapper.xml

开启主键回填详情看https://blog.youkuaiyun.com/TheNew_One/article/details/103816731

<?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.wpj.dao.IUserDao">

    <!-- 开启主键回填 -->
    <insert id="insertUser" useGeneratedKeys="true" keyProperty="user.u_id">
        INSERT INTO user(username, password) VALUES (#{user.username},#{user.password})
    </insert>

</mapper>

6. 创建service及其实现类

package com.wpj.service;

import com.wpj.bean.*;

/**
 * ClassName: IUserService
 * Description:
 *
 * @author JieKaMi
 * @version 1.0
 * @date: 2020\1\4 0004 10:34
 * @since JDK 1.8
 */
public interface IUserService {

    /**
     * 注册功能
     * @param user 添加的用户对象
     * @return
     */
    Integer insertUser(User user);
}

实现类

package com.wpj.service.impl;

import com.wpj.service.*;
import org.springframework.stereotype.*;
import com.wpj.bean.*;
import com.wpj.dao.*;

import javax.annotation.*;

/**
 * ClassName: UserServiceImpl
 * Description:
 *
 * @author JieKaMi
 * @version 1.0
 * @date: 2020\1\4 0004 10:34
 * @since JDK 1.8
 */
@Service
public class UserServiceImpl implements IUserService {

    @Resource
    private IUserDao userDao;

    @Override
    public Integer insertUser(User user) {
        return userDao.insertUser(user);
    }
    
}

7. 定义contoller

package com.wpj.web.controller;

import com.wpj.bean.*;
import com.wpj.service.*;
import lombok.extern.slf4j.*;
import org.springframework.http.*;
import org.springframework.web.bind.annotation.*;

import javax.annotation.*;
/**
 * ClassName: UserController
 * Description:
 *          RestController == Controller + ResponseBody
 *
 * @author JieKaMi
 * @version 1.0
 * @date: 2020\1\4 0004 10:38
 * @since JDK 1.8
 */

@RestController
@RequestMapping("/user")
@Slf4j
public class UserController {

    @Resource
    private IUserService userService;

    /**
     * produces = MediaTyp.APPLICATION_JSON_VALUE 解决响应乱码问题
     * @param user
     * @return
     */
    @RequestMapping(value = "/insert", method = RequestMethod.GET,produces = MediaType.APPLICATION_JSON_VALUE)
    public String insertUser(User user) {
        log.debug("user: " +user);
        Integer result = userService.insertUser(user);
        log.debug("result: " + (result == 1));
        log.debug("user: " +user);
        return "添加成功";
    }
}

test

部署到tomcat后 访问 localhost:8080/day53-ssm/user/insert?username=jieKaMi&password=123456

day53-ssm ==》项目名
user ==》controller映射路径
insert ==》controler里面的方法映射路径
?username=jieKaMi&password=123456 ==》传入的参数