Gradle7.4.2
IDEA
mysql中cloud-order与cloud-user表
表结构如下
cloud-order
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_order -- ---------------------------- DROp TABLE IF EXISTS `tb_order`; CREATE TABLE `tb_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单id', `user_id` bigint(20) NOT NULL COMMENT '用户id', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称', `price` bigint(20) NOT NULL COMMENT '商品价格', `num` int(10) NULL DEFAULT 0 COMMENT '商品数量', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_order -- ---------------------------- INSERT INTO `tb_order` VALUES (101, 1, 'Apple 苹果 iPhone 12 ', 699900, 1); INSERT INTO `tb_order` VALUES (102, 2, '雅迪 yadea 新国标电动车', 209900, 1); INSERT INTO `tb_order` VALUES (103, 3, '骆驼(CAMEL)休闲运动鞋女', 43900, 1); INSERT INTO `tb_order` VALUES (104, 4, '小米10 双模5G 骁龙865', 359900, 1); INSERT INTO `tb_order` VALUES (105, 5, 'OPPO Reno3 Pro 双模5G 视频双防抖', 299900, 1); INSERT INTO `tb_order` VALUES (106, 6, '美的(Midea) 新能效 冷静星II ', 544900, 1); INSERT INTO `tb_order` VALUES (107, 2, '西昊/SIHOO 人体工学电脑椅子', 79900, 1); INSERT INTO `tb_order` VALUES (108, 3, '梵班(FAMDBANN)休闲男鞋', 31900, 1); SET FOREIGN_KEY_CHECKS = 1;
cloud-user
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_user -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_user -- ---------------------------- INSERT INTO `tb_user` VALUES (1, '柳岩', '湖南省衡阳市'); INSERT INTO `tb_user` VALUES (2, '文二狗', '陕西省西安市'); INSERT INTO `tb_user` VALUES (3, '华沉鱼', '湖北省十堰市'); INSERT INTO `tb_user` VALUES (4, '张必沉', '天津市'); INSERT INTO `tb_user` VALUES (5, '郑爽爽', '辽宁省沈阳市大东区'); INSERT INTO `tb_user` VALUES (6, '范兵兵', '山东省青岛市'); SET FOREIGN_KEY_CHECKS = 1;父模块cloud-demo 依赖配置
build.gradle
plugins {
id 'org.springframework.boot' version '2.6.7' //springboot依赖
id 'io.spring.dependency-management' version '1.0.11.RELEASE' //spring的依赖管理插件
id 'java'
}
ext {
springCloudVersion= "2021.0.2" //springcloud版本号
}
//全部模块通用配置
allprojects{
group = 'com.ybp'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '11'
repositories {
mavenLocal()
mavenCentral()
}
}
//子模块配置
subprojects {
apply plugin: 'org.springframework.boot'
apply plugin: 'io.spring.dependency-management' //引入差价
apply plugin: 'java'
//子模块通用依赖
dependencies {
compileOnly group: 'org.projectlombok', name: 'lombok'
testImplementation 'org.springframework.boot:spring-boot-starter-test:2.6.7'
}
//子模块依赖管理
dependencyManagement {
dependencies{
dependency "org.springframework.boot:spring-boot-starter:2.6.7"
dependency group: 'org.mybatis.spring.boot', name: 'mybatis-spring-boot-starter', version: '2.2.2'
dependency group: 'mysql', name: 'mysql-connector-java', version: '8.0.29'
}
imports {
//spring bom helps us to declare dependencies without specifying version numbers.
mavenBom "org.springframework.cloud:spring-cloud-dependencies:${springCloudVersion}"
}
}
}
tasks.named('test') {
useJUnitPlatform()
}
setting.gradle(管理的子模块)
rootProject.name = 'cloud-demo' include 'order-service' include 'user-service'子模块order-service 配置文件
build.gradle
//子模块特有的依赖
dependencies {
implementation 'org.springframework.boot:spring-boot-starter-web'
implementation group: 'org.mybatis.spring.boot', name: 'mybatis-spring-boot-starter'
implementation group: 'mysql', name: 'mysql-connector-java'
}
application.yml
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://localhost:3306/cloud-order
username: root
password: 201425
driver-class-name: com.mysql.cj.jdbc.Driver
application:
name: orderservice //模块名
mybatis:
type-aliases-package: com.ybp.user.pojo
configuration:
map-underscore-to-camel-case: true
logging:
level:
com.ybp: debug
pattern:
dateformat: MM-dd HH:mm:ss:SSS
类文件
OrderMapper
@Mapper
public interface OrderMapper {
@Select("select * from tb_order where id=#{id}")
Order findById(Long id);
}
Order类
@Data
public class Order {
private Long id;
private Long price;
private String name;
private Integer num;
private Long userId;
private User user;
}
User类
@Data
public class User {
private Long id;
private String username;
private String address;
}
OrderService
@Service
public class OrderService {
@Autowired
private OrderMapper orderMapper;
@Autowired
private RestTemplate restTemplate;
public Order queryOrderById(Long id) {
Order order = orderMapper.findById(id);
//利用RestTemplate发送http请求,查询用户
String url = "http://localhost:8081/user/" + order.getUserId();
User user = restTemplate.getForObject(url, User.class);
order.setUser(user);
return order;
}
}
OrderController
@RestController
@RequestMapping("/order")
public class OrderController {
@Autowired
private OrderService orderService;
@GetMapping("{orderId}")
public Order queryOrderByOrderId(@PathVariable("orderId") Long orderId){
Order order = orderService.queryOrderById(orderId);
String name = order.getName();
System.out.println(name);
return order;
}
}
启动类OrderApplication.class
@SpringBootApplication
public class OrderApplication {
public static void main(String[] args) {
SpringApplication.run(OrderApplication.class);
}
@Bean
@LoadBalanced
public RestTemplate restTemplate(){
return new RestTemplate();
}
子模块user-service
目录结构和依赖配置与order-service相同
application.yml
server:
port: 8081
spring:
datasource:
url: jdbc:mysql://localhost:3306/cloud-user
username: root
password: 201425
driver-class-name: com.mysql.cj.jdbc.Driver
application:
name: userservice
mybatis:
type-aliases-package: com.ybp.user.pojo
configuration:
map-underscore-to-camel-case: true
logging:
level:
com.ybp: debug
pattern:
dateformat: MM-dd HH:mm:ss:SSS
类文件
实体类与orderservice一致
UserMapper
@Mapper
public interface UserMapper {
@Select("select * from tb_user where id = #{id}")
User findById(@Param("id") Long id);
}
UserService
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
public User queryById(Long id) {
return userMapper.findById(id);
}
}
UserController
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/{id}")
public User queryById(@PathVariable("id") Long id) {
return userService.queryById(id);
}
}
UserApplication
@SpringBootApplication
public class UserApplication {
public static void main(String[] args) {
SpringApplication.run(Application.class);
}
}
demo测试
分别启动order-service与userservice,然后使用浏览器访问接口,成功返回json数据则构建成功
id) {
return userService.queryById(id);
}
}
UserApplication
```java
@SpringBootApplication
public class UserApplication {
public static void main(String[] args) {
SpringApplication.run(Application.class);
}
}
demo测试
分别启动order-service与userservice,然后使用浏览器访问接口,成功返回json数据则构建成功



