IntelliJ IDEA+SpringBoot创建模拟接口小程序

一、首先，设计好数据库表，并且填上测试数据
二、新建一个Idea程序，使用spring Initialzrxiangdao向导，选择web->web,SQL->jdbc,SQL->MySQL，并且添加gson依赖库

三、配置启动文件Application.Java

@SpringBootApplication
public class Application extends SpringBootServletInitializer {

	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}

	@Override
	protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
		return builder.sources(Application.class);
	}
}

四、在application.properties文件中配置数据连接信息

#DB Configuration:
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test
spring.datasource.username = root
spring.datasource.password = root

#JPA Configuration:
spring.jpa.database=MySQL
spring.jpa.show-sql=true
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=update
#spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy
#spring.jpa.database=org.hibernate.dialect.MySQL5InnoDBDialect
#spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MYSQL5Dialect

当然数据连接的配置也可以使用一个经过@Configration注解修饰过的配置文件，二者二选一。

@Configuration
public class DataBaseConfig {
    @Bean
    public DriverManagerDataSource dataSource(){
        DriverManagerDataSource driverManagerDataSource=new DriverManagerDataSource();
        driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        driverManagerDataSource.setUrl("jdbc:mysql://192.168.1.101:3306/test");
        driverManagerDataSource.setUsername("root");
        driverManagerDataSource.setPassword("root");
        return driverManagerDataSource;
    }
}

五、建立bean文件夹，建立User.java实体类

@Entity
@Table(name = "user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    public int id;
    public String name;
    @Column(name = "password")
    public String passWord;
}

六、创建UserSqls.java接口文件，几种放置SQL查询语句

public interface UserSqls {
    String SQL_GET_USER_LIST_BY_NAME="SELECT * FROM user WHERE name=?";//获取用户列表
    String SQL_GET_USER_LIST="SELECT * FROM user";//获取所有用户列表
}

七、创建UserRepository.java接口文件

public interface UserRepository extends CrudRepository<User, Integer> {

    User findUserById(int id);

    @Query(value = UserSqls.SQL_GET_USER_LIST_BY_NAME, nativeQuery = true)
    List<User> getUserListByName(String name);

    @Query(value = UserSqls.SQL_GET_USER_LIST, nativeQuery = true)
    List<User> getUserList();
}

八、创建UserController.java文件，写几个接口方法

@RestController
public class UserController {
    @Autowired
    private UserRepository userRepository;

    @RequestMapping("/getUserInfo")
    public User getUserInfo(int id) {
        User user = userRepository.findUserById(id);
        return user;
    }

    @RequestMapping("/getUserListByName")
    public List<User> getUserListByName(String name) {
        List<User> userList = userRepository.getUserListByName(name);
        return userList;
    }

    @RequestMapping("/getUserList")
    public List<User> getUserList() {
        List<User> userList = userRepository.getUserList();
        return userList;
    }

    @RequestMapping("/getUserListJson")
    public String getUserListJson() {
        List<User> userList = userRepository.getUserList();
        return new Gson().toJson(userList);
    }
}

九、配置Artifacs部署到本地Tomcat服务器（尝试部署到软件内部的Tomcat出错没解决）

十、调用

http://192.168.1.101:8080/myall/getUserList

返回

[{"id":1,"name":"kalychen","passWord":"123456"},{"id":2,"name":"will","passWord":"123456"}]

为APP写模拟几口程序研究，比较肤浅，只图够用。