Spring Boot入门（四）整合 SpringMVC+MyBatis

最新推荐文章于 2022-05-04 14:02:07 发布

老徐··

最新推荐文章于 2022-05-04 14:02:07 发布

阅读量329

点赞数 1

分类专栏： spring spring boot 入门

本文链接：https://blog.csdn.net/m0_38075227/article/details/108237487

版权

spring boot 入门同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

spring

4 篇文章 0 订阅

订阅专栏

标题Spring Boot入门（四）整合 SpringMVC+MyBatis

话不多说，直接整项目，什么理论完全不懂

一、创建项目

1 修改 pom 文件

<properties> 
  <java.version>1.7</java.version>  
  <thymeleaf.version>3.0.2.RELEASE</thymeleaf.version>  
  <thymeleaf-layout-dialect.version>2.0.4</thymeleaf-layout-dialect.version> 
</properties>
<dependencies> 
  <!-- springBoot 的启动器 -->  
  <dependency> 
    <groupId>org.springframework.boot</groupId>  
    <artifactId>spring-boot-starter-web</artifactId> 
  </dependency>  
  <!-- web 启动器 -->  
  <dependency> 
    <groupId>org.springframework.boot</groupId>  
    <artifactId>spring-boot-starter-thymeleaf</artifactId> 
  </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.0.9</version> 
  </dependency> 
</dependencies>

2 添加 application.properties 全局配置文件

spring.datasource.driverClassName=com.mysql.jdbc.Driver 		
spring.datasource.url=jdbc:mysql://localhost:3306/ssm 			
spring.datasource.username=root 
spring.datasource.password=root

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource 

mybatis.type-aliases-package=com.bjsxt.pojo

3 数据库表设计

CREATE TABLE `users` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) DEFAULT NULL,
	`age` int(11) DEFAULT NULL,
	PRIMARY KEY (`id`)
) ENGINE = InnoDB CHARSET = utf8;

二、添加用户

1 创建实体类

public class Users {
    private Integer id;
    private String name;
    private Integer age;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

2 创建 mapper 接口以及映射配置文件

import com.bjsxt.pojo.Users;


public interface UsersMapper {
    void insertUser(Users users);
}

<?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(name,age) values(#{name},#{age})</insert> 
</mapper>

3 创建业务层

@Service
@Transactional
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;

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

4 创建 Controller

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

    /**
    * 页面跳转 */
    @RequestMapping("/{page}")
    public String showPage(@PathVariable
    String page) {
        return page;
    }

    /**
    * 添加用户
    */
    @RequestMapping("/addUser")
    public String addUser(Users users) {
        this.usersService.addUser(users);

        return "ok";
    }
}

5 编写页面

<!DOCTYPE html>
<html>
 <head> 
  <meta charset="UTF-8" /> 
  <title>添加用户</title> 
 </head> 
 <body> 
  <form th:action="@{/users/addUser}" method="post">
    用户姓名:
   <input type="text" name="name" />
   <br /> 用户年龄:
   <input type="text" name="age" />
   <br /> 
   <input type="submit" value="确定" />
   <br /> 
  </form>  
 </body>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8"> <title>操作提示页面</title> </head>
<body> 操作成功!!
</body>
</html>

6 启动类

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

三、数据库操作

对数据库对操作和Mybatis对一样，不懂可以学习查阅MyBatis相关资料
上一篇：Spring Boot入门（三）视图层技术
 下一篇：Spring Boot 异常处理与单元测试（五）

老徐··

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
1
评论
Spring Boot入门（四）整合 SpringMVC+MyBatis

标题Spring Boot入门（四）整合 SpringMVC+MyBatis话不多说，直接整项目，什么理论完全不懂一、创建项目1 修改 pom 文件<properties> <java.version>1.7</java.version> <thymeleaf.version>3.0.2.RELEASE</thymeleaf.version> <thymeleaf-layout-dialect.version&
复制链接

扫一扫