第三个功能:教师上传视频文件+主页推荐视频+视频播放页面
新增数据表:

新增实体类:
Course(课程表)
package Domain;
public class Course {
private String id;
private String course_path;
private String create_userid;
private String course_name;
private String course_describe;
private String first_image;
private String course_type;
private String course_Ttype;
private String course_time;
@Override
public String toString() {
return "Course{" +
"id='" + id + '\'' +
", course_path='" + course_path + '\'' +
", create_userid='" + create_userid + '\'' +
", course_name='" + course_name + '\'' +
", course_describe='" + course_describe + '\'' +
", first_image='" + first_image + '\'' +
", course_type='" + course_type + '\'' +
", course_Ttype='" + course_Ttype + '\'' +
", course_time='" + course_time + '\'' +
", create_time='" + create_time + '\'' +
'}';
}
public void setCourse_time(String course_time) {
this.course_time = course_time;
}
public String getCourse_time() {
return course_time;
}
public String getCourse_Ttype() {
return course_Ttype;
}
public void setCourse_Ttype(String course_Ttype) {
this.course_Ttype = course_Ttype;
}
private String create_time;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getCourse_path() {
return course_path;
}
public void setCourse_path(String course_path) {
this.course_path = course_path;
}
public String getCreate_userid() {
return create_userid;
}
public void setCreate_userid(String create_userid) {
this.create_userid = create_userid;
}
public String getCourse_name() {
return course_name;
}
public void setCourse_name(String course_name) {
this.course_name = course_name;
}
public String getCourse_describe() {
return course_describe;
}
public void setCourse_describe(String course_describe) {
this.course_describe = course_describe;
}
public String getFirst_image() {
return first_image;
}
public void setFirst_image(String first_image) {
this.first_image = first_image;
}
public String getCourse_type() {
return course_type;
}
public void setCourse_type(String course_type) {
this.course_type = course_type;
}
public String getCreate_time() {
return create_time;
}
public void setCreate_time(String create_time) {
this.create_time = create_time;
}
}
CourseJson(存储Course+部分User)
package Domain.json;
import Domain.Course;
public class CourseJson {
Course course = new Course();
private String user_id;
private String nickname;
private String picture;
@Override
public String toString() {
return "CourseJson{" +
"course=" + course +
", user_id='" + user_id + '\'' +
", nickname='" + nickname + '\'' +
", picture='" + picture + '\'' +
'}';
}
public Course getCourse() {
return course;
}
public String getUser_id() {
return user_id;
}
public String getNickname() {
return nickname;
}
public String getPicture() {
return picture;
}
public void setCourse(Course course) {
this.course = course;
}
public void setUser_id(String user_id) {
this.user_id = user_id;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public void setPicture(String picture) {
this.picture = picture;
}
}
新增CourseDao
CourseDaoImpl:
package Dao.Impl;
import Dao.CourseDao;
import Domain.Course;
import Utils.JDBCUtils;
import org.apache.commons.dbutils.QueryRunner;
import