스프링부트로 페이(마일리지) 서비스를 구현한다.
페이 서비스 기능은
1) 페이 충전
2) 페이 출금
3) 총 금액(남은 금액) 조회
4) 충전 및 내역 전체 조회
1) 페이 충전
DB 테이블 생성
create table orders(
idx int auto_increment primary key,
member_idx int,
product_idx int,
amount int,
ordered_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
foreign key (member_idx) references member (idx),
foreign key (product_idx) references product (idx),
)
Dao
1) 페이 충전
@Repository
public class PayDao {
private JdbcTemplate jdbcTemplate;
@Autowired
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
public String chargePay(int userLoginRes, int money) {
String createMemberQuery = "insert into pay (member_idx, money, total, in_out) select member_idx, ?, total+?, 1 from pay where member_idx=? order by idx desc limit 1";
Object[] createMemberParams = new Object[]{money, money, userLoginRes};
this.jdbcTemplate.update(createMemberQuery, createMemberParams);
return "성공";
}
로그인한 사용자 userLoginRes와 충전 금액 money로 insert 쿼리문을 실행한다.
2) 페이 출금
public String withdrawPay(int userLoginRes, int money) {
String createMemberQuery = "insert into pay (member_idx, money, total, in_out) select member_idx, ?, total-?, 0 from pay where member_idx=? order by idx desc limit 1";
Object[] createMemberParams = new Object[]{money, money, userLoginRes};
this.jdbcTemplate.update(createMemberQuery, createMemberParams);
return "성공";
}
3) 총 금액(남은 금액) 조회
public int showTotalPay(int member_idx) {
String showPayQuery = "select total from pay where member_idx=? order by idx desc limit 1";
return this.jdbcTemplate.queryForObject(showPayQuery,
(rs, rowNum) -> rs.getObject("total", int.class)
, member_idx);
}
4) 충전 및 내역 전체 조회
public List<PostPayRes> showPayChargeList(int member_idx) {
String showPayQuery = "select * from pay where member_idx=?";
return this.jdbcTemplate.query(showPayQuery,
(rs, rowNum) -> new PostPayRes(
rs.getObject("idx", int.class),
rs.getObject("money", int.class),
rs.getDate("created_at")
), member_idx);
}
service
@Service
public class PayService {
@Autowired
PayDao payDao;
public String chargePay(int userLoginRes, int money) {
return payDao.chargePay(userLoginRes, money);
}
}
controller
@PostMapping("/charge")
public BaseResponse<String> chargePay(@AuthenticationPrincipal UserLoginRes userLoginRes, @RequestBody PostPayReq postPayReq) {
String result = payService.chargePay(userLoginRes.getIdx(), postPayReq.getMoney());
return new BaseResponse<>(result);
}
userLoginRes와 money 값을 전달해주는 postPayReq를 받아
result에 저장하고 BaseResponse<>(result)을 반환.