springboot+mybatis整合thymeleaf实现增删查改，yml配置

你的名字 2021-05-04 18:33 556阅读 0赞

## 1.今天来学习一下thymeleaf，做一个增删查改的demo， ##

首先新建一个springboot工程

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70]  
把lombok、thymeleaf、mybatis、web的starter添加进来，或者直接复制我的maven  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70 1]

## 2.项目的目录结构 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70 2]

要添加的maven

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.2</version>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
                <optional>true</optional>
                <scope>true</scope>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.9</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.48</version>
            </dependency>

配置文件

spring:
    # thymeleaf模板格式
      thymeleaf:
        cache: false
        encoding: UTF-8
        mode: HTML
        servlet:
          content-type: text/html
        prefix: classpath:/templates/
        suffix: .html
    
    # 数据源
      datasource:
        url: jdbc:mysql://127.0.0.1:3306/itblog?characterEncoding=utf8
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
    
    mybatis:
      type-aliases-package: com.wyu.thymeleafdemo.entity
      mapper-locations: classpath:mapper/*Mapper.xml configuration: map-underscore-to-camel-case: true

mapper、service、controller、entity这些业务代码大家写的时候，如果觉得麻烦可以使用easycode或者generator来生成，我个人比较喜欢easycode，
## mysql ##

CREATE TABLE `user` (
      `user_id` int(11) NOT NULL AUTO_INCREMENT,
      `user_name` varchar(25) NOT NULL COMMENT '用户名',
      `email` varchar(20) NOT NULL COMMENT '邮箱',
      `user_url` varchar(128) NOT NULL COMMENT '头像url',
      `user_phone` varchar(11) NOT NULL COMMENT '手机号码',
      PRIMARY KEY (`user_id`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

## 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.wyu.thymeleafdemo.user.mapper.UserMapper">
        <select id="selectUsers" resultType="com.wyu.thymeleafdemo.user.entity.User">
            select * from user
        </select>
    
        <delete id="deleteUserByUserId">
            delete from user where
            user_id = #{ userId}
        </delete>
    
        <update id="updateUserByUserId">
            update user set user_name = #{ userName},
            email = #{ email}, user_phone = #{ userPhone}
            where user_id = #{ userId}
        </update>
    
        <insert id="insertUser">
            insert into user(user_name,email,user_url,user_phone)
            values(#{ userName},#{ email},#{ userUrl},#{ userPhone})
        </insert>
    
    </mapper>

## Mapper接口层 ##

@Mapper
    public interface UserMapper { 
        List<User> selectUsers();
    
        Integer deleteUserByUserId(Integer userId);
    
        Integer updateUserByUserId(Integer userId);
    
        Integer insertUser(Integer userId);
    }

## service层 ##

@Service
    public class UserService { 
    
        @Autowired
        private UserMapper userMapper;
    
        public List<User> selectUsers() { 
            return userMapper.selectUsers();
        }
    
        public boolean deleteUserByUserId(Integer userId){ 
            return userMapper.deleteUserByUserId(userId) > 0;
        }
    
        public boolean updateUserByUserId(Integer userId){ 
            return userMapper.updateUserByUserId(userId) > 0;
        }
    
        public boolean insertUser(Integer userId){ 
            return userMapper.insertUser(userId) > 0;
        }
    }

## controller层 ##

@Controller
    public class UserController { 
        @Autowired
        private UserService userService;
    
        @RequestMapping("/list")
        public String list(Model model){ 
            List<User> userList = userService.selectUsers();
            model.addAttribute("userList",userList);
            System.out.println(userList.toString());
            return "user";
        }
    
        @RequestMapping("/deleteUserByUserId")
        @ResponseBody
        public Map<String, String> deleteUserByUserId(Integer userId, Model model){ 
            Map<String, String> data = new HashMap<>();
            boolean flag = userService.deleteUserByUserId(userId);
            if (flag){ 
                data.put("msg","删除成功");
            }else { 
                data.put("msg","删除失败");
            }
            return data;
        }
    
        @RequestMapping("/updateUserByUserId")
        @ResponseBody
        public Map<String, String> updateUserByUserId(Integer userId, Model model){ 
            Map<String, String> data = new HashMap<>();
            boolean flag = userService.updateUserByUserId(userId);
            if (flag){ 
                data.put("msg","删除成功");
            }else { 
                data.put("msg","删除失败");
            }
            return data;
        }
    
        @RequestMapping("/insertUser")
        @ResponseBody
        public Map<String, String> insertUser(Integer userId, Model model){ 
            Map<String, String> data = new HashMap<>();
            boolean flag = userService.insertUser(userId);
            if (flag){ 
                data.put("msg","删除成功");
            }else { 
                data.put("msg","删除失败");
            }
            return data;
        }

前端页面，就简简单单输出一下，大家可以写一下ajax去调用controller里面的方法就可以了

<!DOCTYPE html>
    <html lang="en" xmlns:th="http://www.w3.org/1999/xhtml" xmlns:method="http://www.w3.org/1999/xhtml">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    <table>
        <tr>
            <th>ID</th>
            <th>name</th>
            <th>email</th>
            <th>userUrl</th>
            <th>userPhone</th>
        </tr>
        <tr th:each="user:${userList}">
            <td th:text="${user.userId}"></td>
            <td th:text="${user.userName}"></td>
            <td th:text="${user.email}"></td>
            <td th:text="${user.userUrl}"></td>
            <td th:text="${user.userPhone}"></td>
        </tr>
    </table>
    <br/>
    <br/>
    </body>
    </html>

## 4.页面演示： ##

![在这里插入图片描述][20200420165021885.png]  
有兴趣的可以到码云上下载来看看[：https://gitee.com/lrvingszj/thymeleafDemo.git][https_gitee.com_lrvingszj_thymeleafDemo.git]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70]: /images/20210505/502b8fad37894851b9a4b3419d6ba630.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70 1]: /images/20210505/b4080f9323f043d7bc5f82c43bd2a4db.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70 2]: /images/20210505/cf0f1b6577824698ab7ec842dd5a8366.png
[20200420165021885.png]: /images/20210505/dc79a7b343a64145be0dc7a7a0040101.png
[https_gitee.com_lrvingszj_thymeleafDemo.git]: https://gitee.com/lrvingszj/thymeleafDemo.git