项目实战后续（课程管理模块）
项目介绍：
< mirror> < id> </ id> < name> </ name> < url> </ url> < mirrorOf> </ mirrorOf> </ mirror>
< dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency>
< dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies>
< properties> < spring.version> </ spring.version> </ properties> < dependencyManagement> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> </ dependencyManagement>
<?xml version="1.0" encoding="UTF-8"?>
< projectxmlns = " 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> </ modelVersion> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> < modules> < module> </ module> < module> </ module> </ modules> < properties> < maven.compiler.source> </ maven.compiler.source> < maven.compiler.target> </ maven.compiler.target> </ properties> < packaging> </ packaging> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> </ project> <?xml version="1.0" encoding="UTF-8"?>
< projectxmlns = " 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" > < parent> < artifactId> </ artifactId> < groupId> </ groupId> < version> </ version> </ parent> < modelVersion> </ modelVersion> < artifactId> </ artifactId> < properties> < maven.compiler.source> </ maven.compiler.source> < maven.compiler.target> </ maven.compiler.target> </ properties> </ project>
<?xml version="1.0" encoding="UTF-8"?>
< projectxmlns = " 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" > < parent> < artifactId> </ artifactId> < groupId> </ groupId> < version> </ version> < relativePath> </ relativePath> </ parent> < modelVersion> </ modelVersion> < artifactId> </ artifactId> < properties> < maven.compiler.source> </ maven.compiler.source> < maven.compiler.target> </ maven.compiler.target> </ properties> </ project> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies>
< dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> < parent> < artifactId> </ artifactId> < groupId> </ groupId> < version> </ version> </ parent>
< properties> < spring.version> </ spring.version> < springmvc.version> </ springmvc.version> < mybatis.version> </ mybatis.version> </ properties> < dependencyManagement> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> </ dependencyManagement> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> < scope> </ scope> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> < scope> </ scope> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> < build> < plugins> < plugin> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> < configuration> < source> </ source> < target> </ target> < encoding> </ encoding> </ configuration> </ plugin> </ plugins> </ build>
< dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> package com. lagou. domain ;
public class Test {
private Integer id;
private String name;
@Override
public String toString ( ) {
return "Text{" +
"id=" + id +
", name='" + name + '\'' +
'}' ;
}
public Integer getId ( ) {
return id;
}
public void setId ( Integer id) {
this . id = id;
}
public String getName ( ) {
return name;
}
public void setName ( String name) {
this . name = name;
}
}
< dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> package com. lagou. dao ;
import com. lagou. domain. Test ;
import java. util. List ;
public interface TestMapper {
public List < Test > findAllTest ( ) ;
}
<?xml version="1.0" encoding="UTF-8" ?>
<! DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" > < mappernamespace = " com.lagou.dao.TestMapper" > < selectid = " findAllTest" resultType = " com.lagou.domain.Test" > </ select> </ mapper> <?xml version="1.0" encoding="UTF-8"?>
< beansxmlns = " http://www.springframework.org/schema/beans" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xmlns: context= " http://www.springframework.org/schema/context" xmlns: tx= " http://www.springframework.org/schema/tx" xmlns: aop= " http://www.springframework.org/schema/aop" xsi: schemaLocation= " http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd" > < context: property-placeholderlocation = " classpath:jdbc.properties" /> < beanid = " dataSource" class = " com.alibaba.druid.pool.DruidDataSource" > < propertyname = " driverClassName" value = " ${jdbc.driver}" /> < propertyname = " url" value = " ${jdbc.url}" /> < propertyname = " username" value = " ${jdbc.username}" /> < propertyname = " password" value = " ${jdbc.password}" /> </ bean> < beanid = " sqlSessionFactory" class = " org.mybatis.spring.SqlSessionFactoryBean" > < propertyname = " dataSource" ref = " dataSource" /> < propertyname = " typeAliasesPackage" value = " com.lagou.domain" > </ property> < propertyname = " configLocation" value = " classpath:sqlMapConfig.xml" > </ property> </ bean> < beanclass = " org.mybatis.spring.mapper.MapperScannerConfigurer" > < propertyname = " basePackage" value = " com.lagou.dao" /> </ bean> </ beans> jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///spring_db?characterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=123456
<?xml version="1.0" encoding="UTF-8"?>
<! DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd" > < configuration> < settings> < settingname = " mapUnderscoreToCamelCase" value = " true" /> </ settings> </ configuration> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> package com. lagou. service ;
import com. lagou. domain. Test ;
import java. util. List ;
public interface TestService {
public List < Test > findAllTest ( ) ;
}
package com. lagou. service. impl ;
import com. lagou. dao. TestMapper ;
import com. lagou. domain. Test ;
import com. lagou. service. TestService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. stereotype. Service ;
import java. util. List ;
@Service
public class TestServiceImpl implements TestService {
@Autowired
private TestMapper testMapper;
@Override
public List < Test > findAllTest ( ) {
List < Test > = testMapper. findAllTest ( ) ;
return allTest;
}
}
<?xml version="1.0" encoding="UTF-8"?>
< beansxmlns = " http://www.springframework.org/schema/beans" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xmlns: context= " http://www.springframework.org/schema/context" xmlns: tx= " http://www.springframework.org/schema/tx" xmlns: aop= " http://www.springframework.org/schema/aop" xsi: schemaLocation= "
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd" > < context: component-scanbase-package = " com.lagou.service" > </ context: component-scan> < importresource = " classpath:applicationContext-dao.xml" /> </ beans> < packaging> </ packaging> < dependencies> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> </ dependencies> package com. lagou. controller ;
import com. lagou. domain. Test ;
import com. lagou. service. TestService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. stereotype. Controller ;
import org. springframework. web. bind. annotation. RequestMapping ;
import org. springframework. web. bind. annotation. RestController ;
import java. util. List ;
@RestController
@RequestMapping ( "/test" )
public class TestController {
@Autowired
private TestService testService;
@RequestMapping ( "/findAllTest" )
public List < Test > findAllTest ( ) {
List < Test > = testService. findAllTest ( ) ;
return allTest;
}
}
< beansxmlns = " http://www.springframework.org/schema/beans" xmlns: mvc= " http://www.springframework.org/schema/mvc" xmlns: context= " http://www.springframework.org/schema/context" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xsi: schemaLocation= " http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd" > < context: component-scanbase-package = " com.lagou.controller" > </ context: component-scan> < mvc: annotation-driven> </ mvc: annotation-driven> < mvc: default-servlet-handler> </ mvc: default-servlet-handler> </ beans> <?xml version="1.0" encoding="UTF-8"?>
< beansxmlns = " http://www.springframework.org/schema/beans" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xmlns: context= " http://www.springframework.org/schema/context" xmlns: tx= " http://www.springframework.org/schema/tx" xmlns: aop= " http://www.springframework.org/schema/aop" xsi: schemaLocation= "
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd" > < importresource = " classpath:applicationContext-service.xml" /> </ beans> <?xml version="1.0" encoding="UTF-8"?>
< web-appxmlns = " http://xmlns.jcp.org/xml/ns/javaee" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xsi: schemaLocation= " http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version = " 4.0" > < filter> < filter-name> </ filter-name> < filter-class> </ filter-class> < init-param> < param-name> </ param-name> < param-value> </ param-value> </ init-param> </ filter> < filter-mapping> < filter-name> </ filter-name> < url-pattern> </ url-pattern> </ filter-mapping> < servlet> < servlet-name> </ servlet-name> < servlet-class> </ servlet-class> < init-param> < param-name> </ param-name> < param-value> </ param-value> </ init-param> < load-on-startup> </ load-on-startup> </ servlet> < servlet-mapping> < servlet-name> </ servlet-name> < url-pattern> </ url-pattern> </ servlet-mapping> < listener> < listener-class> </ listener-class> </ listener> < context-param> < param-name> </ param-name> < param-value> </ param-value> </ context-param> < filter> < filter-name> </ filter-name> < filter-class> </ filter-class> </ filter> < filter-mapping> < filter-name> </ filter-name> < url-pattern> </ url-pattern> </ filter-mapping> </ web-app>
字段设置了comment，使得有描述，所以若要知道对应描述，可以去表里面看
public class ResponseResult {
private Boolean success;
private Integer state;
private String message;
private Object content;
public ResponseResult ( ) {
}
public ResponseResult ( Boolean success, Integer state, String message, Object
content) {
this . success = success;
this . state = state;
this . message = message;
this . content = content;
}
}
package com. lagou. domain ;
public class CourseVO {
private String courseName;
private Integer status;
public String getCourseName ( ) {
return courseName;
}
public void setCourseName ( String courseName) {
this . courseName = courseName;
}
public Integer getStatus ( ) {
return status;
}
public void setStatus ( Integer status) {
this . status = status;
}
}
package com. lagou. dao ;
import com. lagou. domain. Course ;
import java. util. List ;
public interface CourseMapper {
public List < Course > findCourseByCondition ( Course course) ;
}
<?xml version="1.0" encoding="UTF-8" ?>
<! DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" > < mappernamespace = " com.lagou.dao.CourseMapper" > < selectid = " findCourseByCondition" parameterType = " com.lagou.domain.CourseVo" resultType = " com.lagou.domain.Course" > < where> < iftest = " courseName !=null and courseName!=''" > </ if> < iftest = " status !=null and status!=''" > </ if> < iftest = " true" > </ if> </ where> </ select> </ mapper> package com. lagou. service ;
import com. lagou. domain. Course ;
import com. lagou. domain. CourseVo ;
import java. util. List ;
public interface CourseService {
public List < Course > findCourseByCondition ( CourseVo courseVo) ;
}
package com. lagou. service. impl ;
import com. lagou. dao. CourseMapper ;
import com. lagou. domain. Course ;
import com. lagou. domain. CourseVo ;
import com. lagou. service. CourseService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. stereotype. Service ;
import java. util. List ;
@Service
public class CourseServiceImpl implements CourseService {
@Autowired
private CourseMapper courseMapper;
@Override
public List < Course > findCourseByCondition ( CourseVo courseVo) {
List < Course > = courseMapper. findCourseByCondition ( courseVo) ;
return courseByCondition;
}
}
package com. lagou. controller ;
import com. lagou. domain. Course ;
import com. lagou. domain. CourseVo ;
import com. lagou. domain. ResponseResult ;
import com. lagou. service. CourseService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. web. bind. annotation. RequestBody ;
import org. springframework. web. bind. annotation. RequestMapping ;
import org. springframework. web. bind. annotation. RestController ;
import java. util. List ;
@RestController
@RequestMapping ( "/course" )
public class CourseController {
@Autowired
private CourseService courseService;
@RequestMapping ( "/findCourseByCondition" )
public ResponseResult findCourseByCondition ( @RequestBody CourseVo courseVo) {
List < Course > = courseService. findCourseByCondition ( courseVo) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "响应成功" , courseByCondition) ;
return responseResult;
}
}
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=debug, stdout
< dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> < dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency>
< beanid = " multipartResolver" class = " org.springframework.web.multipart.commons.CommonsMultipartResolver" > < propertyname = " maxUploadSize" value = " 1048576" > </ property> </ bean>
@RequestMapping ( "/courseUpload" )
public ResponseResult fileUpload ( @RequestParam ( "file" ) MultipartFile file, HttpServletRequest
request) throws IOException {
if ( file. isEmpty ( ) ) {
throw new RuntimeException ( ) ;
}
String realPath = request. getServletContext ( ) . getRealPath ( "/" ) ;
String substring = realPath. substring ( 0 , realPath. indexOf ( "ssm_web" ) ) ;
String originalFilename = file. getOriginalFilename ( ) ;
String newFileName = System . currentTimeMillis ( ) +
originalFilename. substring ( originalFilename. lastIndexOf ( "." ) ) ;
String uploadPath = substring + "upload\\" ;
File file1 = new File ( uploadPath, newFileName) ;
if ( ! file1. getParentFile ( ) . exists ( ) ) {
file1. getParentFile ( ) . mkdirs ( ) ;
System . out. println ( "创建目录" + file1) ;
}
file. transferTo ( file1) ;
HashMap < String , String > = new HashMap < > ( ) ;
objectObjectHashMap. put ( "fileName" , newFileName) ;
objectObjectHashMap. put ( "filePath" , "http://localhost:8080/upload/" + newFileName) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "图片上传成功" ,
objectObjectHashMap) ;
return responseResult;
}
}
public void saveCourse ( Course course) ;
public void saveTeacher ( Teacher teacher) ;
< insertid = " saveCourse" parameterType = " Course" > < selectKeyresultType = " int" order = " AFTER" keyProperty = " id" > </ selectKey> </ insert> < insertid = " saveTeacher" parameterType = " Teacher" > </ insert> package com. lagou. domain ;
import java. util. Date ;
public class CourseVo {
private int id;
private String courseName;
private String brief;
private double price;
private String priceTag;
private double discounts;
private String discountsTag;
private String courseDescriptionMarkDown;
private String courseDescription;
private String courseImgUrl;
private int isNew;
private String isNewDes;
private int lastOperatorId;
private Date autoOnlineTime;
private Date createTime;
private Date updateTime;
private int isDel;
private int totalDuration;
private String courseListImg;
private int status;
private int sortNum;
private String previewFirstField;
private String previewSecondField;
private int sales;
private String teacherName;
private String position;
private String description;
public int getId ( ) {
return id;
}
public void setId ( int id) {
this . id = id;
}
public String getCourseName ( ) {
return courseName;
}
public void setCourseName ( String courseName) {
this . courseName = courseName;
}
public String getBrief ( ) {
return brief;
}
public void setBrief ( String brief) {
this . brief = brief;
}
public double getPrice ( ) {
return price;
}
public void setPrice ( double price) {
this . price = price;
}
public String getPriceTag ( ) {
return priceTag;
}
public void setPriceTag ( String priceTag) {
this . priceTag = priceTag;
}
public double getDiscounts ( ) {
return discounts;
}
public void setDiscounts ( double discounts) {
this . discounts = discounts;
}
public String getDiscountsTag ( ) {
return discountsTag;
}
public void setDiscountsTag ( String discountsTag) {
this . discountsTag = discountsTag;
}
public String getCourseDescriptionMarkDown ( ) {
return courseDescriptionMarkDown;
}
public void setCourseDescriptionMarkDown ( String courseDescriptionMarkDown) {
this . courseDescriptionMarkDown = courseDescriptionMarkDown;
}
public String getCourseDescription ( ) {
return courseDescription;
}
public void setCourseDescription ( String courseDescription) {
this . courseDescription = courseDescription;
}
public String getCourseImgUrl ( ) {
return courseImgUrl;
}
public void setCourseImgUrl ( String courseImgUrl) {
this . courseImgUrl = courseImgUrl;
}
public int getIsNew ( ) {
return isNew;
}
public void setIsNew ( int isNew) {
this . isNew = isNew;
}
public String getIsNewDes ( ) {
return isNewDes;
}
public void setIsNewDes ( String isNewDes) {
this . isNewDes = isNewDes;
}
public int getLastOperatorId ( ) {
return lastOperatorId;
}
public void setLastOperatorId ( int lastOperatorId) {
this . lastOperatorId = lastOperatorId;
}
public Date getAutoOnlineTime ( ) {
return autoOnlineTime;
}
public void setAutoOnlineTime ( Date autoOnlineTime) {
this . autoOnlineTime = autoOnlineTime;
}
public Date getCreateTime ( ) {
return createTime;
}
public void setCreateTime ( Date createTime) {
this . createTime = createTime;
}
public Date getUpdateTime ( ) {
return updateTime;
}
public void setUpdateTime ( Date updateTime) {
this . updateTime = updateTime;
}
public int getIsDel ( ) {
return isDel;
}
public void setIsDel ( int isDel) {
this . isDel = isDel;
}
public int getTotalDuration ( ) {
return totalDuration;
}
public void setTotalDuration ( int totalDuration) {
this . totalDuration = totalDuration;
}
public String getCourseListImg ( ) {
return courseListImg;
}
public void setCourseListImg ( String courseListImg) {
this . courseListImg = courseListImg;
}
public int getStatus ( ) {
return status;
}
public void setStatus ( int status) {
this . status = status;
}
public int getSortNum ( ) {
return sortNum;
}
public void setSortNum ( int sortNum) {
this . sortNum = sortNum;
}
public String getPreviewFirstField ( ) {
return previewFirstField;
}
public void setPreviewFirstField ( String previewFirstField) {
this . previewFirstField = previewFirstField;
}
public String getPreviewSecondField ( ) {
return previewSecondField;
}
public void setPreviewSecondField ( String previewSecondField) {
this . previewSecondField = previewSecondField;
}
public int getSales ( ) {
return sales;
}
public void setSales ( int sales) {
this . sales = sales;
}
public String getTeacherName ( ) {
return teacherName;
}
public void setTeacherName ( String teacherName) {
this . teacherName = teacherName;
}
public String getPosition ( ) {
return position;
}
public void setPosition ( String position) {
this . position = position;
}
public String getDescription ( ) {
return description;
}
public void setDescription ( String description) {
this . description = description;
}
}
public void saveCourseOrTeacher ( CourseVo courseVo) throws InvocationTargetException ,
IllegalAccessException ;
@Override
public void saveCourseOrTeacher ( CourseVo courseVo) throws InvocationTargetException ,
IllegalAccessException {
Course course = new Course ( ) ;
BeanUtils . copyProperties ( course, courseVo) ;
Date date = new Date ( ) ;
course. setCreateTime ( date) ;
course. setUpdateTime ( date) ;
courseMapper. saveCourse ( course) ;
int id = course. getId ( ) ;
Teacher teacher = new Teacher ( ) ;
BeanUtils . copyProperties ( teacher, courseVo) ;
teacher. setCreateTime ( date) ;
teacher. setUpdateTime ( date) ;
teacher. setIsDel ( 0 ) ;
teacher. setCourseId ( id) ;
courseMapper. saveTeacher ( teacher) ;
}
@RequestMapping ( "saveOrUpdateCourse" )
public ResponseResult saveOrUpdateCourse ( @RequestBody CourseVo courseVo) throws
InvocationTargetException , IllegalAccessException {
courseService. saveCourseOrTeacher ( courseVo) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "响应成功" , null ) ;
return responseResult;
}
SELECT
c. * ,
t. teacher_name,
t. position,
t. description
FROM
course c
LEFT JOIN teacher t
ON c. id = t. id
WHERE c. id = 16
public CourseVo findCourseById ( Integer id) ;
< selectid = " findCourseById" parameterType = " int" resultType = " CourseVo" > </ select>
public CourseVo findCourseById ( Integer id) ;
@Override
public CourseVo findCourseById ( Integer id) {
CourseVo courseById = courseMapper. findCourseById ( id) ;
return courseById;
}
@RequestMapping ( "/findCourseById" )
public ResponseResult findCourseById ( Integer integer) {
CourseVo courseById = courseService. findCourseById ( integer) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "根据id查询课程信息成
功", courseById) ;
return responseResult;
}
public void updateCourse ( Course course) ;
public void updateTeacher ( Teacher teacher) ;
< updateid = " updateCourse" parameterType = " Course" > < trimprefix = " SET" suffixOverrides = " ," > < iftest = " courseName != null and courseName != ''" > </ if> < iftest = " brief != null and brief != ''" > </ if> < iftest = " previewFirstField != null and previewFirstField != ''" > </ if> < iftest = " previewSecondField != null and previewSecondField != ''" > </ if> < iftest = " courseImgUrl != null and courseImgUrl != ''" > </ if> < iftest = " courseListImg != null and courseListImg != ''" > </ if> < iftest = " sortNum != null and sortNum != ''" > </ if> < iftest = " price != null and price != ''" > </ if> < iftest = " discounts != null and discounts != ''" > </ if> < iftest = " sales != null and sales != '' or sales==0" > </ if> < iftest = " discountsTag != null and discountsTag != ''" > </ if> < iftest = " courseDescriptionMarkDown != null and
courseDescriptionMarkDown != ''" > </ if> < iftest = " updateTime != null" > </ if> </ trim> < where> < iftest = " id!=null and id != '' " > </ if> </ where> </ update> < updateid = " updateTeacher" parameterType = " Teacher" > < trimprefix = " SET" suffixOverrides = " ," > < iftest = " teacherName != null and teacherName != ''" > </ if> < iftest = " position != null and position != ''" > </ if> < iftest = " description != null and description != ''" > </ if> < iftest = " updateTime != null" > </ if> </ trim> < where> < iftest = " courseId != null and courseId != '' " > </ if> </ where> </ update>
public void updateCourseOrTeacher ( CourseVo courseVo) throws InvocationTargetException ,
IllegalAccessException ;
@Override
public void updateCourseOrTeacher ( CourseVo courseVo) throws InvocationTargetException ,
IllegalAccessException {
Course course = new Course ( ) ;
BeanUtils . copyProperties ( course, courseVo) ;
Date date = new Date ( ) ;
course. setUpdateTime ( date) ;
courseMapper. updateCourse ( course) ;
Teacher teacher = new Teacher ( ) ;
BeanUtils . copyProperties ( teacher, courseVo) ;
teacher. setCourseId ( course. getId ( ) ) ;
teacher. setUpdateTime ( date) ;
courseMapper. updateTeacher ( teacher) ;
}
@RequestMapping ( "saveOrUpdateCourse" )
public ResponseResult saveOrUpdateCourse ( @RequestBody CourseVo courseVo) throws
InvocationTargetException , IllegalAccessException {
ResponseResult responseResult;
if ( courseVo. getId ( ) != 0 ) {
courseService. saveCourseOrTeacher ( courseVo) ;
responseResult = new ResponseResult ( true , 200 , "新增成功" , null ) ;
} else {
courseService. updateCourseOrTeacher ( courseVo) ;
responseResult = new ResponseResult ( true , 200 , "修改成功" , null ) ;
}
return responseResult;
}
public void updateCourseStatus ( Course course) ;
< updateid = " updateCourseStatus" parameterType = " Course" > </ update>
public void updateCourseStatus ( int id, int status) ;
@Override
public void updateCourseStatus ( int id, int status) {
Course course = new Course ( ) ;
course. setId ( id) ;
course. setStatus ( status) ;
course. setUpdateTime ( new Date ( ) ) ;
courseMapper. updateCourseStatus ( course) ;
}
@RequestMapping ( "/updateCourseStatus" )
public ResponseResult updateCourseStatus ( Integer id , Integer status) {
courseService. updateCourseStatus ( id, status) ;
HashMap < String , Object > = new HashMap < > ( ) ;
objectObjectHashMap. put ( "status" , status) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "课程状态变更成功" ,
objectObjectHashMap) ;
return responseResult;
}
package com. lagou. dao ;
import com. lagou. domain. CourseSection ;
import java. util. List ;
public interface CourseContentMapper {
public List < CourseSection > findSectionAndLessonByCourseId ( Integer courseId) ;
}
<?xml version="1.0" encoding="UTF-8" ?>
<! DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" > < mappernamespace = " com.lagou.dao.CourseContentMapper" > < resultMapid = " SectionAndLessonResultMap" type = " CourseSection" > < idproperty = " id" column = " id" /> < resultproperty = " courseId" column = " course_id" /> < resultproperty = " sectionName" column = " section_name" /> < resultproperty = " description" column = " description" /> < resultproperty = " createTime" column = " create_time" /> < resultproperty = " updateTime" column = " update_time" /> < resultproperty = " isDe" column = " is_del" /> < resultproperty = " orderNum" column = " order_num" /> < resultproperty = " status" column = " status" /> < collectionproperty = " lessonList" ofType = " CourseLesson" > < idproperty = " id" column = " lessonId" /> < resultproperty = " courseId" column = " course_id" /> < resultproperty = " sectionId" column = " section_id" /> < resultproperty = " theme" column = " theme" /> < resultproperty = " duration" column = " duration" /> < resultproperty = " isFree" column = " is_free" /> < resultproperty = " orderNum" column = " order_numl" /> < resultproperty = " status" column = " statusl" /> </ collection> </ resultMap> < selectid = " findSectionAndLessonByCourseId" resultMap = " SectionAndLessonResultMap" > </ select> </ mapper> package com. lagou. service ;
import com. lagou. domain. CourseSection ;
import java. util. List ;
public interface CourseContentService {
public List < CourseSection > findSectionAndLessonByCourseId ( Integer courseId) ;
}
package com. lagou. service. impl ;
import com. lagou. dao. CourseContentMapper ;
import com. lagou. domain. CourseSection ;
import com. lagou. service. CourseContentService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. stereotype. Service ;
import java. util. List ;
@Service
public class CourseContentServiceImpl implements CourseContentService {
@Autowired
private CourseContentMapper courseContentMapper;
@Override
public List < CourseSection > findSectionAndLessonByCourseId ( Integer courseId) {
List < CourseSection > =
courseContentMapper. findSectionAndLessonByCourseId ( courseId) ;
return sectionAndLessonByCourseId;
}
}
package com. lagou. controller ;
import com. lagou. domain. CourseSection ;
import com. lagou. domain. ResponseResult ;
import com. lagou. service. CourseContentService ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. web. bind. annotation. RequestMapping ;
import org. springframework. web. bind. annotation. RestController ;
import java. util. List ;
@RestController
@RequestMapping ( "/courseContent" )
public class CourseContentController {
@Autowired
private CourseContentService courseContentService;
@RequestMapping ( "/findSectionAndLesson" )
public ResponseResult findSectionAndLessonByCourseId ( Integer courseId) {
List < CourseSection > =
courseContentService. findSectionAndLessonByCourseId ( courseId) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "章节及课时内容查询成功" ,
sectionAndLessonByCourseId) ;
return responseResult;
}
}
public Course findCourseByCourseId ( Integer courseId) ;
< selectid = " findCourseByCourseId" parameterType = " int" resultType = " Course" > </ select>
public Course findCourseByCourseId ( Integer courseId) ;
@Override
public Course findCourseByCourseId ( Integer courseId) {
Course courseByCourseId = courseContentMapper. findCourseByCourseId ( courseId) ;
return courseByCourseId;
}
@RequestMapping ( "/findCourseByCourseId" )
public ResponseResult findCourseByCourseId ( Integer courseId) {
Course courseByCourseId = courseContentService. findCourseByCourseId ( courseId) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "查询课程信息成功" ,
courseByCourseId) ;
return responseResult;
}
public void saveSection ( CourseSection courseSection) ;
< insertid = " saveSection" parameterType = " CourseSection" > </ insert>
public void saveSection ( CourseSection courseSection) ;
@Override
public void saveSection ( CourseSection courseSection) {
Date date = new Date ( ) ;
courseSection. setCreateTime ( date) ;
courseSection. setUpdateTime ( date) ;
courseContentMapper. saveSection ( courseSection) ;
}
@RequestMapping ( "/saveOrUpdateSection" )
public ResponseResult saveOrUpdateSection ( @RequestBody CourseSection courseSection) {
courseContentService. saveSection ( courseSection) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "新增章节成功" , null ) ;
return responseResult;
}
public void updateSection ( CourseSection courseSection) ;
< updateid = " updateSection" parameterType = " CourseSection" > < trimprefix = " SET" suffixOverrides = " ," > < iftest = " sectionName != null and sectionName != ''" > </ if> < iftest = " description != null and description != ''" > </ if> < iftest = " orderNum != null and orderNum != '' or orderNum == 0" > </ if> < iftest = " updateTime != null" > </ if> </ trim> < where> < iftest = " id != null and id != '' " > </ if> </ where> </ update>
public void updateSection ( CourseSection courseSection) ;
@Override
public void updateSection ( CourseSection courseSection) {
courseSection. setUpdateTime ( new Date ( ) ) ;
courseContentMapper. updateSection ( courseSection) ;
}
@RequestMapping ( "/saveOrUpdateSection" )
public ResponseResult saveOrUpdateSection ( @RequestBody CourseSection courseSection) {
ResponseResult responseResult
if ( courseSection. getId ( ) == null ) {
courseContentService. saveSection ( courseSection) ;
responseResult = new ResponseResult ( true , 200 , "新增章节成功" , null ) ;
} else {
courseContentService. updateSection ( courseSection) ;
responseResult = new ResponseResult ( true , 200 , "修改章节成功" , null ) ;
}
return responseResult;
}
public void updateSectionStatus ( CourseSection courseSection) ;
< updateid = " updateSectionStatus" parameterType = " CourseSection" > </ update>
public void updateSectionStatus ( int id, int status) ;
@Override
public void updateSectionStatus ( int id, int status) {
CourseSection courseSection = new CourseSection ( ) ;
courseSection. setId ( id) ;
courseSection. setStatus ( status) ;
courseSection. setUpdateTime ( new Date ( ) ) ;
courseContentMapper. updateSectionStatus ( courseSection) ;
}
@RequestMapping ( "/updateSectionStatus" )
public ResponseResult updateSectionStatus ( int id, int status) {
courseContentService. updateSectionStatus ( id, status) ;
Map < String , Object > = new HashMap < > ( ) ;
objectObjectHashMap. put ( "status" , status) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "修改章节状态成功" ,
objectObjectHashMap) ;
return responseResult;
}
public void saveLesson ( CourseLesson courseLesson) ;
< insertid = " saveLesson" parameterType = " CourseLesson" > </ insert>
public void saveLesson ( CourseLesson courseLesson) ;
@Override
public void saveLesson ( CourseLesson courseLesson) {
Date date = new Date ( ) ;
courseLesson. setCreateTime ( date) ;
courseLesson. setUpdateTime ( date) ;
courseContentMapper. saveLesson ( courseLesson) ;
}
@RequestMapping ( "/saveOrUpdateLesson" )
public ResponseResult saveOrUpdateLesson ( @RequestBody CourseLesson courseLesson) {
courseContentService. saveLesson ( courseLesson) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "添加课时成功" , null ) ;
return responseResult;
}
public void updateLesson ( CourseLesson courseLesson) ;
< updateid = " updateLesson" parameterType = " CourseLesson" > < trimprefix = " SET" suffixOverrides = " ," > < iftest = " theme != null and theme != ''" > </ if> < iftest = " duration != null and duration != ''" > </ if> < iftest = " isFree != null and isFree != ''" > </ if> < iftest = " orderNum != null and orderNum != '' or orderNum == 0" > </ if> < iftest = " updateTime != null" > </ if> </ trim> < where> < iftest = " id != null and id != '' " > </ if> </ where> </ update>
public void updateLesson ( CourseLesson courseLesson) ;
@Override
public void updateLesson ( CourseLesson courseLesson) {
courseLesson. setUpdateTime ( new Date ( ) ) ;
courseContentMapper. updateLesson ( courseLesson) ;
}
@RequestMapping ( "/saveOrUpdateLesson" )
public ResponseResult saveOrUpdateLesson ( @RequestBody CourseLesson courseLesson) {
ResponseResult responseResult;
if ( courseLesson. getId ( ) == null ) {
courseContentService. saveLesson ( courseLesson) ;
responseResult = new ResponseResult ( true , 200 , "添加课时成功" , null ) ;
} else {
courseContentService. updateLesson ( courseLesson) ;
responseResult = new ResponseResult ( true , 200 , "修改课时成功" , null ) ;
}
return responseResult;
}
public void updateLessonStatus ( CourseLesson courseLesson) ;
< updateid = " updateLessonStatus" parameterType = " CourseLesson" > </ update>
public void updateLessonStatus ( CourseLesson courseLesson) ;
@Override
public void updateLessonStatus ( CourseLesson courseLesson) {
courseLesson. setUpdateTime ( new Date ( ) ) ;
courseContentMapper. updateLessonStatus ( courseLesson) ;
}
@RequestMapping ( "/updateLessonStatus" )
public ResponseResult updateLessonStatus ( @RequestBody CourseLesson courseLesson) {
courseContentService. updateLessonStatus ( courseLesson) ;
ResponseResult responseResult = new ResponseResult ( true , 200 , "修改课时状态成功" , null ) ;
return responseResult;
}
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
