学成在线--22.课程营销

一.需求分析

课程营销信息包括课程价格、课程有效期等信息。

二.数据模型

课程营销信息使用course_market表存储。
数据模型如下：
文件位置：xcEduService01\xc-framework-model\src\main\java\com\xuecheng\framework\domain\course\CourseMarket.java

package com.xuecheng.framework.domain.course;

import lombok.Data;
import lombok.ToString;
import org.hibernate.annotations.GenericGenerator;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;


@Data
@ToString
@Entity
@Table(name="course_market")
@GenericGenerator(name = "jpa-assigned", strategy = "assigned")
public class CourseMarket implements Serializable {
   
    private static final long serialVersionUID = -916357110051689486L;
    @Id
    @GeneratedValue(generator = "jpa-assigned")
    @Column(length = 32)
    private String id;
    private String charge;
    private String valid;
    private String qq;
    private Float price;
    private Float price_old;
//    private Date expires;
    @Column(name = "start_time")
    private Date startTime;
    @Column(name = "end_time")
    private Date endTime;

}

三.服务端

1.Api接口

文件位置：xcEduService01\xc-service-api\src\main\java\com\xuecheng\api\course\CourseControllerApi.java

1）查询课程营销信息

@ApiOperation("获取课程营销信息")
public CourseMarket getCourseMarketById(String courseId);

2）更新课程营销信息

@ApiOperation("更新课程营销信息")
public ResponseResult updateCourseMarket(String id,CourseMarket courseMarket);

2.Dao

文件位置：xcEduService01\xc-service-manage-course\src\main\java\com\xuecheng\manage_course\dao\CourseMarketRepository.java

public interface CourseMarketRepository extends JpaRepository<CourseMarket, String> {
   
}

3.Service

文件位置：xcEduService01\xc-service-manage-course\src\main\java\com\xuecheng\manage_course\service\CourseService.java

public CourseMarket getCourseMarketById(String courseid) {
   
	Optional<CourseMarket> optional = courseMarketRepository.findById(courseId);
	if(!optional.isPresent()){
   
		return optional.get();
	} 
	return null;
}


@public CourseMarket updateCourseMarket(String id, CourseMarket courseMarket) {
   
	CourseMarket one = this.getCourseMarketById(id);
	if(one!=null){
   
		one.setCharge(courseMarket.getCharge())