一、 创建项目
1 项目结构
2 编写启动类
package com.taiping;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.taiping.dao") //@MapperScan 用户扫描MyBatis的Mapper
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
3 修改 pom 文件
<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.0.1.RELEASE</version>
</parent>
<groupId>com.taiping</groupId>
<artifactId>demoSpringBoot05</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<dependencies>
<!-- web启动器 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- mybatis启动器 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<!-- oracle启动器 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
<!-- druid 数据库连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.9</version>
</dependency>
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
</dependency>
</dependencies>
</project>
4 添加 application.properties 全局配置文件
#数据库配置
spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@10.0.99.11:3526:tpicarh5db
spring.datasource.username=TPCLOUD_10
spring.datasource.password=Tpcloud#2020
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
mybatis.type-aliases-package=com.bjsxt.pojo
#端口(默认8080)
server.port=8888
#tomcat编码
server.tomcat.uri-encoding=UTF-8
#mapper映射文件
mybatis.mapper-locations:classpath:mybatis/*.xml
5 数据库表设计
create table usersT(
id varchar2(64) primary key,
name varchar2(255),
age number(3,0)
);
二、 添加用户
1 创建实体类
package com.taiping.entity;
public class ClassUsers {
private String id;
private String name;
private Integer age;
public String getId() {
return id;
}
public void setId(String 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 接口以及映射配置文件
package com.taiping.dao;
import org.apache.ibatis.annotations.Mapper;
import com.taiping.entity.ClassUsers;
@Mapper
public interface UsersMapper {
void insertUser(ClassUsers classUsers);
}
<?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.taiping.dao.UsersMapper">
<!-- 插入用户 -->
<insert id="insertUser" parameterType="com.taiping.entity.ClassUsers">
insert into usersT(name,age,id) values(#{name},#{age},#{id})
</insert>
</mapper>
3 创建业务层
package com.taiping.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.taiping.dao.UsersMapper;
import com.taiping.entity.ClassUsers;
import com.taiping.service.ClassUsersService;
@Service
@Transactional
public class ClassUsersServiceImpl implements ClassUsersService {
@Autowired
private UsersMapper usersMapper;
@Override
public void addUser(ClassUsers classUsers) {
usersMapper.insertUser(classUsers);
}
}
4 创建 Controller
package com.taiping.controller;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import com.google.gson.Gson;
import com.taiping.entity.ClassUsers;
import com.taiping.service.ClassUsersService;
@RestController
@RequestMapping("user")
public class UserController {
@Autowired
private ClassUsersService classUsersService;
/**
* 添加用户
* @param req
* @param client
* @return
*/
@RequestMapping(value = "/{client}/addUser", method = RequestMethod.POST)
public Map<String, String> addUser2(@RequestBody String req,@PathVariable String client){
Gson gson = new Gson();
ClassUsers classUsers = gson.fromJson(req, ClassUsers.class);
classUsers.setId(UUID.randomUUID().toString());
classUsersService.addUser(classUsers);
Map<String, String> result = new HashMap<String, String>();
result.put("code", "200");
result.put("msg", "");
return result;
}
}
三、SpringBoot 整合 SpringMVC+MyBatis
原文:https://www.cnblogs.com/ljk-shm-0208/p/14622093.html