整合SSM的Demo

最新推荐文章于 2022-04-24 00:03:47 发布

黑铁程序yuan

最新推荐文章于 2022-04-24 00:03:47 发布

阅读量169

点赞数

分类专栏： Spring 相关框架文章标签： spring mybatis

本文链接：https://blog.youkuaiyun.com/YUANGJ110/article/details/106968503

版权

Spring 相关框架专栏收录该内容

3 篇文章

订阅专栏

1.版本选择

<!--统一管理版本-->
<spring.version>5.2.1.RELEASE</spring.version>
<aspectjweaver.version>1.9.4</aspectjweaver.version>
<aopalliance.version>1.0</aopalliance.version>
<mybatis.version>3.5.3</mybatis.version>
<mybatis-spring.version>2.0.1</mybatis-spring.version>
<mysql-connector-java.version>5.1.32</mysql-connector-java.version>
<jackson.version>2.9.10</jackson.version>
<slf4j.version>1.7.25</slf4j.version>
<log4j.version>1.2.17</log4j.version>
<java.version>1.8</java.version>

2.使用 maven 创建项目(项目结构)

3.pom.xml

<dependencies>
    <!-- Begin: spring依赖 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- End: spring依赖 -->

    <!-- START Spring AOP-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectjweaver.version}</version>
    </dependency>
    <dependency>
        <groupId>aopalliance</groupId>
        <artifactId>aopalliance</artifactId>
        <version>${aopalliance.version}</version>
    </dependency>
    <!-- END Spring AOP-->

    <!-- Begin: springmvc依赖 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- End: springmvc依赖 -->

    <!-- Begin: mybatis依赖 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>${mybatis.version}</version>
    </dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>${mybatis-spring.version}</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-connector-java.version}</version>
    </dependency>
    <!-- End: mybatis依赖 -->

    <!--START : jackson-->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>${jackson.version}</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>${jackson.version}</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>${jackson.version}</version>
    </dependency>
    <!--END : jackson-->

    <!-- START log4j  日志文件管理包-->
    <!-- http://php-note.com/article/1111.html -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>${log4j.version}</version>
    </dependency>
    <!--END log4j-->

    <!--junit 包-->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.junit.jupiter</groupId>
        <artifactId>junit-jupiter-api</artifactId>
        <version>RELEASE</version>
        <scope>compile</scope>
    </dependency>
</dependencies>

4. 配置文件(resources下)

spring 的配置文件 (applicationContext.xml)

spring 的 bean 的注解扫描配置
mybatis 的配置

1)数据源(注意:配置文件中的键值对,键使用 jdbc.driver 的形式)

2)起别名 (用于mapper.xml 传参/返回值方便)

3)扫描 mapper.xml

4)扫描 mapper.java 即 dao
事务的相关配置
在 web.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
                          ">


    <!--1.开启 bean 注解扫描,通过 package 的方式 -->
    <context:component-scan base-package="com.yuan.service"/>

    <!--2.
        mybatis 相关的配置：
            1)数据源
            2)起别名
            3)扫描 mapper.xml (通过包进行扫描)
            4)扫描 mapper.java 即 dao
    -->
    <!--配置数据源-->
    <!--先加载配置文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
     </bean>
    <!--进行 mybatis SqlSessionFactoryBean 的相关配置 -->
    <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--mybatis 的配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--取别名，方便传参和指定返回值-->
        <property name="typeAliasesPackage" value="com.yuan.entity"/>
        <!--扫描 mapper.xml 位置-->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>
    <!--mybatis 和 spring 整合配置, 扫描所有的 dao -->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- https://www.jb51.net/article/110729.htm   https://blog.youkuaiyun.com/weixin_44678295/article/details/91472284  -->
        <property name="sqlSessionFactoryBeanName" value="sessionFactoryBean"/>
        <property name="basePackage" value="com.yuan.dao"/>
    </bean>

    <!-- START->END 这一块配置未使用过,暂时不太了解什么意思 -->
    <!--START   START   START   START   START   START   START-->
    <!-- 使 AOP 注解生效,未使用先注释掉 -->
    <!--<aop:aspectj-autoproxy/>-->
    <!--开启 jdbc 事务管理器 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
     </bean>
    <!--  配置事务，规定哪些方法需要事务，配置事务的传播行为和隔离级别-->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true"/>
            <tx:method name="save*" propagation="REQUIRED"/>
            <tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/>
            <tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception"/>
            <tx:method name="*" propagation="NOT_SUPPORTED"/>
        </tx:attributes>
    </tx:advice>

    <!--    配置切入点-->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.yuan.service.impl..*.*(..))"/>
    </aop:config>

    <!--  开启事务注解  -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
    <!--END END END END END END END END END END END END END END END-->


    <!--springmvc 的配置放在它自己的配置文件中-->


