tomcat mysql mybatis_IDEA+tomcat+spring-boot+mysql+mybatis

CREATE TABLE users

(

id int(11) NOT NULL AUTO_INCREMENT,

name varchar(100) NOT NULL,

salary float(10) DEFAULT NULL,

PRIMARY KEY (id)

);

Users.java

package com.china.andrew.wanson.model;

public class Users {

private String name;

private Long salary;

private Integer id;

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Long getSalary() {

return salary;

}

public void setSalary(Long salary) {

this.salary = salary;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

}

application.properties

server.port=9095

spring.datasource.url=jdbc:mysql://localhost:3306/employee

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.testWhileIdle=true

spring.datasource.validationQuery=SELECT 1

WansonApplication.java

package com.china.andrew.wanson;

import com.china.andrew.wanson.model.Users;

import org.apache.ibatis.type.MappedTypes;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@MappedTypes(Users.class)

@MapperScan("com.china.andrew.wanson.mapper")

@SpringBootApplication

public class WansonApplication {

public static void main(String[] args) {

SpringApplication.run(WansonApplication.class, args);

}

}

``


# UsersResource.java

```java

package com.china.andrew.wanson.resource;

import com.china.andrew.wanson.mapper.UsersMapper;

import com.china.andrew.wanson.model.Users;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController

@RequestMapping("/rest/users")

public class UsersResource {

public UsersResource() {

}

public UsersResource(UsersMapper usersMapper) {

this.usersMapper = usersMapper;

}

private UsersMapper usersMapper;

@GetMapping("/all")

public List getAll(){

return usersMapper.findAll();

}

}

UserMapper.java

package com.china.andrew.wanson.mapper;

import com.china.andrew.wanson.model.Users;

import org.apache.ibatis.annotations.Mapper;

import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper

public interface UsersMapper {

@Select("select * from users")

List findAll();

}