springboot-mybatis-plus实现CURD环境快速搭建

1. idea创建springboot工程，引入相关starter

	<properties>
		<java.version>1.8</java.version>
		<mysql.version>5.1.49</mysql.version>
	</properties>
		<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>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.4.1</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!--xml-->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-configuration-processor</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>

2. yml配置文件

spring:
 datasource:
  url: jdbc:mysql://localhost:3306/equipment?useUnicode=true&characterEncoding=utf8
  username: xxx
  password: xxx
  driver-class-name: com.mysql.jdbc.Driver

3. 创建数据库表

CREATE TABLE `user` (
`userID` INT(10) NOT NULL,
`userName` VARCHAR(20) DEFAULT NULL,
`passWord` VARCHAR(20) DEFAULT NULL,
PRIMARY KEY (`userID`)
) ENGINE=INNODB DEFAULT CHARSET=utf8

4. 创建pojo实体类，映射数据库字段

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String userID;
    private String userName;
    private String passWord;
    private String email;
}

5. 创建pojo对应mapper

@Mapper
@Repository
public interface UserMapper {
    //查询用户
    User getUser(@Param("userID") String userID);

    //新增用户
    int addUser(User user);
}

6. 创建对应mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.nobrong.mapper.UserMapper">

    <select id="getUser" resultType="com.nobrong.pojo.User">
        SELECT * FROM USER WHERE userID=#{userID}
    </select>

    <insert id="addUser" parameterType="com.nobrong.pojo.User">
        INSERT into USER (userID,userName,passWord,email) VALUES (#{userID},#{userName},#{passWord},#{email})
    </insert>

</mapper>

7. 创建service,serciveImpl,通用mapper

public interface UserService {
    User getUser(@Param("userID") String userID);
    //新增用户
    int addUser(User user);
}


@Service
public class UserServiceImpl implements UserService{
    @Autowired
    UserMapper userMapper;

    @Override
    public User getUser(String userID) {
        return userMapper.getUser(userID);
    }

    @Override
    public int addUser(User user) {
        return userMapper.addUser(user);
    }
}

8. 创建controller层，调用service层，具体操作数据库的逻辑

//测试
@RestController
public class TestController {
    @Autowired
    UserMapper userMapper;

    @RequestMapping()
    public String getUser(@Param("userId") String userId){
        User user = userMapper.getUser(userId);
        return "user";
    }
}

9. 后端接口完成后，进行页面数据回显即可，modelAndView