Springboot內建mysql

talk is cheap,show you my code

源碼:springboot-mysql-crud

1.建立springboot項目

2.導入相關依賴

<?xml version="1.0" encoding="UTF-8"?>
<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.1.5.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.wantao</groupId>
    <artifactId>springboot-mysql-crud</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot-mysql-crud</name>
    <description>Demo project for Spring Boot</description>
<properties>
        <java.version>1.8</java.version>
    </properties>
 <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-web -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.1.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.0</version>
        </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>
    </dependencies>
 <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>
           

注意:我使用了lombok插件(自動生成get，set方法等)，不會用的請自行百度

3.建立一個資料庫(springboot-mysql-crud),建一張表user(id,username,password)

4.在配置檔案application.properties裡面寫相關配置

#mysql
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url= jdbc:mysql://localhost:3306/springboot-mysql-crud?useSSL=false
spring.datasource.username=root
spring.datasource.password=#你自己的資料庫密碼
#mybatis
mybatis.configuration.map-underscore-to-camel-case=true
#server
server.servlet.context-path=/
           

5.建立bean包,建立類User

注意:我使用了lombok插件(自動生成get，set方法等)，不會用的請自行百度或者你自己生成get，set方法

package com.wantao.springbootmysqlcrud.bean;
import lombok.Data;
@Data
public class User {
    private Integer id;
    private String username;
    private String password;
}
           

6.建立dao包,建立CRUDDao用注解的方式寫對應sql語句

package com.wantao.springbootmysqlcrud.dao;
import com.wantao.springbootmysqlcrud.bean.User;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
@Mapper
public interface CRUDDao {
     @Select("select * from user")
     List<User> getAllUser();
     @Select("select * from user where id =#{id}")
     User getUserById(@Param("id") Integer id);
     @Insert("insert into user(id,username,password) values(#{id},#{username},#{password})")
     int addUser(User user);
     @Update("update user set username=#{username},password=#{password} where id=#{id}")
     int updateUser(User user);
     @Delete("delete from user where id=#{id}")
     int deleteUser(@Param("id") Integer id);
}
           

7.建立service包,建立CRUDService類,實作CRUDDao接口

package com.wantao.springbootmysqlcrud.CRUDService;
import com.wantao.springbootmysqlcrud.bean.User;
import com.wantao.springbootmysqlcrud.dao.CRUDDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class CRUDService implements CRUDDao {
    @Autowired
    private CRUDDao crudDao;
    @Override
    public List getAllUser() {
        return crudDao.getAllUser();
    }
@Override
    public User getUserById(Integer id) {
        return crudDao.getUserById(id);
    } @Override
    public int addUser(User user) {
        return crudDao.addUser(user);
    }
 @Override
    public int updateUser(User user) {
        return crudDao.updateUser(user);
    }
@Override
    public int deleteUser(Integer id) {
        return crudDao.deleteUser(id);
   }
}
           

8.為了資料更好的顯示,建立result包，建立Result類(用來對傳回的json進行封裝)

package com.wantao.springbootmysqlcrud.result;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.HashMap;
import java.util.Map;
/**
 * 傳回的Json資料封裝
 */
@Data
@NoArgsConstructor
public class Result{
    private Integer code;
    private String msg;
    private Map<String, Object> data = new HashMap<String, Object>();
 /**
     * 成功時調用
     * 預設狀态碼:200
     */
    public static Result success() {
        Result result = new Result();
        result.setCode(200);
        result.setMsg("處理成功");
        return result;
    }
 /**
     * 失敗時調用
     * 預設狀态碼:500
     */
    public static Result error() {
        Result result = new Result();
        result.setCode(500);
        result.setMsg("處理失敗");
        return result;
    }
  /**
     * 設定資料
     * @param key
     * @param value
     * @return
     */
    public Result add(String key,Object value){
        this.data.put(key,value);
        return this;
    }
}
           

9.建立controller包,建立CRUDController類.

package com.wantao.springbootmysqlcrud.controller;
import com.wantao.springbootmysqlcrud.CRUDService.CRUDService;
import com.wantao.springbootmysqlcrud.bean.User;
import com.wantao.springbootmysqlcrud.result.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class CRUDController {
    @Autowired
    private CRUDService crudService;
    /**
     * 查詢一個使用者
     * @param id
     * @return
     */
    @GetMapping("/getUserById/{id}")
    public Result getUserById(@PathVariable("id")Integer id){
        User user=crudService.getUserById(id);
        return Result.success().add("user",user);
    }
    /**
     * 查詢所有使用者
     * @return
     */
    @GetMapping("/getAllUser")
    public Result getAllUser(){
        List<User> users=crudService.getAllUser();
        return Result.success().add("user",users);
    }
    @GetMapping("/addUser")
    public Result addUser(){
        User user=new User();
        user.setId(2);
        user.setUsername("selenium1");
        user.setPassword("123");
        crudService.addUser(user);
        return Result.success();
    }
    @GetMapping("/updateUser")
    public Result updateUser(){
        User user=new User();
        user.setId(1);
        user.setUsername("seleniumupdate");
        user.setPassword("123");
        crudService.updateUser(user);
        return Result.success();
    }
    @GetMapping("/deleteUser/{id}")
    public Result deleteUser(@PathVariable("id") Integer id){
        crudService.deleteUser(id);
        return Result.success();
    }
}
           

這就大功告成了!!!(撒花.gif)

下面放一下結果圖

1.查詢一個使用者

2.新增一名使用者(查詢所有使用者可以看出我們新增進去了)

3.查詢所有使用者

4.修改使用者（可以看出使用者1被修改了）

5.删除使用者(可以看出使用者2被删除了)

源碼:springboot-mysql-crud

talk is cheap,show you my code