Spring+SpringMVC+Mybatis基础环境搭建

最新推荐文章于 2024-08-21 23:39:15 发布

println(''hello'');

最新推荐文章于 2024-08-21 23:39:15 发布

阅读量198

点赞数 2

分类专栏： ssm框架文章标签： mybatis spring mysql java maven

本文链接：https://blog.csdn.net/weixin_45065377/article/details/107805344

版权

ssm框架专栏收录该内容

1 篇文章 0 订阅

订阅专栏

首先我们搭建好mybatis基础环境并测试

放入一些固定的jar包版本信息

<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>8</maven.compiler.source>
    <maven.compiler.target>8</maven.compiler.target>
    <spring.version>5.2.0.RELEASE</spring.version>
    <mybatis.version>3.5.3</mybatis.version>
    <mybtis.spring.version>2.0.3</mybtis.spring.version>
    <servlet.version>3.0.1</servlet.version>
    <mysql.driver.version>6.0.6</mysql.driver.version>
  </properties>

引入mybatis和mysql数据库驱动的包

 <!-- mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>

    <!-- mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.driver.version}</version>
    </dependency>

构建user表

CREATE TABLE `user` (
  `userId` int(3) NOT NULL AUTO_INCREMENT,
  `userName` varchar(20) NOT NULL,
  `userTelephone` varchar(20) NOT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

构建实体类User

package com.cxq.pojo;

/**
 * Created by cxq on 2020/8/5.
 */
public class User {
    private int userId;
    private String userName;
    private String userTelephone;

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserTelephone() {
        return userTelephone;
    }

    public void setUserTelephone(String userTelephone) {
        this.userTelephone = userTelephone;
    }
}

构建UserMapper接口

package com.cxq.dao;

import com.cxq.pojo.User;

/**
 * Created by cxq on 2020/8/5.
 */
public interface UserMapper {

    void insertUser(User user);
}

构建与UserMapper接口相对应的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.cxq.dao.UserMapper">
    <insert id="insertUser" parameterType="User">
        INSERT INTO user(userName,userTelephone) VALUES (#{userName},#{userTelephone})
    </insert>
</mapper>

构建数据库文件

# mysql数据库配置
mysql.driver = com.mysql.cj.jdbc.Driver
mysql.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=CTT
mysql.username = root
mysql.password = root

构建Mybatis配置文件

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

    <properties resource="db.properties"/>
    <!--<settings>-->
        <!--<setting name="mapUnderscoreToCamelCase" value="true" />-->
    <!--</settings>-->
    <typeAliases>
        <package name="com.cxq.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!-- 配置数据库信息 -->
                <property name="driver" value="${mysql.driver}"/>
                <property name="url" value="${mysql.url}"/>
                <property name="username" value="${mysql.username}"/>
                <property name="password" value="${mysql.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!-- 加载映射文件 -->
        <mapper resource="mapper/UserMapper.xml"></mapper>
    </mappers>



</configuration>

到此为止，我们的mybatis已经全部设置完成，写一个测试类进行测试

import com.cxq.dao.UserMapper;
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 com.cxq.pojo.User;

import java.io.IOException;
import java.io.Reader;

public class TestMybatis {
    public static void main(String[] args) throws IOException {
        User user = new User();
        user.setUserName("zs");
        user.setUserTelephone("12345678901");


        String resoruce = "spring-mybatis.xml";
        Reader reader = Resources.getResourceAsReader(resoruce);
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sessionFactory.openSession();

        UserMapper userMapper = session.getMapper(UserMapper.class);
        userMapper.insertUser(user);
        session.commit();
        session.close();
    }
}

这样数据库会成功插入一条数据。

接下来引入spring相关包并测试spring环境，为了后面做测试，还需要引入junit的测试包

<!-- spring -->
    <dependency>
    <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.6.8</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</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-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>


    <!-- 单元测试jar -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>compile</scope>
    </dependency>

编写UserService接口及其UseServiceImpl实现类

package com.cxq.service;

import com.cxq.pojo.User;

/**
 * Created by cxq on 2020/8/5.
 */
public interface UserService {
    void insertUser(User user);
}

package com.cxq.service.impl;

import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.springframework.stereotype.Service;

/**
 * Created by cxq on 2020/8/5.
 */
@Service("userService")//这里采用了注解，将其放入Spring工厂中
public class UserServiceImpl  implements UserService{
    @Override
    public void insertUser(User user) {
        System.out.println("业务层，保存成功");
    }
}

编写测试类查看spring配置是否生效

import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/**
 * Created by cxq on 2020/8/5.
 */
public class TestSpring {

    @Test
    public void testspring(){
        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:spring-context.xml");
        UserService userService = (UserService) context.getBean("userService");
        userService.insertUser(new User());
    }
}

测试成功以后，接下来使用spring整合mybatis，也就是把mybatis的SqlSessionFactory交给spring工厂管理。

在引入sping整合mybatis的包、数据库连接池的c3p0包、spring整合jdbc的包

<!-- 数据库连接池（c3p0） -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.5</version>
    </dependency>
    <!-- spring和mybatis的整合jar -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybtis.spring.version}</version>
    </dependency>
<!-- spring-jdbc -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

spring-context.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">

    <!--只扫描除了controller层以外的所有包-->
    <context:component-scan base-package="com.cxq">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 读取数据库属性文件 -->
    <context:property-placeholder location="classpath:db.properties"/>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${mysql.driver}"></property>
        <property name="jdbcUrl" value="${mysql.url}"></property>
        <property name="user" value="${mysql.username}"></property>
        <property name="password" value="${mysql.password}"></property>
    </bean>

    <!-- 将sqlsessionFactory交给spring管理 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
        <!-- 加载mybatis的核心配置文件 -->
        <property name="configLocation" value="classpath:spring-mybatis.xml"></property>
        <!-- 加载数据源对象 -->
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 批量扫描接口-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 指定扫描包名 -->
        <property name="basePackage" value="com.cxq.dao"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

</beans>

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

    <typeAliases>
        <package name="com.cxq.pojo"/>
    </typeAliases>

</configuration>

UserServiceImpl中自动装配上UserMapper，代码如下

package com.cxq.service.impl;

import com.cxq.dao.UserMapper;
import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * Created by cxq on 2020/8/5.
 */
@Service("userService")
public class UserServiceImpl  implements UserService{
    @Autowired
    UserMapper userMapper;


    @Override
    public void insertUser(User user) {
        userMapper.insertUser(user);
        System.out.println("业务层，保存成功");
    }
}

测试Spring是否整合好Mybatis的测试类

import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/**
 * Created by cxq on 2020/8/5.
 */
public class TestSpringMybatis {
    @Test
    public void test(){

        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:spring-context.xml");
        UserService userService = (UserService)context.getBean("userService");
        User user = new User();
        user.setUserName("ls");
        user.setUserTelephone("12234234");
        userService.insertUser(user);

    }
}

接下来引入springmvc的包

<!-- spring-webmvc -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>

创建两个jsp页面index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>

    hello world!
    <a href="/hello/login">登陆</a>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
登陆页面
</body>
</html>

在创建HelloController.java

package com.cxq.controller;

import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * Created by cxq on 2020/8/5.
 */
@Controller
@RequestMapping("/hello")
public class HelloController {

    @Autowired
    UserService userService;

    @RequestMapping("/login")
    public String login(){
        return "login";
    }
}

这时候需要在web.xml文件中做配置（这里说明一下，其实正常测试springmvc只需要配置字符过滤器和springmvc配置就可以了，但是我们在UserServiceImpl中对UserMapper进行了自动装配，所以我图方便就把spring的监听器也配置上了，要不然的话运行tomcat服务器以后会出现找不到UserMapper的错误（UserMapper无法自动装配）。）

<?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">
  <display-name>Archetype Created Web Application</display-name>

  <!-- Spring监听器 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-context.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>


  <!-- SpringMVC配置 -->
  <servlet>
    <servlet-name>spring-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>spring-mvc</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!-- 字符过滤器（处理中文乱码） -->
  <filter>
    <filter-name>CharacterEncoding</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>CharacterEncoding</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

配置tomcat服务器以后运行，如果可以正常由index.jsp跳转到login.jsp说明sprigmvc已经配置成功。

到底最后一步测试ssm是否整合完成的测试就是在登陆的业务逻辑中加入插入用户的指令，正常运行说明ssm配置成功。

代码如下：

package com.cxq.controller;

import com.cxq.pojo.User;
import com.cxq.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * Created by cxq on 2020/8/5.
 */
@Controller
@RequestMapping("/hello")
public class HelloController {

    @Autowired
    UserService userService;

    @RequestMapping("/login")
    public String login(){
        User user = new User();
        user.setUserName("ww");
        user.setUserTelephone("12545363252");
        userService.insertUser(user);
        return "login";
    }
}

代码网盘地址提取码：ji0b