play_record表设计
DROP TABLE IF EXISTS `play_record`;
CREATE TABLE `play_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`video_id` int(11) DEFAULT NULL,
`current_num` int(11) DEFAULT NULL COMMENT '当前播放第几集',
`episode_id` int(11) DEFAULT NULL COMMENT '当前播放第几集视频id',
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;
整合用户下单接口
VideoOrderServiceImpl.java
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717150933317-1480283709.png)
PlayRecord.java
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717151028661-1242014667.png)
EpisodeMapper.java
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717151132909-2021634469.png)
EpisodeMapper.xml
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717151209692-1682564428.png)
PlayRecordMapper.java
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717151254714-2061361191.png)
PlayRecordMapper.xml
![](https://img2020.cnblogs.com/blog/1504448/202007/1504448-20200717151333342-1224699935.png)