基于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管理等等。
@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) {
return courseTestService.getQuestionsByCourseId(courseId);
@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) {
return couponService.getAllAvailableCouponsForOrder(orderId);
}
// 发放优惠券
@PostMapping("/deliver")
ResultVO<Boolean> deliver(@RequestBody DeliverCouponDTO deliverCouponDTO) {
return couponService.deliverCoupon(deliverCouponDTO);
}
}
@RestController
@RequestMapping("/vip")
public class VipController {
@Autowired
VipService vipService;
/**
return courseTestService.deleteTest(courseTestDTO);
}
/**
* 老师获得自己创建的全部测试
* @param teacherId
* @return
*/
@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")
@RestController
@RequestMapping("/course_ware")
public class CourseWareController {
@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);
}
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);
/**
* 老师获得自己创建的全部测试
* @param teacherId
* @return
*/
@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);
}
}
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("/update")
@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){
return userService.getUser(uid);
}
}
@RestController
@RequestMapping("/file")
public class FileController {
@Resource
FileService fileService;
@Service
public class FileServiceImpl implements FileService {
private static final Logger logger = LoggerFactory.getLogger(FileServiceImpl.class);
@Value("${web.file-upload-path}")
private String path;
@Override
public ResultVO<FileInfoVO> uploadFile(MultipartFile file) {
try {
FileInfoVO fileInfoVO = FileHelper.save(path, file);
return new ResultVO<>(Constant.REQUEST_SUCCESS, "文件上传成功", fileInfoVO);
} catch (MyException myException){
logger.error("用于存放上传文件的文件夹不存在或创建失败,请检查路径是否有效", myException);
} catch (IOException ioException){
logger.error("文件复制时出错", ioException);
}
return new ResultVO<>(-1, "服务器错误,请联系网站管理员。");
}
@Override
public void downloadFile(String originName, String newName, HttpServletResponse response) {
InputStream inputStream = null;
OutputStream outputStream = null;
response.setContentType("application/x-msdownload");
try {
Resource resource = FileHelper.loadFileAsResource(path, originName);
if(resource == null)
return;
inputStream = resource.getInputStream();
//1.设置文件ContentType类型
response.setContentType("application/octet-stream;charset=UTF-8");
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);
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}")
public PageInfo<ReplyVO> searchUserReplies(@RequestParam int userId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchUserReplies(userId, pageNo, number);
}
/**
* 根据传入的回复id查询回复
* 更新回复查看状态
*
* @param replyIdList
* @param pageNo
* @param number
* @return
*/
@PostMapping("/search/newReply/{pageNo}/{number}")
public PageInfo<ReplyVO> searchNewReplies(@RequestParam List<Integer> replyIdList, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchNewReplies(replyIdList, pageNo, number);
}
}
return postService.searchUserPosts(userId, pageNo, number);
}
/**
* 查询一个用户的全部回复,返回回复信息以及每个回复有哪些新回复
* 不安全
*
* @param userId
* @return
*/
@GetMapping("/search/userReply/{pageNo}/{number}")
public PageInfo<ReplyVO> searchUserReplies(@RequestParam int userId, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchUserReplies(userId, pageNo, number);
}
/**
* 根据传入的回复id查询回复
* 更新回复查看状态
*
* @param replyIdList
* @param pageNo
* @param number
* @return
*/
@PostMapping("/search/newReply/{pageNo}/{number}")
public PageInfo<ReplyVO> searchNewReplies(@RequestParam List<Integer> replyIdList, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchNewReplies(replyIdList, pageNo, number);
}
}
@RestController
@RequestMapping("/course")
public class CourseController {
@Resource
private CourseService courseService;
* @return
*/
@PostMapping("/search/newReply/{pageNo}/{number}")
public PageInfo<ReplyVO> searchNewReplies(@RequestParam List<Integer> replyIdList, @PathVariable int pageNo, @PathVariable int number) {
return postService.searchNewReplies(replyIdList, pageNo, number);
}
}
@RestController
@RequestMapping("/course")
public class CourseController {
@Resource
private CourseService courseService;
/**
* 查询单一课程
* @param uid 用户id
* @param courseId 课程id
*/
@GetMapping("/{courseId}")
public CourseVO getCourseById(@RequestParam(required = false, defaultValue = "") Integer uid, @PathVariable Integer courseId) {
return courseService.getCourse(courseId, uid);
}
/**
* 获取课程列表
* 如果带参数uid,则需要判断该用户是否购买过课程
* 如果带参数key,则根据关键字返回分页查询结果
* @param uid 用户id
* @param key 关键字
*/
} catch (IOException ioException){
logger.error("文件复制时出错", ioException);
}
return new ResultVO<>(-1, "服务器错误,请联系网站管理员。");
}
@Override
public void downloadFile(String originName, String newName, HttpServletResponse response) {
InputStream inputStream = null;
OutputStream outputStream = null;
response.setContentType("application/x-msdownload");
try {
Resource resource = FileHelper.loadFileAsResource(path, originName);
if(resource == null)
return;
inputStream = resource.getInputStream();
//1.设置文件ContentType类型
response.setContentType("application/octet-stream;charset=UTF-8");
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);
}
}
}
}
if(resource == null)
return;
inputStream = resource.getInputStream();
//1.设置文件ContentType类型
response.setContentType("application/octet-stream;charset=UTF-8");
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
@Service
public class FileServiceImpl implements FileService {
private static final Logger logger = LoggerFactory.getLogger(FileServiceImpl.class);
@Value("${web.file-upload-path}")
private String path;
@Override
public ResultVO<FileInfoVO> uploadFile(MultipartFile file) {
try {
FileInfoVO fileInfoVO = FileHelper.save(path, file);
return new ResultVO<>(Constant.REQUEST_SUCCESS, "文件上传成功", fileInfoVO);
} catch (MyException myException){
logger.error("用于存放上传文件的文件夹不存在或创建失败,请检查路径是否有效", myException);
} catch (IOException ioException){
logger.error("文件复制时出错", ioException);
}
return new ResultVO<>(-1, "服务器错误,请联系网站管理员。");
}
@Override
public void downloadFile(String originName, String newName, HttpServletResponse response) {
InputStream inputStream = null;
OutputStream outputStream = null;
response.setContentType("application/x-msdownload");
try {
Resource resource = FileHelper.loadFileAsResource(path, originName);
if(resource == null)
return;
inputStream = resource.getInputStream();
//1.设置文件ContentType类型
@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) {
return courseTestService.getQuestionsByCourseId(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
@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) {
return couponService.getAllAvailableCouponsForOrder(orderId);
}
// 发放优惠券
@PostMapping("/deliver")
ResultVO<Boolean> deliver(@RequestBody DeliverCouponDTO deliverCouponDTO) {
return couponService.deliverCoupon(deliverCouponDTO);
}
}