</beans>

springmvc-config.xml

扫描 Controller 注解
视图解析器
jackson (用于转化 json 数据)
相关的 DispatcherServlet 在 web.xml 中配置
在 web.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:mvc="http://www.springframework.org/schema/mvc"
       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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd

                            ">

    <!--
        springmvc 需要配置的东西
            1)扫描 controller 注解的包
            2)配置视图解析器
            3)配置 jackson ,用于解析 json 数据

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

    <!--https://www.cnblogs.com/escctrl22222/p/11362656.html-->
    <mvc:annotation-driven/>

    <!--配置 springmvc 视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

    <!--jackson 配置-->
    <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
        <property name="messageConverters">
            <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"></bean>
        </property>
    </bean>

</beans>

mybatis-config.xml

配置移动到了 spring 的配置文件 applicationContext.xml 中了
在 applicationContext.xml 中加载,但是这里没有进行配置,都搬到spring的配置文件 applicationContext.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>






    <!--&lt;!&ndash;这些配置都转移到 spring 的 配置文件 applicationContext.xml中了,
    通过org.mybatis.spring.SqlSessionFactoryBean 配置 &ndash;&gt;
    &lt;!&ndash;加载配置文件&ndash;&gt;
    <properties resource=""></properties>
    &lt;!&ndash;起别名&ndash;&gt;
    <typeAliases>
        <package name=""/>
    </typeAliases>
    &lt;!&ndash;配置数据源&ndash;&gt;
    <environments default="">
        <environment id="">
            <transactionManager type=""></transactionManager>
            <dataSource type=""></dataSource>
        </environment>
    </environments>
    &lt;!&ndash;配置扫描 mapper.xml&ndash;&gt;
    <mappers>
        <package name=""/>
    </mappers>-->

</configuration>

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis_day01?useUnicode=true&amp;characterEncoding=utf8
jdbc.username=root
jdbc.password=输入自己的密码

log4j.properties

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

mapper/mapper.xml

将 mapper.xml 放在 resources 下的原因
https://blog.youkuaiyun.com/xingxiupaioxue/article/details/77854288
除了 blog 中提到的方法,就是直接将 mapper.xml 文件放在 resources 下

web.xml

配置监听器以及加载 spring 的配置文件 applicationContext.xml
配置 springmvc DispatcherServlet 的请求转发,并加载 springmvc-config.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">

    <!--
        1)加载配置文件-> spring 的配置文件
        2)配置 spring 监听器
        3)配置 springmvc 的 DispatcherServlet (包括springmvc配置文件的加载) ,对请求进行转发
        4)配置过滤器,解决乱码问题

    -->
    
    <!--加载 spring 的配置文件 applicationContext.xml -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <!-- spring 监听器   https://www.jianshu.com/p/523bfddf0810   https://blog.youkuaiyun.com/lkforce/article/details/81781031   -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
    <!--配置 springmvc 的 DispatcherServlet -->
    <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:springmvc-config.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>*.do</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>
    


</web-app>

5. 测试

写一个 Controller +jsp测试 springmvc 相关 (包括 jsckson)
在 Controller 里面调用 service 方法, service 调用 dao
码云地址 -->结合代码进行学习

页面

user.jsp

