Spring Boot之springboot+mysql+mybatis搭建

桃扇骨 2022-04-16 06:05 200阅读 0赞

创建数据库及数据表：  
CREATE DATABASE /\*!32312 IF NOT EXISTS\*/\`springbootdb\` /\*!40100 DEFAULT CHARACTER SET utf8 \*/;

USE \`springbootdb\`;

/\*Table structure for table \`user\` \*/

DROP TABLE IF EXISTS \`user\`;

CREATE TABLE \`user\` (  
  \`id\` int(11) NOT NULL,  
  \`username\` varchar(16) DEFAULT NULL,  
  PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
2，创建User.java

package com.spb.SpringBootDemo.vo;

public class User \{

private String id;  
    private String username;  
    public String getId() \{  
        return id;  
    \}  
    public void setId(String id) \{  
        this.id = id;  
    \}  
    public String getUsername() \{  
        return username;  
    \}  
    public void setUsername(String username) \{  
        this.username = username;  
    \}

\}  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
15  
16  
17  
18  
19  
20  
21  
3, 在pom.xml中加入：

<dependency>  
      <groupId>org.mybatis.spring.boot</groupId>  
      <artifactId>mybatis-spring-boot-starter</artifactId>  
      <version>$\{mybatis-spring-boot\}</version>  
   </dependency>

<dependency>  
       <groupId>mysql</groupId>  
       <artifactId>mysql-connector-java</artifactId>  
       <version>$\{mysql-connector\}</version>  
   </dependency>  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
15  
16  
17  
18  
19  
4, 在resource下加入application.properties文件，mysql和mybatis可以根据自己的地址配置。

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

mybatis.typeAliasesPackage=org.spring.springboot.domain  
mybatis.mapperLocations=classpath:mapper/\*.xml

1  
2  
3  
4  
5  
6  
7  
8  
9  
5，新增UserDao，并在resources下面创建mapper目录，在下面创建UserMapper.xml

package com.spb.SpringBootDemo.dao;

import java.util.List;

import com.spb.SpringBootDemo.vo.User;

/\*\*  
 \*    
 \* @author Administrator  
 \*  
 \*/  
public interface UserDao \{

/\*\*  
     \* 新增用户  
     \* @param user  
     \*/  
    void createUser(User user);  
    /\*\*  
     \* 查询用户列表  
     \* @return  
     \*/  
    List<User> findAllUser();  
\}  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
15  
16  
17  
18  
19  
20  
21  
22  
23  
24  
25  
26  
<?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.spb.SpringBootDemo.dao.UserDao">  
    <resultMap id="BaseResultMap" type="com.spb.SpringBootDemo.vo.User">  
        <result column="id" property="id" />  
        <result column="username" property="username" />  
    </resultMap>

<sql id="Base\_Column\_List">  
        id, username  
    </sql>  
    <select id="findAllUser" resultMap="BaseResultMap" >  
        select  
        <include refid="Base\_Column\_List" />  
        from user  
    </select>

<insert id="createUser" parameterMap="User" useGeneratedKeys="true" keyProperty="id">  
        insert into  
            user(id,username)  
        values  
            (\#\{id\},\#\{username\})  
    </insert>

</mapper>  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
15  
16  
17  
18  
19  
20  
21  
22  
23  
24  
25  
26  
27  
28  
6，最后增加service和实现controller,这里service省略。

package com.spb.SpringBootDemo.rest;

import java.util.List;

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.RestController;

import com.spb.SpringBootDemo.service.IUserService;  
import com.spb.SpringBootDemo.vo.User;

@RestController  
@RequestMapping("/user")  
public class UserController \{

@Autowired  
    private IUserService service;  
    @RequestMapping("/userList")  
    public List<User> getUserList()\{

return service.findAllUser();  
    \}  
    @RequestMapping("/add")  
    public String addUser(@RequestBody User user)\{  
        if(user!=null)\{  
            service.createUser(user);  
            return "success";  
        \}else\{  
            return "error";  
        \}  
    \}

app.java中加入注解@MapperScan("com.spb.SpringBootDemo.dao")  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
13  
14  
15  
16  
17  
18  
19  
20  
21  
22  
23  
24  
25  
26  
27  
28  
29  
30  
31  
32  
33  
34  
35  
36  
37  
38  
39  
测试：

运行项目  
用postman测试

![è¿éåå¾çæè¿°][SouthEast]

![è¿éåå¾çæè¿°][SouthEast 1]

源码：http://download.csdn.net/download/u012343297/10163177

[SouthEast]: /images/20220416/5da5fad883c04ed9bc00023a48e0083a.png
[SouthEast 1]: /images/20220416/55900962bd274c3484bd29a97ca3f3ce.png