springboot（二）连接mysql

• 添加依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>

• 数据库配置文件

# 数据库配置
spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/springboot
    password: *****
    username: root
    driver-class-name: com.mysql.jdbc.Driver

• 在数据中建一张表，插入几条数据

• 实体类

public class Account {
    private int id;
    private String name;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public double getMoney() {
        return money;
    }

    public void setMoney(double money) {
        this.money = money;
    }

    private double money;
}

• controller，mapper，service

@Service
public class AccountService {

    @Autowired
    private AccountMapper accountMapper;

    public Account findAccount(int id){
        return accountMapper.findAccount(id);
    }
}
@Mapper
public interface AccountMapper {
    @Select("select id, name as name, money as money from account where id = #{id}")
    Account findAccount(@Param("id") int id);
}
@RequestMapping("find")
    public Account find(int id){
        return accountService.findAccount(id);
    }

• 浏览器访问http://localhost:8080/find?id=2

出现结果：{“id”:2,”name”:”bbb”,”money”:1000.0}