一、大致介绍
通过 RestAPI 接口 /simple/{id} 来简单获取 H2 数据库中的用户信息，并且数据库中的字段与实体 User 类的字段相互映射 。
二、实现步骤
2.1 添加 maven 引用包
<?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><artifactId>springms-simple-provider-user</artifactId><version>1.0-SNAPSHOT</version><packaging>jar</packaging><parent><groupId>com.springms.cloud</groupId><artifactId>springms-spring-cloud</artifactId><version>1.0-SNAPSHOT</version></parent><dependencies><!-- 访问数据库模块 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><!-- web模块 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><!-- h2数据库模块 --><dependency><groupId>com.h2database</groupId><artifactId>h2</artifactId><scope>runtime</scope></dependency><!-- 支持Apache Solr搜索平台，包括spring-data-solr --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-solr</artifactId></dependency></dependencies></project>
2.2 添加应用配置文件（springms-simple-provider-user\\src\\main\\resources\\application.yml）
server:port: 8000
spring:application:name: springms-simple-provider-user #全部小写jpa:generate-ddl: falseshow-sql: truehibernate:ddl-auto: nonedatasource:platform: h2schema: classpath:schema.sqldata: classpath:data.sql
logging:level:root: INFOorg.hibernate: INFOorg.hibernate.type.descriptor.sql.BasicBinder: TRACEorg.hibernate.type.descriptor.sql.BasicExtractor: TRACEcom.springms: DEBUG
2.3 添加 H2 数据库脚本（springms-simple-provider-user\\src\\main\\resources\\schema.sql）
drop table user if exists;CREATE TABLE USER(id BIGINT GENERATED by default as identity,username VARCHAR(40),name VARCHAR(20),age int(3),balance DECIMAL(10, 2),PRIMARY KEY(id)
);
2.4 插入 H2 数据库一些初始化数据（springms-simple-provider-user\\src\\main\\resources\\data.sql）
INSERT into user (id, username, name, age, balance) values (1, 'user1', '张三', 20, 100.00);
INSERT into user (id, username, name, age, balance) values (2, 'user2', '李四', 22, 100.00);
INSERT into user (id, username, name, age, balance) values (3, 'user3', '王五', 24, 100.00);
INSERT into user (id, username, name, age, balance) values (4, 'user4', '赵六', 26, 100.00);
INSERT into user (id, username, name, age, balance) values (5, 'user5', '李逵', 27, 100.00);
INSERT into user (id, username, name, age, balance) values (6, 'user6', '张远', 10, 100.00);
INSERT into user (id, username, name, age, balance) values (7, 'user7', '迪拜', 60, 100.00);
INSERT into user (id, username, name, age, balance) values (8, 'user8', '哈士奇', 40, 100.00);
INSERT into user (id, username, name, age, balance) values (9, 'user9', '关羽', 30, 100.00);
2.5 添加访问底层数据模型的DAO接口（springms-simple-provider-user\\src\\main\\java\\com\\springms\\cloud\\repository\\UserRepository.java）
package com.springms.cloud.repository;import com.springms.cloud.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;@Repository
public interface UserRepository extends JpaRepository<User, Long> {}
2.6 添加实体用户类User（springms-simple-provider-user\\src\\main\\java\\com\\springms\\cloud\\entity\\User.java）
package com.springms.cloud.entity;import java.math.BigDecimal;import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;@Entity
public class User {@Id@GeneratedValue(strategy = GenerationType.AUTO)private Long id;@Columnprivate String username;@Columnprivate String name;@Columnprivate Short age;@Columnprivate BigDecimal balance;public Long getId() {return this.id;}public void setId(Long id) {this.id = id;}public String getUsername() {return this.username;}public void setUsername(String username) {this.username = username;}public String getName() {return this.name;}public void setName(String name) {this.name = name;}public Short getAge() {return this.age;}public void setAge(Short age) {this.age = age;}public BigDecimal getBalance() {return this.balance;}public void setBalance(BigDecimal balance) {this.balance = balance;}
}
2.7 添加用户Web访问层Controller（springms-simple-provider-user\\src\\main\\java\\com\\springms\\cloud\\controller\\MsSimpleProviderUserController.java）
package com.springms.cloud.controller;import com.springms.cloud.entity.User;
import com.springms.cloud.repository.UserRepository;
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;/*** 用户微服务Controller。** @author hmilyylimh** @version 0.0.1** @date 2017/9/17**/
@RestController
public class MsSimpleProviderUserController {@Autowiredprivate UserRepository userRepository;@GetMapping("/simple/{id}")public User findById(@PathVariable Long id) {return this.userRepository.findOne(id);}
}
2.8 添加简单用户微服务启动类（springms-simple-provider-user\\src\\main\\java\\com\\springms\\cloud\\MsSimpleProviderUserApplication.java）
package com.springms.cloud;import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;/*** 简单用户微服务类。** @author hmilyylimh** @version 0.0.1** @date 2017/9/17**/
@SpringBootApplication
public class MsSimpleProviderUserApplication {public static void main(String[] args) {SpringApplication.run(MsSimpleProviderUserApplication.class, args);System.out.println("【【【【【【 简单用户微服务 】】】】】】已启动.");}
}
三、测试
/****************************************************************************************一、简单用户微服务接口测试：1、启动 springms-simple-provider-user 模块服务，启动1个端口；2、在浏览器输入地址 http://localhost:8000/simple/1 可以看到信息成功的被打印出来。；****************************************************************************************/
