Spring Boot结合Mybatis

pom文件：

<?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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.9.RELEASE</version>
    </parent>
    <groupId>com.bjsxt</groupId>
    <artifactId>11-spring-boot-springmvc-mybatis</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <!-- springBoot的启动器 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- thymeleaf -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!-- thymeleaf热部署 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
            <scope>true</scope>
        </dependency>
        <!-- Mybatis 启动器 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- mysql 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- druid 数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>
        <!--JDBC-->
        <!--<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>-->
    </dependencies>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>



</project>

 

application.properties

#项目端口配置
server.port=8080
server.address=0.0.0.0
#Mysql数据源配置
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource 
mybatis.type-aliases-package=com.bjsxt.pojo

 

mapper.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.bjsxt.mapper.UsersMapper">
    <!--添加-->
    <insert id="insertUser" parameterType="users">
        insert into users(username,userage) values (#{username},#{userage})
    </insert>
    <!--查询所有-->
    <select id="selectUsers" resultType="users">
        select * from users
    </select>
    <!--根据ID查询-->
    <select id="selectUserByUserid" resultType="users">
        select * from users where userid=#{value}
    </select>
    <!--更新-->
    <update id="updateUser" parameterType="users">
        update users set username=#{username},userage=#{userage} where userid=#{userid}
    </update>
    <!--删除-->
    <delete id="delectUser" >
        delete  from  users where userid=#{value}
    </delete>
</mapper>

 

实体类

package com.bjsxt.pojo;

import java.io.Serializable;

public class Users implements Serializable {
    private int userid;
    private String username;
    private int userage;

    public Users(int userid, String username, int userage) {
        this.userid = userid;
        this.username = username;
        this.userage = userage;
    }
    public Users(){}

    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 int getUserage() {
        return userage;
    }

    public void setUserage(int userage) {
        this.userage = userage;
    }

    @Override
    public String toString() {
        return "Users{" +
                "userid=" + userid +
                ", username='" + username + '\'' +
                ", userage=" + userage +
                '}';
    }
}

 

 

service接口

package com.bjsxt.service;

import com.bjsxt.pojo.Users;

import java.util.List;

public interface UsersService {
    //添加用户
    void addUser(Users users);
    //查询用户
    List<Users> findAll();
    //根据ID查询用户
    Users findUserById(int userid);
    //更新
    void updateUser(Users users);
    //删除
    void removeUser(int userid);
}

 

 

service实现类

package com.bjsxt.service.impl;

import com.bjsxt.mapper.UsersMapper;
import com.bjsxt.pojo.Users;
import com.bjsxt.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
@Transactional
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;
    @Override
    public void addUser(Users users) {
        this.usersMapper.insertUser(users);
    }

    @Override
    public List<Users> findAll() {
        return this.usersMapper.selectUsers();
    }

    @Override
    public Users findUserById(int userid) {
        return this.usersMapper.selectUserByUserid(userid);
    }

    @Override
    public void updateUser(Users users) {
        this.usersMapper.updateUser(users);
    }

    @Override
    public void removeUser(int userid) {
        this.usersMapper.delectUser(userid);
    }
}

 

控制层

package com.bjsxt.controller;

import com.bjsxt.pojo.Users;
import com.bjsxt.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@Controller
@RequestMapping("/users")
public class UsersController {
    @Autowired
    private UsersService usersService;

    @RequestMapping("/{page}")
    public String showPage(@PathVariable String page){

        return page;
    }
    /*用户*/
    @RequestMapping("/addUsers")
    public String addUsers(Users users){
        this.usersService.addUser(users);
        return "redirect:/users/findAll";
    }
    /*查询所有用户*/
    @RequestMapping("/findAll")
    public String findAll(Model model){
        List<Users> list = this.usersService.findAll();
        model.addAttribute("list",list);
        return "show";
    }
    /*根据ID查询用户*/
    @RequestMapping("/findById")
    public String findById(Model model,int userid){
        Users user = this.usersService.findUserById(userid);
        model.addAttribute("user",user);
        return "update";
    }
    /*更新用户*/
    @RequestMapping("/updateUser")
    public String updateUser(Model model,Users users){
        this.usersService.updateUser(users);
        return "redirect:/users/findAll";
    }
    /*删除用户*/
    @RequestMapping("/delUser")
    public String delUser(Model model,int userid){
        this.usersService.removeUser(userid);
        return "redirect:/users/findAll";
    }
}

 

 

启动类

package com.bjsxt;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.bjsxt.mapper") //@MapperScan 用户扫描MyBatis的Mapper
public class App {
    public static void main(String[] args) {
        SpringApplication.run(App.class,args);
    }
}