基于javaweb+mysql的springboot课程管理系统(java+springboot+vue+maven+mybatis+mysql)
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot课程管理系统(java+springboot+vue+maven+mybatis+mysql)
一、项目运行 环境配置:
Jdk1.8 + Tomcat8.5 + Mysql + HBuilderX(Webstorm也行)+ Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。
项目技术:
Spring + SpringBoot+ mybatis + Maven + Vue 等等组成,B/S模式 + Maven管理等等。
/**
* 根据分类标签,获取课程列表
* 如果带参数uid,则需要判断该用户是否购买过课程、该用户是否为课程的教师
* @param uid 用户id
* @param type 课程类别
*/
@GetMapping("/type/{page}")
public PageInfo<CourseVO> getCoursesByType(@RequestParam(required = false, defaultValue = "") Integer uid,
@RequestParam String type,
@PathVariable Integer page) {
return courseService.getCoursesByType(page, Constant.COURSE_PAGE_SIZE, uid, type);
}
/**
* 分页获取热门课程列表
* @param page 页码数
*/
@GetMapping("/hot/{page}")
public PageInfo<CourseVO> getHotCourses(@PathVariable Integer page, Integer uid) {
return courseService.getHotCourses(page, Constant.COURSE_PAGE_SIZE,uid);
}
/**
* 获取用户拥有的课程列表
* @param sid 学生id
*/
@GetMapping("/sid/{sid}")
public List<CourseVO> getOwnedCourses(@PathVariable Integer sid) {
return courseService.getOwnedCourses(sid);
}
/**
* 获取教师可管理的课程列表
* @param tid 教师id
*/
@GetMapping("/tid/{tid}")
public List<CourseVO> getManageableCourses(@PathVariable Integer tid) {
return courseService.getManageableCourses(tid);
}
/**
* 教师创建课程
* @param course 课程VO
*/
@PostMapping("/create")
public ResultVO<CourseVO> createCourse(@RequestBody CourseVO course) {
return courseService.createCourse(course);
}
return postService.createPost(postDTO);
}
/**
* 查询一门课的全部帖子,返回帖子信息以及每个帖子有哪些新回复
*
* @param courseId
* @param pageNo
* @return
* @Param number
*/
@GetMapping("/search/course/{courseId}/{pageNo}/{number}")
public PageInfo<PostVO> searchPosts(@PathVariable int courseId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchPosts(courseId, pageNo, number);
}
/**
* 删除一门课的某个帖子
*
* @param postDTO
* @return
*/
@PostMapping("/delete")
public ResultVO deletePost(@RequestBody PostDTO postDTO) {
return postService.deletePost(postDTO);
}
/**
* 为一个帖子创建一个回复
*
* @param replyDTO
* @return
*/
@PostMapping("/reply/create")
public ResultVO<ReplyVO> createReply(@RequestBody ReplyDTO replyDTO) {
return postService.createReply(replyDTO);
}
/**
* 查询一个帖子的全部回复,
* 判断是否需要清零新回复数并操作
*
* @param postId
* @param pageNo
* @return
*/
@GetMapping("/search/post/{pageNo}/{number}")
public PageInfo<ReplyVO> searchReplies(@RequestParam int postId, @PathVariable int pageNo, @PathVariable int number, @RequestParam(required = false, defaultValue = "") Integer userId) {
return couponService.deliverCoupon(deliverCouponDTO);
}
}
@RestController
@RequestMapping("/vip")
public class VipController {
@Autowired
VipService vipService;
/**
* 用户查看各种vip的价格
* @return
*/
@ResponseBody
@GetMapping("/price")
public ResultVO<List<VipInfoVO>> getVipPriceInfo(){
return vipService.getVipPriceInfo();
}
/**
* 用户购买vip
* @param vipChargeDTO
* @return
*/
@PostMapping("/get")
public ResultVO<VipChargeVO> chargeVip(@RequestBody VipChargeDTO vipChargeDTO){
return vipService.getVip(vipChargeDTO);
}
}
@RestController
return userService.userRegister(user);
}
@PostMapping("/login")
public ResultVO<UserVO> login(@RequestBody UserFormVO userForm){
return userService.userLogin(userForm.getPhone(), userForm.getPassword());
}
@GetMapping("/{uid}")
public UserVO getUser(@PathVariable Integer uid){
return userService.getUser(uid);
}
}
@RestController
@RequestMapping("/file")
public class FileController {
@Resource
FileService fileService;
@PostMapping("/upload")
public ResultVO<FileInfoVO> upload(@RequestParam("file") MultipartFile file) {
return fileService.uploadFile(file);
}
@GetMapping("/download/{originName:.+}")
public void download(@PathVariable String originName, @RequestParam String newName, HttpServletResponse response) {
fileService.downloadFile(originName, newName, response);
}
}
* @param pageNo
* @return
* @Param number
*/
@GetMapping("/search/course/{courseId}/{pageNo}/{number}")
public PageInfo<PostVO> searchPosts(@PathVariable int courseId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchPosts(courseId, pageNo, number);
}
/**
* 删除一门课的某个帖子
*
* @param postDTO
* @return
*/
@PostMapping("/delete")
public ResultVO deletePost(@RequestBody PostDTO postDTO) {
return postService.deletePost(postDTO);
}
/**
* 为一个帖子创建一个回复
*
* @param replyDTO
* @return
*/
@PostMapping("/reply/create")
public ResultVO<ReplyVO> createReply(@RequestBody ReplyDTO replyDTO) {
return postService.createReply(replyDTO);
}
/**
* 查询一个帖子的全部回复,
* 判断是否需要清零新回复数并操作
*
* @param postId
* @param pageNo
* @return
*/
@GetMapping("/search/post/{pageNo}/{number}")
public PageInfo<ReplyVO> searchReplies(@RequestParam int postId, @PathVariable int pageNo, @PathVariable int number, @RequestParam(required = false, defaultValue = "") Integer userId) {
return postService.searchReplies(postId, pageNo, number, userId);
}
/**
* 创建一个回帖的回复
*
* @param replyDTO
* 查询一门课的全部帖子,返回帖子信息以及每个帖子有哪些新回复
*
* @param courseId
* @param pageNo
* @return
* @Param number
*/
@GetMapping("/search/course/{courseId}/{pageNo}/{number}")
public PageInfo<PostVO> searchPosts(@PathVariable int courseId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchPosts(courseId, pageNo, number);
}
/**
* 删除一门课的某个帖子
*
* @param postDTO
* @return
*/
@PostMapping("/delete")
public ResultVO deletePost(@RequestBody PostDTO postDTO) {
return postService.deletePost(postDTO);
}
/**
* 为一个帖子创建一个回复
*
* @param replyDTO
* @return
*/
@PostMapping("/reply/create")
public ResultVO<ReplyVO> createReply(@RequestBody ReplyDTO replyDTO) {
return postService.createReply(replyDTO);
}
/**
* 查询一个帖子的全部回复,
* 判断是否需要清零新回复数并操作
*
* @param postId
* @param pageNo
* @return
@Resource
private CourseWareService courseWareService;
/**
* 获取单个课件的信息
* @param uid 用户id
* @param courseWareId 课件id
*/
@GetMapping("/{courseWareId}")
public CourseWareVO getCourseWare(@RequestParam(required = false, defaultValue = "") Integer uid,
@PathVariable Integer courseWareId) {
return courseWareService.getCourseWare(uid, courseWareId);
}
/**
* 获取课件列表
* 如果带参数uid,则需要判断该用户是否购买过课程
* @param uid 用户id
* @param courseId 课程id
*/
@GetMapping("/course/{courseId}")
public List<CourseWareVO> getCourseWares(@RequestParam(required = false, defaultValue = "") Integer uid,
@PathVariable Integer courseId) {
return courseWareService.getAllCourseWare(uid, courseId);
}
/**
* 教师创建课件
* @param courseWare 课件VO
*/
@PostMapping("/create")
public ResultVO<CourseWareVO> createCourseWare(@RequestBody CourseWareVO courseWare){
return courseWareService.createCourseWare(courseWare);
}
/**
* 教师更新课件
* @param courseWare 课件VO
*/
@PostMapping("/update")
public ResultVO<CourseWareVO> updateCourseWare(@RequestBody CourseWareVO courseWare){
return courseWareService.updateCourseWare(courseWare);
}
/**
* 教师删除课件
* @param courseWareId 课件Id
*/
@PostMapping("/delete/{courseWareId}")
public ResultVO<String> deleteCourseWare(@PathVariable Integer courseWareId){
return courseWareService.deleteCourseWare(courseWareId);
}
}
*/
@PostMapping("/update")
public ResultVO<CourseWareVO> updateCourseWare(@RequestBody CourseWareVO courseWare){
return courseWareService.updateCourseWare(courseWare);
}
/**
* 教师删除课件
* @param courseWareId 课件Id
*/
@PostMapping("/delete/{courseWareId}")
public ResultVO<String> deleteCourseWare(@PathVariable Integer courseWareId){
return courseWareService.deleteCourseWare(courseWareId);
}
}
@RestController
@RequestMapping("/coupon")
public class CouponController {
@Resource
CouponService couponService;
// 创建优惠券
@PostMapping("/create")
ResultVO<CouponVO> createCoupon(@RequestBody CouponDTO universalCouponDTO) {
return couponService.createCoupon(universalCouponDTO);
}
// 查看所有的优惠券
@GetMapping("/getAll")
ResultVO<List<CouponVO>> getAll() {
return couponService.getAllAvailableCoupons();
}
// 获取订单可用的优惠券
@GetMapping("/getForOrder")
ResultVO<List<CouponVO>> getForOrder(@RequestParam Integer orderId) {
outputStream = response.getOutputStream();
//2.转码 UTF_8为传入的newName编码的格式 ISO_8859_1为浏览器默认编码
String convertName = new String(newName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1);
//3.设置 header Content-Disposition
response.setHeader("Content-Disposition", "attachment; filename=" + convertName);
int b = 0;
byte[] buffer = new byte[2048];
while (b != -1) {
b = inputStream.read(buffer);
if (b != -1) {
outputStream.write(buffer, 0, b);
}
}
} catch (IOException | MyException e) {
logger.error("文件下载时出错", e);
} finally {
try {
if(inputStream != null)
inputStream.close();
if (outputStream != null)
outputStream.close();
} catch (IOException e) {
logger.error("输入流或输出流关闭时出错!", e);
}
}
}
}
@RestController
@RequestMapping("/course_order")
public class CourseOrderController {
@Resource
private CourseOrderService orderService;
@PostMapping("/create")
public ResultVO<CourseOrderVO> createCourseOrder(@RequestParam Integer uid, @RequestParam Integer courseId){
return orderService.createCourseOrder(courseId,uid);
}
/**
* 根据uid查询用户所有的订单,
* 包括购买课程的订单 和 租用课程的订单
*/
* 如果带参数uid,则需要判断该用户是否购买过课程、该用户是否为课程的教师
* @param uid 用户id
* @param type 课程类别
*/
@GetMapping("/type/{page}")
public PageInfo<CourseVO> getCoursesByType(@RequestParam(required = false, defaultValue = "") Integer uid,
@RequestParam String type,
@PathVariable Integer page) {
return courseService.getCoursesByType(page, Constant.COURSE_PAGE_SIZE, uid, type);
}
/**
* 分页获取热门课程列表
* @param page 页码数
*/
@GetMapping("/hot/{page}")
public PageInfo<CourseVO> getHotCourses(@PathVariable Integer page, Integer uid) {
return courseService.getHotCourses(page, Constant.COURSE_PAGE_SIZE,uid);
}
/**
* 获取用户拥有的课程列表
* @param sid 学生id
*/
@GetMapping("/sid/{sid}")
public List<CourseVO> getOwnedCourses(@PathVariable Integer sid) {
return courseService.getOwnedCourses(sid);
}
/**
* 获取教师可管理的课程列表
* @param tid 教师id
*/
@GetMapping("/tid/{tid}")
public List<CourseVO> getManageableCourses(@PathVariable Integer tid) {
return courseService.getManageableCourses(tid);
}
/**
* 教师创建课程
* @param course 课程VO
*/
@PostMapping("/create")
public ResultVO<CourseVO> createCourse(@RequestBody CourseVO course) {
return courseService.createCourse(course);
}
@RestController
@RequestMapping("/course-test")
public class CourseTestController {
@Resource
CourseTestService courseTestService;
/**
* 教师为一门课程创建题目
* @param courseQuestionDTO
* @return
*/
@PostMapping("/questionCreate")
ResultVO<CourseQuestionVO> createQuestion(@RequestBody CourseQuestionDTO courseQuestionDTO) {
return courseTestService.createQuestion(courseQuestionDTO);
}
/**
* 教师修改一门课程的某个题目
* @param courseQuestionDTO
* @return
*/
@PostMapping("/questionFix")
ResultVO<CourseQuestionVO> fixQuestion(@RequestBody CourseQuestionDTO courseQuestionDTO) {
return courseTestService.fixQuestion(courseQuestionDTO);
}
/**
* 教师删除一门课程的某个题目
* @param courseQuestionDTO
* @return
*/
@PostMapping("/questionDelete")
ResultVO deleteQuestion(@RequestBody CourseQuestionDTO courseQuestionDTO) {
return courseTestService.deleteQuestion(courseQuestionDTO);
}
/**
* 教师通过课程Id查找该课程的全部题目
* @param courseId
* @return
*/
@GetMapping("/questionGet/course/{courseId}")
ResultVO<List<CourseQuestionVO>> getQuestionsByCourseId(@PathVariable int courseId) {
}
/**
* 学生查询测试的题目,
* 若已做,则返回每题成绩,答案,解析
* 若未做,则仅返回题目
* @param testId
* @param userId
* @return
*/
@GetMapping("/questionGet/test")
ResultVO<List<CourseQuestionVO>> getQuestionsByTestId(@RequestParam int testId, @RequestParam int userId) {
return courseTestService.getQuestionsByTestId(testId, userId);
}
/**
* 老师查询测试的题目
* 返回每题的全部信息
* @param testId
* @return
*/
@GetMapping("/questionGet/test/{testId}")
ResultVO<List<CourseQuestionVO>> getQuestionsByTestId(@PathVariable int testId) {
return courseTestService.getQuestionsByTestId(testId);
}
/**
* 教师为一门测试添加题目
* @param courseTestQuestionAddDTO
* @return
*/
@PostMapping("/testAddQuestion")
ResultVO addTestQuestion(@RequestBody CourseTestQuestionAddDTO courseTestQuestionAddDTO) {
return courseTestService.addTestQuestion(courseTestQuestionAddDTO);
}
/**
* 教师为一门测试删除题目
* @param courseTestQuestionDeleteDTO
* @return
logger.error("文件下载时出错", e);
} finally {
try {
if(inputStream != null)
inputStream.close();
if (outputStream != null)
outputStream.close();
} catch (IOException e) {
logger.error("输入流或输出流关闭时出错!", e);
}
}
}
}
@RestController
@RequestMapping("/course_order")
public class CourseOrderController {
@Resource
private CourseOrderService orderService;
@PostMapping("/create")
public ResultVO<CourseOrderVO> createCourseOrder(@RequestParam Integer uid, @RequestParam Integer courseId){
return orderService.createCourseOrder(courseId,uid);
}
/**
* 根据uid查询用户所有的订单,
* 包括购买课程的订单 和 租用课程的订单
*/
@GetMapping("/uid/{uid}")
public List<CourseOrderVO> getCourseOrders(@PathVariable Integer uid){
return orderService.getCourseOrders(uid);
}
@GetMapping("/orderId/{orderId}")
public ResultVO<CourseOrderVO> getCourseOrderById(@PathVariable Integer orderId){
return orderService.getCourseOrderById(orderId);
}
*/
@PostMapping("/reply_reply/create")
public ResultVO<ReplyVO> createReply2Reply(@RequestBody ReplyDTO replyDTO) {
return postService.createReply2Reply(replyDTO);
}
/**
* 查询一个回复的回复
* 传入userId
* 判断是否需要清零新回复数并操作
*
* @param repliedId
* @param pageNo
* @return
*/
@GetMapping("/search/reply/{pageNo}/{number}")
public PageInfo<ReplyVO> searchReply2Reply(@RequestParam int repliedId, @PathVariable int pageNo, @PathVariable int number, @RequestParam(required = false, defaultValue = "") Integer userId) {
return postService.searchReply2Reply(repliedId, pageNo, number, userId);
}
/**
* 查询一个用户的全部帖子,返回帖子信息以及每个帖子有哪些新回复
* 不安全
*
* @param userId
* @return
*/
@GetMapping("/search/userPost/{pageNo}/{number}")
public PageInfo<PostVO> searchUserPosts(@RequestParam int userId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchUserPosts(userId, pageNo, number);
}
/**
* 查询一个用户的全部回复,返回回复信息以及每个回复有哪些新回复
* 不安全
*
* @param userId
* @return
*/
@GetMapping("/search/userReply/{pageNo}/{number}")
@GetMapping("/testGet/teacher/{teacherId}")
ResultVO<List<CourseTestVO>> getTestsByTeacherId(@PathVariable int teacherId) {
return courseTestService.getTestsByTeacherId(teacherId);
}
/**
* 学生查询一个课程的全部测试,需要返回测试成绩
*
* @param courseId
* @param userId
* @return
*/
@GetMapping("/testGet/course")
ResultVO<List<CourseTestVO>> getTestsByCourseId(@RequestParam int courseId, @RequestParam int userId) {
return courseTestService.getTestsByCourseId(courseId, userId);
}
/**
* 老师查询一个课程的全部测试
*
* @param courseId
* @return
*/
@GetMapping("/testGet/course/{courseId}")
ResultVO<List<CourseTestVO>> getTestsByCourseId(@PathVariable int courseId) {
return courseTestService.getTestsByCourseId(courseId);
}
}
@RestController
@RequestMapping("/post")
@RequestMapping("/vip")
public class VipController {
@Autowired
VipService vipService;
/**
* 用户查看各种vip的价格
* @return
*/
@ResponseBody
@GetMapping("/price")
public ResultVO<List<VipInfoVO>> getVipPriceInfo(){
return vipService.getVipPriceInfo();
}
/**
* 用户购买vip
* @param vipChargeDTO
* @return
*/
@PostMapping("/get")
public ResultVO<VipChargeVO> chargeVip(@RequestBody VipChargeDTO vipChargeDTO){
return vipService.getVip(vipChargeDTO);
}
}
@RestController
@RequestMapping("/user")
public class UserController {
@Resource
private UserService userService;
@PostMapping("/register")
public ResultVO<UserVO> register(@RequestBody UserVO user){
return userService.userRegister(user);
}
@PostMapping("/login")
public ResultVO<UserVO> login(@RequestBody UserFormVO userForm){
return userService.userLogin(userForm.getPhone(), userForm.getPassword());
}
@GetMapping("/{uid}")
public UserVO getUser(@PathVariable Integer uid){
@RestController
@RequestMapping("/post")
public class PostController {
@Autowired
private PostService postService;
/**
* 为一门课创建一个帖子
*
* @param postDTO
* @return
*/
@PostMapping("/create")
public ResultVO<PostVO> createPost(@RequestBody PostDTO postDTO) {
return postService.createPost(postDTO);
}
/**
* 查询一门课的全部帖子,返回帖子信息以及每个帖子有哪些新回复
*
* @param courseId
* @param pageNo
* @return
* @Param number
*/
@GetMapping("/search/course/{courseId}/{pageNo}/{number}")
public PageInfo<PostVO> searchPosts(@PathVariable int courseId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchPosts(courseId, pageNo, number);
}
/**
* 删除一门课的某个帖子
*
* @param postDTO
* @return
*/
@PostMapping("/delete")