(二.课程服务.免费好课)
![\"在这里插入图片描述\"](\"/images/csdn/15450089831U545008p98Bt3.png\")
mysql按照评分和学习次数双降序排列查询所有0元课程
select * from course
where price=0
order by score desc,learn_count desc
limit 0,5;
![\"在这里插入图片描述\"](\"/images/csdn/154500898315o45mM00898P3.png\")
一.创建一个ovls-course项目
1.准备工作
依赖的传递(导自己创建的JAR包)
1.先创建一个公共工程ovls-common项目(jar包)
项目共同的类包等都可以放这里
把整个项目所需要的包都导到这个里面,其他工程调用这一个包就可以了
![\"在这里插入图片描述\"](\"/images/csdn/1545008984U1545P0v089984.png\")
刷新
![\"在这里插入图片描述\"](\"/images/csdn/1545008984q1545w00218984.png\")
代码
<project ns=\"http://maven.apache.org/POM/4.0.0\" ns:xsi=\"http://www.w3.org/2001/ Schema-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>
<groupId>cn.xdl</groupId>
<artifactId>ovls-common</artifactId>
<version>0.0.1-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.spring work.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>2.0.5.RELEASE</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.spring work.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
<version>2.0.1.RELEASE</version>
</dependency>
<dependency>
<groupId>org.spring work.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
<version>2.0.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.apache.tomcat</groupId>
<artifactId>jasper</artifactId>
<version>6.0.29</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.43</version>
</dependency>
<dependency>
<groupId>org.spring work.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<version>2.0.5.RELEASE</version>
</dependency>
</dependencies>
</project>
需要的话直接引入他就可以了
![\"在这里插入图片描述\"](\"/images/csdn/1545008985154450eN08V985.png\")
2.添加配置文件applicaion.yml在resources包中
注意：跟上一级空一个字符
在值前也空一个字符
其他调用这个的配置文件的配置内容不能重复，要全部删掉，值留下连接端口就可以
spring:
datasource:
username: root
password: root
url: jdbc:mysql://localhost:3306/ovls?userUnicode=true&characterEncoding=utf8
driverClassName: com.mysql.jdbc.Driver
3.user需要修改一下pom.
<project ns=\"http://maven.apache.org/POM/4.0.0\" ns:xsi=\"http://www.w3.org/2001/ Schema-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>
<groupId>cn.xdl</groupId>
<artifactId>ovls-user</artifactId>
<version>0.0.1-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>cn.xdl</groupId>
<artifactId>ovls-common</artifactId>
<version>0.0.1-SNAPSHOT</version>
</dependency>
</dependencies>
</project>
4.user需要修改配置文件
server.port=7001
![\"在这里插入图片描述\"](\"/images/csdn/15450089851L54A50089g8u5.jpeg\")
Maven扩展概念
依赖范围
依赖传递
依赖排除
mvn compile 编译源代码
mvn deploy 发布项目
mvn test 运行应用程序中的单元测试
mvn clean 清除项目目录中的生成结果
mvn package 根据项目生成的jar
mvn install 在本地Repository中安装jar
![\"在这里插入图片描述\"](\"/images/csdn/1545008986l15iq450089896.png\")
二、免费好课
流程：
1.在ovls-common引公共的jar包
2.添加配置文件（只需要写端口）
3.添加启动类CourseRunBoot
4.添加生成好的实体类Course到entity包
5.添加生成好的dao接口CourseMapper
6.添加生成好的实现类CourseSqlProvider
7.添加测试TestCourseMapper
8.添加服务CourseService接口
9.添加实现类CourseServiceImpl
10.添加控制器CourseController
1.在ovls-common引公共的jar包
<project ns=\"http://maven.apache.org/POM/4.0.0\" ns:xsi=\"http://www.w3.org/2001/ Schema-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>
<groupId>cn.xdl</groupId>
<artifactId>ovls-course</artifactId>
<version>0.0.1-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>cn.xdl</groupId>
<artifactId>ovls-common</artifactId>
<version>0.0.1-SNAPSHOT</version>
</dependency>
</dependencies>
</project>
2.添加配置文件（只需要写端口）
server.port=7002
3.在ovls包中添加启动类CourseRunBoot
package cn.xdl.ovls;
import org.mybatis.spring.annotation.MapperScan;
import org.spring work.boot.SpringApplication;
import org.spring work.boot.autoconfigure.SpringBootApplication;
import org.spring work.boot.web.servlet.ServletComponentScan;
//启动程序包含@Configuration、@EnableAutoConfiguration、@ComponentScan
通常用在主类上
@SpringBootApplication
// 为MapperScan添加动态扫描(占位符)功能
@MapperScan( Packages={\"cn.xdl.ovls.dao\"})
//扫描ajax跨域请求过滤器的扫描器公共的必须在这个包里面Servlet、Filter、Listener 可以直接通过 @WebServlet、@WebFilter、@WebListener 注解自动注册，无需其他代码。
@ServletComponentScan
public class CourseRunBoot {
public static void main(String[] args) {
SpringApplication.run(CourseRunBoot.class, args);
}
}
4.添加生成好的实体类Course到entity包
package cn.xdl.ovls.entity;
import java.util.Date;
public class Course {
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer id;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.name
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private String name;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.intro
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private String intro;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.learn_count
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer learnCount;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.difficulty
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private String difficulty;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.score
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer score;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.image
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private String image;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.publish_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Date publishTime;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.price
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer price;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.subject_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer subjectId;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.direction_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer directionId;
/**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the data column course.learn_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
private Integer learnTime;
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.id
*
* @return the value of course.id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getId() {
return id;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.id
*
* @param id the value for course.id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setId(Integer id) {
this.id = id;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.name
*
* @return the value of course.name
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String getName() {
return name;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.name
*
* @param name the value for course.name
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.intro
*
* @return the value of course.intro
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String getIntro() {
return intro;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.intro
*
* @param intro the value for course.intro
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setIntro(String intro) {
this.intro = intro == null ? null : intro.trim();
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.learn_count
*
* @return the value of course.learn_count
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getLearnCount() {
return learnCount;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.learn_count
*
* @param learnCount the value for course.learn_count
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setLearnCount(Integer learnCount) {
this.learnCount = learnCount;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.difficulty
*
* @return the value of course.difficulty
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String getDifficulty() {
return difficulty;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.difficulty
*
* @param difficulty the value for course.difficulty
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setDifficulty(String difficulty) {
this.difficulty = difficulty == null ? null : difficulty.trim();
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.score
*
* @return the value of course.score
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getScore() {
return score;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.score
*
* @param score the value for course.score
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setScore(Integer score) {
this.score = score;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.image
*
* @return the value of course.image
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String getImage() {
return image;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.image
*
* @param image the value for course.image
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setImage(String image) {
this.image = image == null ? null : image.trim();
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.publish_time
*
* @return the value of course.publish_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Date getPublishTime() {
return publishTime;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.publish_time
*
* @param publishTime the value for course.publish_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setPublishTime(Date publishTime) {
this.publishTime = publishTime;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.price
*
* @return the value of course.price
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getPrice() {
return price;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.price
*
* @param price the value for course.price
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setPrice(Integer price) {
this.price = price;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.subject_id
*
* @return the value of course.subject_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getSubjectId() {
return subjectId;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.subject_id
*
* @param subjectId the value for course.subject_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setSubjectId(Integer subjectId) {
this.subjectId = subjectId;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.direction_id
*
* @return the value of course.direction_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getDirectionId() {
return directionId;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.direction_id
*
* @param directionId the value for course.direction_id
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setDirectionId(Integer directionId) {
this.directionId = directionId;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the data column course.learn_time
*
* @return the value of course.learn_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public Integer getLearnTime() {
return learnTime;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the data column course.learn_time
*
* @param learnTime the value for course.learn_time
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public void setLearnTime(Integer learnTime) {
this.learnTime = learnTime;
}
}
5.添加生成好的dao接口CourseMapper
package cn.xdl.ovls.dao;
import cn.xdl.ovls.entity.Course;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.UpdateProvider;
import org.apache.ibatis.type.JdbcType;
public interface CourseMapper {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@Delete({
\"delete from course\",
\"where id = #{id,jdbcType=INTEGER}\"
})
int deleteByPrimaryKey(Integer id);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@Insert({
\"insert into course (id, name, \",
\"intro, learn_count, \",
\"difficulty, score, \",
\"image, publish_time, \",
\"price, subject_id, \",
\"direction_id, learn_time)\",
\"values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, \",
\"#{intro,jdbcType=VARCHAR}, #{learnCount,jdbcType=INTEGER}, \",
\"#{difficulty,jdbcType=VARCHAR}, #{score,jdbcType=INTEGER}, \",
\"#{image,jdbcType=VARCHAR}, #{publishTime,jdbcType=TIMESTAMP}, \",
\"#{price,jdbcType=INTEGER}, #{subjectId,jdbcType=INTEGER}, \",
\"#{directionId,jdbcType=INTEGER}, #{learnTime,jdbcType=INTEGER})\"
})
int insert(Course record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@InsertProvider(type=CourseSqlProvider.class, method=\"insertSelective\")
int insertSelective(Course record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@Select({
\"select\",
\"id, name, intro, learn_count, difficulty, score, image, publish_time, price, \",
\"subject_id, direction_id, learn_time\",
\"from course\",
\"where id = #{id,jdbcType=INTEGER}\"
})
@Results({
@Result(column=\"id\", property=\"id\", jdbcType=JdbcType.INTEGER, id=true),
@Result(column=\"name\", property=\"name\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"intro\", property=\"intro\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"learn_count\", property=\"learnCount\", jdbcType=JdbcType.INTEGER),
@Result(column=\"difficulty\", property=\"difficulty\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"score\", property=\"score\", jdbcType=JdbcType.INTEGER),
@Result(column=\"image\", property=\"image\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"publish_time\", property=\"publishTime\", jdbcType=JdbcType.TIMESTAMP),
@Result(column=\"price\", property=\"price\", jdbcType=JdbcType.INTEGER),
@Result(column=\"subject_id\", property=\"subjectId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"direction_id\", property=\"directionId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"learn_time\", property=\"learnTime\", jdbcType=JdbcType.INTEGER)
})
Course selectByPrimaryKey(Integer id);
/**
* 免费好课
*/
@Select({
\"select\",
\"id, name, intro, learn_count, difficulty, score, image, publish_time, price, \",
\"subject_id, direction_id, learn_time\",
\"from course\",
\"where price = 0\",
\"order by score desc,learn_count desc\"
})
@Results({
@Result(column=\"id\", property=\"id\", jdbcType=JdbcType.INTEGER, id=true),
@Result(column=\"name\", property=\"name\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"intro\", property=\"intro\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"learn_count\", property=\"learnCount\", jdbcType=JdbcType.INTEGER),
@Result(column=\"difficulty\", property=\"difficulty\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"score\", property=\"score\", jdbcType=JdbcType.INTEGER),
@Result(column=\"image\", property=\"image\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"publish_time\", property=\"publishTime\", jdbcType=JdbcType.TIMESTAMP),
@Result(column=\"price\", property=\"price\", jdbcType=JdbcType.INTEGER),
@Result(column=\"subject_id\", property=\"subjectId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"direction_id\", property=\"directionId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"learn_time\", property=\"learnTime\", jdbcType=JdbcType.INTEGER)
})
List<Course> selectByPrice();
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@UpdateProvider(type=CourseSqlProvider.class, method=\"updateByPrimaryKeySelective\")
int updateByPrimaryKeySelective(Course record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
@Update({
\"update course\",
\"set name = #{name,jdbcType=VARCHAR},\",
\"intro = #{intro,jdbcType=VARCHAR},\",
\"learn_count = #{learnCount,jdbcType=INTEGER},\",
\"difficulty = #{difficulty,jdbcType=VARCHAR},\",
\"score = #{score,jdbcType=INTEGER},\",
\"image = #{image,jdbcType=VARCHAR},\",
\"publish_time = #{publishTime,jdbcType=TIMESTAMP},\",
\"price = #{price,jdbcType=INTEGER},\",
\"subject_id = #{subjectId,jdbcType=INTEGER},\",
\"direction_id = #{directionId,jdbcType=INTEGER},\",
\"learn_time = #{learnTime,jdbcType=INTEGER}\",
\"where id = #{id,jdbcType=INTEGER}\"
})
int updateByPrimaryKey(Course record);
}
添加内容为
/**
* 免费好课
*/
@Select({
\"select\",
\"id, name, intro, learn_count, difficulty, score, image, publish_time, price, \",
\"subject_id, direction_id, learn_time\",
\"from course\",
\"where price = 0\",
\"order by score desc,learn_count desc\"
})
@Results({
@Result(column=\"id\", property=\"id\", jdbcType=JdbcType.INTEGER, id=true),
@Result(column=\"name\", property=\"name\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"intro\", property=\"intro\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"learn_count\", property=\"learnCount\", jdbcType=JdbcType.INTEGER),
@Result(column=\"difficulty\", property=\"difficulty\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"score\", property=\"score\", jdbcType=JdbcType.INTEGER),
@Result(column=\"image\", property=\"image\", jdbcType=JdbcType.VARCHAR),
@Result(column=\"publish_time\", property=\"publishTime\", jdbcType=JdbcType.TIMESTAMP),
@Result(column=\"price\", property=\"price\", jdbcType=JdbcType.INTEGER),
@Result(column=\"subject_id\", property=\"subjectId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"direction_id\", property=\"directionId\", jdbcType=JdbcType.INTEGER),
@Result(column=\"learn_time\", property=\"learnTime\", jdbcType=JdbcType.INTEGER)
})
List<Course> selectByPrice();
6.添加生成好的实现类CourseSqlProvider
package cn.xdl.ovls.dao;
import cn.xdl.ovls.entity.Course;
import org.apache.ibatis.jdbc.SQL;
public class CourseSqlProvider {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String insertSelective(Course record) {
SQL sql = new SQL();
sql.INSERT_INTO(\"course\");
if (record.getId() != null) {
sql.VALUES(\"id\", \"#{id,jdbcType=INTEGER}\");
}
if (record.getName() != null) {
sql.VALUES(\"name\", \"#{name,jdbcType=VARCHAR}\");
}
if (record.getIntro() != null) {
sql.VALUES(\"intro\", \"#{intro,jdbcType=VARCHAR}\");
}
if (record.getLearnCount() != null) {
sql.VALUES(\"learn_count\", \"#{learnCount,jdbcType=INTEGER}\");
}
if (record.getDifficulty() != null) {
sql.VALUES(\"difficulty\", \"#{difficulty,jdbcType=VARCHAR}\");
}
if (record.getScore() != null) {
sql.VALUES(\"score\", \"#{score,jdbcType=INTEGER}\");
}
if (record.getImage() != null) {
sql.VALUES(\"image\", \"#{image,jdbcType=VARCHAR}\");
}
if (record.getPublishTime() != null) {
sql.VALUES(\"publish_time\", \"#{publishTime,jdbcType=TIMESTAMP}\");
}
if (record.getPrice() != null) {
sql.VALUES(\"price\", \"#{price,jdbcType=INTEGER}\");
}
if (record.getSubjectId() != null) {
sql.VALUES(\"subject_id\", \"#{subjectId,jdbcType=INTEGER}\");
}
if (record.getDirectionId() != null) {
sql.VALUES(\"direction_id\", \"#{directionId,jdbcType=INTEGER}\");
}
if (record.getLearnTime() != null) {
sql.VALUES(\"learn_time\", \"#{learnTime,jdbcType=INTEGER}\");
}
return sql.toString();
}
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the data table course
*
* @mbg.generated Mon Dec 10 14:18:46 CST 2018
*/
public String updateByPrimaryKeySelective(Course record) {
SQL sql = new SQL();
sql.UPDATE(\"course\");
if (record.getName() != null) {
sql.SET(\"name = #{name,jdbcType=VARCHAR}\");
}
if (record.getIntro() != null) {
sql.SET(\"intro = #{intro,jdbcType=VARCHAR}\");
}
if (record.getLearnCount() != null) {
sql.SET(\"learn_count = #{learnCount,jdbcType=INTEGER}\");
}
if (record.getDifficulty() != null) {
sql.SET(\"difficulty = #{difficulty,jdbcType=VARCHAR}\");
}
if (record.getScore() != null) {
sql.SET(\"score = #{score,jdbcType=INTEGER}\");
}
if (record.getImage() != null) {
sql.SET(\"image = #{image,jdbcType=VARCHAR}\");
}
if (record.getPublishTime() != null) {
sql.SET(\"publish_time = #{publishTime,jdbcType=TIMESTAMP}\");
}
if (record.getPrice() != null) {
sql.SET(\"price = #{price,jdbcType=INTEGER}\");
}
if (record.getSubjectId() != null) {
sql.SET(\"subject_id = #{subjectId,jdbcType=INTEGER}\");
}
if (record.getDirectionId() != null) {
sql.SET(\"direction_id = #{directionId,jdbcType=INTEGER}\");
}
if (record.getLearnTime() != null) {
sql.SET(\"learn_time = #{learnTime,jdbcType=INTEGER}\");
}
sql.WHERE(\"id = #{id,jdbcType=INTEGER}\");
return sql.toString();
}
}
7.添加测试TestCourseMapper
import java.util.List;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.spring work.beans.factory.annotation.Autowired;
import org.spring work.boot.test.context.SpringBootTest;
import org.spring work.test.context.junit4.SpringRunner;
import com.github.pagehelper.PageHelper;
import cn.xdl.ovls.CourseRunBoot;
import cn.xdl.ovls.dao.CourseMapper;
import cn.xdl.ovls.entity.Course;
@RunWith(SpringRunner.class)
@SpringBootTest(classes={CourseRunBoot.class})
public class TestCourseMapper {
@Autowired
private CourseMapper courseDao;
@Test
public void test1(){
//分页显示,第一页5条
PageHelper.startPage(1,5);
List<Course> list = courseDao.selectByPrice();
for(Course c:list){
System.out.println(c.getId()+\" \"+c.getName());
}
}
}
![\"在这里插入图片描述\"](\"/images/csdn/15450089864V1lQ545008986.png\")
8.添加服务CourseService接口
package cn.xdl.ovls.service;
import cn.xdl.ovls.util.OvlsResult;
public interface CourseService {
public OvlsResult loadFreeCourse(int size);
}
9.添加实现类CourseServiceImpl
package cn.xdl.ovls.service;
import java.util.List;
import org.spring work.beans.factory.annotation.Autowired;
import org.spring work.stereotype.Service;
import com.github.pagehelper.PageHelper;
import cn.xdl.ovls.dao.CourseMapper;
import cn.xdl.ovls.entity.Course;
import cn.xdl.ovls.util.OvlsConstant;
import cn.xdl.ovls.util.OvlsResult;
@Service//扫描
public class CourseServiceImpl implements CourseService {
@Autowired//注入
private CourseMapper courseDao;
public OvlsResult loadFreeCourse(int size) {
//分页显示
PageHelper.startPage(1,size);
//查询价格的集合
List<Course> list = courseDao.selectByPrice();
//构造返回值result
OvlsResult result = new OvlsResult();
//注意,这里要去OvlsResult定义个private data;还有去OvlsConstant这里定义个参数
result.setStatus(OvlsConstant.SUCCESS);
//设置一个data及返回消息
result.setData(list);
result.setMsg(OvlsConstant.QUERY_SUCCESS_MSG);
//返回结果
return result;
}
}
10.添加控制器CourseController
package cn.xdl.ovls.controller;
import org.spring work.beans.factory.annotation.Autowired;
import org.spring work.web.bind.annotation.GetMapping;
import org.spring work.web.bind.annotation.RequestParam;
import org.spring work.web.bind.annotation.RestController;
import cn.xdl.ovls.service.CourseService;
import cn.xdl.ovls.util.OvlsResult;
@RestController
public class CourseController {
@Autowired
private CourseService coursService;
//发出什么请求
@GetMapping(\"/course/free\")
public OvlsResult loadFree(
//设置如果默认没有就调用5条信息
@RequestParam(value=\"size\",required=false,defaultValue=\"5\")int size){
OvlsResult result = coursService.loadFreeCourse(size);
return result;
}
}
测试结果:
![\"在这里插入图片描述\"](\"/images/csdn/154500898715495010t898j7.png\")
异常处理
package cn.xdl.ovls.controller;
import org.spring work.web.bind.annotation.ControllerAdvice;
import org.spring work.web.bind.annotation.ExceptionHandler;
import org.spring work.web.bind.annotation.ResponseBody;
import cn.xdl.ovls.util.OvlsResult;
@ControllerAdvice
public class MyErrorController {
/**
* @ExceptionHandler处理Controller抛出的异常
* @ResponseBody用于将Controller的方法返回的对象,通过适当的HttpMessageConverter转换为指定格式后,写入到Response对象的body数据区
* handlerException处理器异常解析器
* setStatus设置状态
* setMsg设置状态信息
*/
@ExceptionHandler
@ResponseBody
public handlerException(Exception ex){
OvlsResult result = new OvlsResult();
result.setStatus(-1);
result.setMsg(\"系统异常\");
return result;
}
}
![\"在这里插入图片描述\"](\"/images/csdn/154500898715450089asN897.png\")
继续阅读与本文标签相同的文章
下一篇 :
预见能力的一点体验
-
腾讯营收5.99亿美元登顶9月全球移动发行商收入总榜 同比增30％
2026-05-19栏目： 教程
-
黄顺昌：如何到达行业专家水平
2026-05-19栏目： 教程
-
阿里研究员：测试稳定性三板斧，我怎么用？
2026-05-19栏目： 教程
-
马斯克表态：为NASA制造载人龙飞船是SpaceX的首要任务
2026-05-19栏目： 教程
-
英伟达也要进军移动端！推出安卓版GeForceNow云游戏服务
2026-05-19栏目： 教程