通过 localhost/user/login.do 访问,设置虚拟目录为 / ,端口 80

<%--
  Created by IntelliJ IDEA.
  User: yuan
  Date: 2020-06-25
  Time: 21:33
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <script src="${pageContext.request.contextPath}/js/jquery-1.8.3.js"></script>
</head>
<body>

${username}<br>

用户名：<input type="text" name="pname" id="pname" /><br>
密码：<input type="password" name="password" id="password" /> <br>
年龄：<input type="text" name="page" id="page"><br>
<input type="button" value="测试" οnclick="testJson()" />

<script>

    function testJson() {
        //获取输入的值pname为id
        alert($("#pname").val());
        var pname = $("#pname").val();
        var password = $("#password").val();
        var page = $("#page").val();
        console.log("${pageContext.request.contextPath}/user/send.do");
        var temp = JSON.stringify({
            "pname" : pname,
            password : password,
            page : page
        });
        console.log("json:"+temp);
        /* pname 可以加引号也可以不加
            "pname":pname
          json:{"pname":"11","password":"22","page":"33"}*/
        $.ajax({
            //请求路径
            url : "${pageContext.request.contextPath}/user/send.do",
            //请求类型
            type : "post",
            //data表示发送的数据
            data : JSON.stringify({
                pname : pname,
                password : password,
                page : page
            }), //定义发送请求的数据格式为JSON字符串
            contentType : "application/json;charset=utf-8",
            //定义回调响应的数据格式为JSON字符串，该属性可以省略
            dataType : "json",
            //成功响应的结果
            success : function(data) {
                if (data != null) {
                    alert("输入的用户名：" + data.pname + "，密码：" + data.password
                        + "， 年龄：" + data.page);
                }
            }
        });
    }

</script>

</body>
</html>

controller

UserLoginController.java

package com.yuan.controller;

import com.yuan.dao.UserMapper;
import com.yuan.entity.Person;
import com.yuan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

@Controller
@RequestMapping("/user")
public class UserLoginController {

    @Autowired
    private IUserService userService;
    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/login")
    public ModelAndView login(ModelAndView modelAndView){
        System.out.println("login");
        modelAndView = new ModelAndView("/user");
        modelAndView.addObject("username","yuan袁");
        return modelAndView;
    }

    @RequestMapping("send")
    @ResponseBody
    public Person receiveJson(@RequestBody Person person){
        //调用 service 的方法
        userService.findUser();
        System.out.println("-----------");
        System.out.println("receive json date");
        System.out.println(person);
        return person;
    }

}

Mapper

UserMapper.java

package com.yuan.dao;

import com.yuan.entity.User;

public interface UserMapper {

    public  User findUserById(int id);
}

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">

<!--命名空间要使用全名称，别名是给 parameterType 和 resultType 使用的  -->
<mapper namespace="com.yuan.dao.UserMapper">
    <select id="findUserById" parameterType="int" resultType="user">
        select * from user where id = #{id}
    </select>
</mapper>

service

UserServiceImpl.java

package com.yuan.service.impl;

import com.yuan.dao.UserMapper;
import com.yuan.entity.User;
import com.yuan.service.IUserService;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.io.IOException;
import java.io.InputStream;

@Service
public class UserServiceImpl implements IUserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public void findUser() {
        System.out.println("find user");
        User user = userMapper.findUserById(1);
        System.out.println(user);
        System.out.println(user.getUsername());
        System.out.println("findUser 方法结束，通过测试");
    }

}

entity

Person.java

package com.yuan.entity;

public class Person {
    private String pname;
    private String password;
    private Integer page;

    public Person() {
    }

    public String getPname() {
        return pname;
    }

    public void setPname(String pname) {
        this.pname = pname;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Integer getPage() {
        return page;
    }

    public void setPage(Integer page) {
        this.page = page;
    }
}

User.java

package com.yuan.entity;

import java.util.Date;

public class User {

    private int id;
    private String username;
    private String sex;
    private Date birthday;
    private String address;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getSex() {
        return sex;
    }

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

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}