Spring cloud:订单微服务-新增
2023-09-27 14:23:50 时间
环境
- spring cloud Edgware.SR6
- jdk 7
- sts 4.6.0
- mysql 5.7
背景
搭建订单微服务的环境。
搭建步骤
接口层
package jiangbo.springcloud.controller;
import java.util.List;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import jiangbo.springcloud.entity.OrderInfo;
import jiangbo.springcloud.service.OrderInfoService;
@RestController
@RequestMapping("/order")
public class OrderInfoController {
private final OrderInfoService orderInfoService;
public OrderInfoController(OrderInfoService orderInfoService) {
this.orderInfoService = orderInfoService;
}
@GetMapping
public List<OrderInfo> allOrders() {
return orderInfoService.queryAllOrders();
}
@GetMapping("/{id}")
public OrderInfo getOrderInfo(@PathVariable long id) {
return orderInfoService.queryOrderInfo(id);
}
@DeleteMapping("/{id}")
public int deleteOrderInfo(@PathVariable long id) {
return orderInfoService.deleteOrderInfo(id);
}
@PostMapping
public OrderInfo newOrderInfo(@RequestBody OrderInfo orderInfo) {
return orderInfoService.insertOrderInfo(orderInfo);
}
}
服务层
package jiangbo.springcloud.service;
import java.util.List;
import jiangbo.springcloud.entity.OrderInfo;
public interface OrderInfoService {
List<OrderInfo> queryAllOrders();
OrderInfo insertOrderInfo(OrderInfo orderInfo);
OrderInfo queryOrderInfo(long id);
int deleteOrderInfo(long id);
}
package jiangbo.springcloud.service.impl;
import java.util.List;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import jiangbo.springcloud.dao.OrderInfoDao;
import jiangbo.springcloud.entity.OrderInfo;
import jiangbo.springcloud.service.OrderInfoService;
@Service
public class OrderInfoServiceImpl implements OrderInfoService {
private final OrderInfoDao orderInfoDao;
public OrderInfoServiceImpl(OrderInfoDao orderInfoDao) {
this.orderInfoDao = orderInfoDao;
}
@Override
public List<OrderInfo> queryAllOrders() {
return orderInfoDao.queryAllOrders();
}
@Transactional
@Override
public OrderInfo insertOrderInfo(OrderInfo orderInfo) {
long id = orderInfoDao.insertOrderInfo(orderInfo);
return orderInfoDao.queryOrderInfo(id);
}
@Override
public OrderInfo queryOrderInfo(long id) {
return orderInfoDao.queryOrderInfo(id);
}
@Override
public int deleteOrderInfo(long id) {
return orderInfoDao.deleteOrderInfo(id);
}
}
数据访问层
package jiangbo.springcloud.dao;
import java.util.List;
import jiangbo.springcloud.entity.OrderInfo;
public interface OrderInfoDao {
List<OrderInfo> queryAllOrders();
long insertOrderInfo(OrderInfo orderInfo);
OrderInfo queryOrderInfo(long id);
int deleteOrderInfo(long id);
}
package jiangbo.springcloud.dao;
import java.util.Date;
import java.util.List;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.simple.SimpleJdbcInsert;
import org.springframework.stereotype.Repository;
import jiangbo.springcloud.entity.OrderInfo;
@Repository
public class OrderInfoDaoImpl implements OrderInfoDao {
private static final RowMapper<OrderInfo> ROW_MAPPER = new BeanPropertyRowMapper<>(OrderInfo.class);
private static final String QUERY_ALL_SQL = "select * from order_info";
private static final String QUERY_ORDER_INFO_BY_ID_SQL = QUERY_ALL_SQL + " where id = ?";
private static final String DELETE_ORDER_INFO_BY_ID_SQL = "delete from order_info where id = ?";
private JdbcTemplate jdbcTemplate;
public OrderInfoDaoImpl(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public List<OrderInfo> queryAllOrders() {
return jdbcTemplate.query(QUERY_ALL_SQL, ROW_MAPPER);
}
@Override
public long insertOrderInfo(OrderInfo orderInfo) {
orderInfo.setUpdateTime(new Date());
return new SimpleJdbcInsert(jdbcTemplate)
// 插入订单表
.withTableName("order_info")
// 指定主键
.usingGeneratedKeyColumns("id")
// 更新的列
.usingColumns("name", "amount", "update_time")
// 参数
.executeAndReturnKey(new BeanPropertySqlParameterSource(orderInfo)).longValue();
}
@Override
public OrderInfo queryOrderInfo(long id) {
return jdbcTemplate.queryForObject(QUERY_ORDER_INFO_BY_ID_SQL, ROW_MAPPER, id);
}
@Override
public int deleteOrderInfo(long id) {
return jdbcTemplate.update(DELETE_ORDER_INFO_BY_ID_SQL, id);
}
}
验证
启动服务,使用
curl -H "Content-Type: application/json" -X POST --data '{"name":"jiangbo4","amount":"8.88"}', http://localhost:4410/order
进行验证,插入数据库成功,则增删查功能都已实现。
附录
pom.xml
<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>
<parent>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-parent</artifactId>
<version>Edgware.SR6</version>
</parent>
<groupId>jiangbo.springcloud</groupId>
<artifactId>04spring-cloud-order</artifactId>
<version>1.0.0</version>
<packaging>jar</packaging>
<properties>
<java.version>1.7</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<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.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>provided</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
相关文章
- Spring Cloud 学习笔记02----服务治理
- Spring Cloud中的服务间通信(RestTemplate和Feign)
- Spring Cloud Hystrix实现服务容错
- Spring Cloud下微服务权限方案
- Spring Cloud 微服务中搭建 OAuth2.0 认证授权服务
- Spring Cloud Zuul 网关使用与 OAuth2.0 认证授权服务
- 基于Spring Boot和Spring Cloud实现微服务架构
- spring-cloud 之没有注册,单存的springboot之间的访问
- 16.SpringCloud实战项目-Spring Cloud Alibaba 组件简介
- Spring Cloud 2020 版本重大变革,更好的命名方式!
- spring-cloud学习BUG
- Spring cloud:支付微服务-支付
- Spring cloud:订单微服务-服务注册
- Spring cloud:订单微服务-数据层
- Spring Cloud ZooKeeper集成Feign的坑2,服务调用了一次后第二次调用就变成了500,错误:Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is com.n
- 使用Spring Cloud Feign作为HTTP客户端调用远程HTTP服务
- 创建eureka注册中心关于spring-cloud-starter-netflix-eureka-server导包问题
- Spring Cloud 新一代Web框架微服务翘楚(一)
- 6000 字 | 16 图,吃透 Spring Cloud Gateway 原理
- Spring Cloud Gateway 服务网关的部署与使用详细教程
- 解决Cannot resolve com.alibaba.cloud:aliyun-oss-spring-boot-starter:unknown 文件上传报错aliCloudEdasSdk解决
- Spring Cloud Netflix
- 【微服务~原始真解】Spring Cloud —— 分布式配置组件
- 【微服务~原始真解】Spring Cloud —— 什么是负载均衡?
- spring cloud服务提供与调用示例
- 客快物流大数据项目(一百一十八):配置中心 Spring Cloud Config
- Spring Cloud Stream 使用延迟消息实现定时任务(RabbitMQ)
- 跟我学Spring Cloud(Finchley版)-05-服务注册与服务发现-Eureka入门
- spring cloud: Hystrix(六):feign的注解@FeignClient:fallbackFactory(类似于断容器)与fallback方法