这些天我完善了一下项目,现在项目解构如图所示
其中包含四个表,message,sm2user,videomess,videos,各个表结构如下图
其储存的内容是用户和他人消息的信息
其储存的内容是用户基本信息
其储存的是视频留言信息
其储存的是视频信息
其mvc层代码
package com.sm2.liu.config;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
import org.springframework.web.servlet.config.annotation.ViewControllerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class MvcConfig implements WebMvcConfigurer {
@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
registry.addResourceHandler("/**")
.addResourceLocations("classpath:/static/myver/")
.setCachePeriod(0);
}
@Override
public void addViewControllers(ViewControllerRegistry registry) {
registry.addRedirectViewController("/", "/index.html");
}
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/**")
// 允许所有的请求方法
.allowedMethods("*")
// 指定允许访问的源,注意调整为你的前端页面所在的域名或 IP 地址
.allowedOrigins("http://127.0.0.1:8848")
// 允许携带 cookie
.allowCredentials(true)
// 设置缓存时间,单位秒,这里设置为 1 小时
.maxAge(3600);
}
}
其
package com.sm2.liu.controller;
import com.sm2.liu.Service.MessageService;
import com.sm2.liu.Service.UserService;
import com.sm2.liu.Service.VideomessService;
import com.sm2.liu.Service.VideosService;
import com.sm2.liu.Utils.Result;
import com.sm2.liu.domain.Message;
import com.sm2.liu.domain.Sm2user;
import com.sm2.liu.domain.Videomess;
import com.sm2.liu.domain.Videos;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;
@RestController
@RequestMapping("sm2user")
public class Sm2UserController {
@Resource
private UserService userService;
// @Resource
// private FriendsService friendsService;
@Resource
private MessageService messageService;
@Resource
private VideosService videosService;
@Resource
private VideomessService videomessService;
@PostMapping("/login")
public Result<Sm2user> loginController(@RequestParam String uname, @RequestParam String password){
Sm2user user = userService.loginService(uname,password);
if(user!=null){
System.out.println(uname+"登录成功");
return Result.success(user,"登录成功!");
}else {
return Result.error("123","账号或密码错误!");
}
}
@PostMapping("/register")
public Result<Sm2user> registController(@RequestBody Sm2user newUser){
newUser.setUsersm2perm(1);
newUser.setFri("");
newUser.setFna("");
newUser.setUsersm2id(0);
Sm2user user = userService.registService(newUser);
if(user!=null){
return Result.success(user,"注册成功!");
}else{
return Result.error("456","用户名已存在!");
}
}
@PostMapping("/getfriends")
public Result<String> getfriends(@RequestParam String uname1, @RequestParam String uname2){
Long uid1 = userService.nametoid(uname1);
Long uid2 = userService.nametoid(uname2);
if (uid1!=null&&uid2!=null){
String date = userService.sendfrirequest(uid1,uid2);
if (date!=null){
return Result.success(date,"好友请求发送成功");
}else {
return Result.error("456","无好友请求数据");
}
}else {
return Result.error("456","查询朋友错误");
}
}
@PostMapping("/recfriends")
public Result<String> recfriends(@RequestParam String uname){
if (userService.findbyuid(userService.nametoid(uname))!=null){
Sm2user user = userService.findbyuid(userService.nametoid(uname));
String friends = user.getFriends();
String date = userService.parse(friends);
System.out.println(date);
if (date!=null){
return Result.success(date,"查询成功");
}else {
return Result.error("456","无好友请求数据");
}
}
return Result.error("456","查询失败");
}
@PostMapping("/jieshoufri")
public Result<String> jieshoufri(@RequestParam String uname1,@RequestParam String uname2){
Long id1 = userService.nametoid(uname1);
Long id2 = userService.nametoid