{"id":39602,"date":"2025-05-24T08:06:48","date_gmt":"2025-05-24T00:06:48","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/39602.html"},"modified":"2025-05-24T08:06:48","modified_gmt":"2025-05-24T00:06:48","slug":"%e9%a1%b9%e7%9b%ae%ef%bc%9a%e5%9c%a8%e7%ba%bf%e9%9f%b3%e4%b9%90%e6%92%ad%e6%94%be%e6%9c%8d%e5%8a%a1%e5%99%a8-%e5%9f%ba%e4%ba%8essm%e6%a1%86%e6%9e%b6%e5%92%8cmybatis","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/39602.html","title":{"rendered":"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis"},"content":{"rendered":"

\u4ecb\u7ecd\u9879\u76ee<\/h2>\n

\u9879\u76ee\u4e3b\u8981\u662f\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis\u8fdb\u884c\u5b9e\u73b0<\/p>\n

\u4e3b\u8981\u7684\u529f\u80fd：<\/h2>\n

\u767b\u9646\u754c\u9762，\u7528\u6237\u6ce8\u518c，\u97f3\u4e50\u7684\u64ad\u653e\u5217\u8868，\u5220\u9664\u6307\u5b9a\u7684\u6b4c\u66f2，\u6279\u91cf\u5220\u9664\u6307\u5b9a\u7684\u6b4c\u66f2，\u6536\u85cf\u6b4c\u66f2，\u67e5\u8be2\u6b4c\u66f2，\u4ece\u6536\u85cf\u5217\u8868\u4e2d\u5220\u9664\u6536\u85cf\u97f3\u4e50\u3002<\/p>\n

\u529f\u80fd\u5c55\u793a：<\/h2>\n

\u767b\u5f55\u754c\u9762<\/p>\n

\"\"<\/p>\n

\u7528\u6237\u6ce8\u518c<\/p>\n

\"\"\u00a0<\/p>\n

\u97f3\u4e50\u5217\u8868\"\"<\/p>\n<\/p>\n

\u00a0\u559c\u6b22\u5217\u8868<\/p>\n

\"\"<\/p>\n

\u6dfb\u52a0\u6b4c\u66f2\u00a0<\/p>\n

\"\"<\/p>\n

\u00a0<\/p>\n

\u9996\u5148\u521b\u5efa\u4e00\u4e2aSping Boot\u9879\u76ee<\/p>\n

\u518d\u521b\u5efamusicserver\u6570\u636e\u5e93<\/p>\n

\"\"<\/p>\n

\u6570\u636e\u5e93\u4e00\u5171\u6709\u4e09\u4e2a\u8868：\u6536\u85cf\u6b4c\u66f2\u8868，\u6b4c\u66f2\u8868，\u7528\u6237\u8868<\/p>\n

lovemusic\u8868<\/p>\n

\"\"<\/p>\n

music\u8868<\/p>\n

\"\"<\/p>\n

user\u8868<\/p>\n

\"\"<\/p>\n<\/p>\n

\u5728.yml\u6587\u4ef6\u4e2d\u914d\u7f6e\u6570\u636e\u5e93\u548cxml<\/h2>\n

\"\"<\/p>\n

spring:
\n datasource:
\n url: jdbc:mysql:\/\/127.0.0.1:3306\/musicserver?characterEncoding=utf8&serverTimezone=UTC
\n username: \u4f60\u81ea\u5df1\u7684\u6570\u636e\u5e93\u7528\u6237\u540d
\n password: \u4f60\u81ea\u5df1\u7684\u6570\u636e\u5e93\u5bc6\u7801
\n driver-class-name: com.mysql.cj.jdbc.Driver<\/p>\n

servlet:
\n multipart:
\n max-file-size: 15MB
\n max-request-size: 100MB
\n#\u97f3\u4e50\u4e0a\u4f20\u540e\u7684\u8def\u5f84
\n music:
\n local:
\n path: E:\/music\/<\/p>\n

mybatis:
\n configuration:
\n map-underscore-to-camel-case: true
\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
\n mapper-locations: classpath:mapper\/**.xml
\nlogging:
\n file:
\n name: spring-book.log<\/p>\n

\u521b\u5efa\u9879\u76ee\u7684\u7ed3\u6784\u76ee\u5f55\u00a0<\/h2>\n

\"\"<\/p>\n<\/p>\n

\u767b\u5f55\u6a21\u5757\u7684\u8bbe\u8ba1<\/h2>\n

\u521b\u5efauser\u7c7b<\/h3>\n

\u5bf9\u5e94\u6570\u636e\u5e93\u7684user\u8868，\u521b\u5efa\u7528\u6237\u7684\u5b9e\u4f53\u7c7b<\/p>\n

\"\"<\/p>\n

@Data
\npublic class User {
\n private Integer id;
\n private String username;
\n private String password;
\n} <\/p>\n

\u521b\u5efaUserMapper\u63a5\u53e3<\/h3>\n

@Mapper
\npublic interface UserMapper {
\n User login(User loginUser);<\/p>\n

User selectByName(String username);
\n} <\/p>\n

\u00a0\u521b\u5efaUserMapper.xml<\/h3>\n

<?xml version="1.0" encoding="UTF-8"?>
\n<!DOCTYPE mapper PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"
\n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">
\n<mapper namespace="com.blame.onlinemusicserver.mapper.UserMapper"><\/p>\n

<select id="login" resultType="com.blame.onlinemusicserver.model.User" parameterType="com.blame.onlinemusicserver.model.User">
\n select * from user where username=#{username} and password=#{password}
\n <\/select><\/p>\n

<select id="selectByName" resultType="com.blame.onlinemusicserver.model.User">
\n select * from user where username=#{username}
\n <\/select><\/p>\n

<\/mapper> <\/p>\n

\u5b9e\u73b0\u767b\u5f55\u7684\u8bf7\u6c42\u548c\u54cd\u5e94<\/h3>\n

\"\"<\/p>\n

\u521b\u5efa\u54cd\u5e94\u7c7b\u7684\u5de5\u5177\u7c7b<\/h3>\n

\"\"<\/p>\n

@Data
\npublic class ResponseBodyMessage<T> {
\n private Integer status;
\n private String message;
\n private T data;<\/p>\n

public ResponseBodyMessage(Integer status, String message, T data) {
\n this.status = status;
\n this.message = message;
\n this.data = data;
\n }
\n}<\/p>\n

\u521b\u5efaUserController<\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0@RequestParam：\u5c06\u8bf7\u6c42\u53c2\u6570\u7ed1\u5b9a\u5230\u4f60\u63a7\u5236\u5668\u7684\u2f45\u6cd5\u53c2\u6570\u4e0a，\u5982\u679c\u4f60\u8fd9\u4e2a\u53c2\u6570\u4e0d\u662f\u5fc5\u987b\u8981\u4f20\u7684，@RequestParam(required = false) ，\u9ed8\u8ba4\u662ftrue<\/p>\n

\"\"<\/p>\n

@Slf4j
\n@RestController
\n@RequestMapping("\/user")
\npublic class UserController {<\/p>\n

@Autowired
\n private UserService userService;<\/p>\n

@RequestMapping("\/login")
\n public ResponseBodyMessage<User> login(@RequestParam("username") String username,
\n @RequestParam("password") String password,
\n HttpServletRequest request){
\n ResponseBodyMessage<User> result = userService.login(username, password, request);
\n return result;
\n }
\n} <\/p>\n

\u6211\u4eec\u5728\u767b\u5f55\u65f6\u4f7f\u7528BCrypt\u52a0\u5bc6\u8bbe\u8ba1<\/h3>\n

Bcrypt\u5c31\u662f\u2f00\u6b3e\u52a0\u5bc6\u2f2f\u5177，\u53ef\u4ee5\u2f50\u8f83\u2f45\u4fbf\u5730\u5b9e\u73b0\u6570\u636e\u7684\u52a0\u5bc6\u2f2f\u4f5c\u3002\u53ef\u4ee5\u7b80\u5355\u7406\u89e3\u4e3a\u5b83\u5185\u90e8\u2f83\u2f30\u5b9e\u73b0\u4e86\u968f\u673a\u52a0\u76d0\u5904\u7406<\/p>\n

\u6dfb\u52a0\u5176\u4f9d\u8d56<\/p>\n

<!– security \u4f9d\u8d56\u5305（\u52a0\u5bc6）–>
\n <dependency>
\n <groupId>org.springframework.security<\/groupId>
\n <artifactId>spring-security-web<\/artifactId>
\n <\/dependency>
\n <dependency>
\n <groupId>org.springframework.security<\/groupId>
\n <artifactId>spring-security-config<\/artifactId>
\n <\/dependency> <\/p>\n

\u5728\u9879\u76ee\u7684\u542f\u52a8\u7c7b\u4e2d\u6dfb\u52a0@SpringBootApplication(exclude = \u00a0 \u00a0 \u00a0 \u00a0 {org.springframework.boot.autoconfigure.security.servlet.SecurityAutoConfiguration.class})<\/p>\n

\/\/\u5728@SpringBootApplication\u6ce8\u89e3\u540e\u6dfb\u52a0(exclude =
\n\/\/{org.springframework.boot.autoconfigure.security.servlet.SecurityAutoConfiguration.class})\u7684\u4f5c\u7528：
\n\/\/\u6211\u4eec\u867d\u7136\u5f15\u7528\u4e86 security\u7684\u4f9d\u8d56，\u4f46\u662f\u6211\u4eec\u53ea\u662f\u4f7f\u7528\u4e86\u5b83\u6846\u67b6\u4e2d\u7684\u4e00\u4e2a\u7c7b，\u4e0d\u9002\u7528\u5176\u4ed6\u7684，\u5982\u679c\u4e0d\u6dfb\u52a0\u8fd9\u4e2a\u7684\u8bdd，SpringSecurity\u2f63\u6548\u4e86\u7684，
\n\/\/\u6b64\u65f6\u7684\u63a5\u2f1d\u90fd\u662f\u88ab\u4fdd\u62a4\u7684，\u6211\u4eec\u9700\u8981\u901a\u8fc7\u9a8c\u8bc1\u624d\u80fd\u6b63\u5e38\u7684\u8bbf\u95ee，\u5bfc\u81f4\u6211\u4eec\u65e0\u6cd5\u767b\u5f55
\n@SpringBootApplication(exclude =
\n {org.springframework.boot.autoconfigure.security.servlet.SecurityAutoConfiguration.class})
\npublic class OnlineMusicServerApplication {<\/p>\n

public static void main(String[] args) {
\n SpringApplication.run(OnlineMusicServerApplication.class, args);
\n }<\/p>\n

}<\/p>\n

\u521b\u5efaAppConfig<\/h3>\n

\u5b9a\u4e49config\u5305，\u521b\u5efaAppConfig，\u4f7f\u7528@Configuration\u6ce8\u89e3<\/p>\n

\"\"<\/p>\n

@Configuration
\npublic class AppConfig implements WebMvcConfigurer {<\/p>\n

@Bean
\n public BCryptPasswordEncoder getbCryptPasswordEncoder(){
\n return new BCryptPasswordEncoder();
\n }
\n}<\/p>\n

\u521b\u5efaUserService\u00a0<\/h3>\n

request.getSession(),\u83b7\u53d6\u8fd9\u6b21\u8bf7\u6c42\u7684session\u5bf9\u8c61<\/p>\n

.setAttribute()\u5c06\u7528\u6237\u4fe1\u606f\u5b58\u50a8\u5230session\u4e2d<\/p>\n

\u56e0\u4e3a\u00a0 USERINFO_SESSION_KEY\u00a0 \u8fd9\u4e2a\u5e38\u91cf\u5bb9\u6613\u62fc\u9519，\u6240\u4ee5\u6211\u4eec\u5c06\u5176\u5b9a\u4e49\u5728\u5e38\u91cf\u4fe1\u606f\u4e2d<\/p>\n

\"\"<\/p>\n

@Service
\npublic class UserService {
\n @Autowired
\n private UserMapper userMapper;<\/p>\n

@Autowired
\n private BCryptPasswordEncoder bCryptPasswordEncoder;<\/p>\n

public ResponseBodyMessage<User> login(String username,
\n String password,
\n HttpServletRequest request) {
\n User loginUser=new User();
\n loginUser.setUsername(username);
\n loginUser.setPassword(password);
\n User user=userMapper.selectByName(username);
\n if(user==null){
\n return new ResponseBodyMessage<>(-1,"\u7528\u6237\u4e0d\u5b58\u5728",loginUser);
\n }
\n if(!bCryptPasswordEncoder.matches(password,user.getPassword())){
\n return new ResponseBodyMessage<>(-1,"\u5bc6\u7801\u9519\u8bef，\u8bf7\u91cd\u65b0\u767b\u5f55",loginUser);
\n }else {
\n request.getSession().setAttribute(Constant.USERINFO_SESSION_KEY,user);
\n return new ResponseBodyMessage<>(0,"\u767b\u9646\u6210\u529f",loginUser);
\n }<\/p>\n

}
\n}<\/p>\n

public class Constant {
\n public static final String USERINFO_SESSION_KEY="USERINFO_SESSION_KEY";
\n}<\/p>\n

\u00a0\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n

\u00a0<\/p>\n

\u65b0\u589e\u529f\u80fd：\u6ce8\u518c\u7528\u6237\u529f\u80fd\u7684\u5b9e\u73b0<\/h2>\n

\u4fee\u6539\u6570\u636e\u5e93，\u5728user\u8868\u4e2d\u6dfb\u52a0email<\/p>\n

ALTER TABLE user
\nADD COLUMN email VARCHAR(100) NOT NULL;<\/p>\n

UserMapper<\/h3>\n

void insertUser(User user);
\n <insert id="insertUser">
\n insert into user (username, password, email) VALUES (#{username}, #{password}, #{email})
\n <\/insert> <\/p>\n

UserService<\/h3>\n

\"\"<\/h3>\n

public ResponseBodyMessage<Boolean> register(String username,String password,String email){
\n User existUser=userMapper.selectByName(username);
\n if(existUser!=null){
\n return new ResponseBodyMessage<>(-1,"\u8be5\u7528\u6237\u5b58\u5728",false);
\n }
\n\/\/ \u5c06\u6ce8\u518c\u7684\u5bc6\u7801\u8fdb\u884c\u52a0\u5bc6
\n String encoderPassword=bCryptPasswordEncoder.encode(password);
\n User user=new User();
\n user.setUsername(username);
\n user.setPassword(encoderPassword);
\n user.setEmail(email);
\n userMapper.insertUser(user);
\n return new ResponseBodyMessage<>(0,"\u6ce8\u518c\u6210\u529f",true);
\n} <\/p>\n

UserController<\/h3>\n

\u4f7f\u7528@Valid\u6765\u6821\u9a8c\u53c2\u6570<\/p>\n

\u4f7f\u7528@Valid\u8bb0\u5f97\u6dfb\u52a0\u5176\u4f9d\u8d56<\/p>\n

<dependency>
\n <groupId>jakarta.validation<\/groupId>
\n <artifactId>jakarta.validation-api<\/artifactId>
\n <version>3.0.2<\/version>
\n <\/dependency>
\n <dependency>
\n <groupId>org.hibernate.validator<\/groupId>
\n <artifactId>hibernate-validator<\/artifactId>
\n <version>8.0.0.Final<\/version>
\n <\/dependency> <\/p>\n

\u5b9a\u4e49RequestRegister\u6765\u8fdb\u884c\u8bf7\u6c42\u6570\u636e\u7684\u5c01\u88c5<\/p>\n

@Data
\npublic class RequestRegister {<\/p>\n

@Size(min = 3, max = 20, message = "\u7528\u6237\u540d\u957f\u5ea6\u5e94\u57283\u523020\u4e2a\u5b57\u7b26\u4e4b\u95f4")
\n @NotBlank(message = "username\u4e0d\u80fd\u4e3a\u7a7a")
\n private String username;<\/p>\n

@NotBlank(message = "password\u4e0d\u80fd\u4e3a\u7a7a")
\n private String password;<\/p>\n

@Email(message = "\u90ae\u7bb1\u683c\u5f0f\u4e0d\u6b63\u786e")
\n @NotBlank(message = "email\u4e0d\u80fd\u4e3a\u7a7a")
\n private String email;
\n}<\/p>\n

@RequestMapping("\/register")
\n public ResponseBodyMessage<Boolean> register(@Valid @RequestBody RequestRegister requestRegister){
\n return userService.register(requestRegister.getUsername(), requestRegister.getPassword(), requestRegister.getEmail());
\n }
\n} <\/p>\n

\u00a0<\/p>\n

\u4e0a\u4f20\u97f3\u4e50\u6a21\u5757\u7684\u5b9e\u73b0\u00a0<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

\u5b9a\u4e49music\u5b9e\u4f53\u7c7b<\/h3>\n

\u5bf9\u5e94\u6570\u636e\u5e93\u4e2d\u7684music\u8868\u7684\u5b57\u6bb5<\/p>\n

\"\"<\/p>\n

@Data
\npublic class Music {
\n private Integer id;
\n private String title;
\n private String singer;
\n private String time;
\n private String url;
\n private Integer userid;<\/p>\n

} <\/p>\n

\u5b9a\u4e49MusicController<\/h3>\n

\u5c06\u97f3\u4e50\u6587\u4ef6\u4e0a\u4f20\u5230\u8fd9\u4e2a\u8def\u5f84<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Slf4j
\n@RestController
\n@RequestMapping("\/music")
\npublic class MusicController {<\/p>\n

@Autowired
\n private MusicService musicService;<\/p>\n

@RequestMapping("\/upload")
\n public ResponseBodyMessage<Boolean> insertMusic(@RequestParam String singer,
\n @RequestParam("filename") MultipartFile file,
\n HttpServletRequest request,
\n HttpServletResponse response){
\n return musicService.insertMusic(singer, file, request, response);<\/p>\n

}
\n} <\/p>\n

\u5b9a\u4e49MusicService<\/h3>\n<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

@Slf4j
\n@Service
\npublic class MusicService {<\/p>\n

@Value("${spring.music.local.path}")
\n private String SAVE_PATH;<\/p>\n

@Autowired
\n private MusicMapper mapper;<\/p>\n

@Autowired
\n private LoveMusicMapper loveMusicMapper;<\/p>\n

\/\/\u6dfb\u52a0\u97f3\u4e50
\n public ResponseBodyMessage<Boolean> insertMusic(String singer,
\n MultipartFile file,
\n HttpServletRequest request,
\n HttpServletResponse response){
\n \/\/1.\u68c0\u67e5\u767b\u5f55
\n HttpSession session=request.getSession(false);
\n if(session==null || session.getAttribute(Constant.USERINFO_SESSION_KEY)==null){
\n log.error("\u672a\u767b\u5f55，\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");
\n return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);<\/p>\n

}
\n \/\/2.\u68c0\u67e5\u6570\u6570\u636e\u5e93\u4e2d\u662f\u5426\u6709\u6b64\u97f3\u4e50<\/p>\n

\/\/\u5f97\u5230\u6587\u4ef6\u7684\u540d\u5b57\u548c\u7c7b\u578b
\n String fileNameAndType=file.getOriginalFilename();
\n System.out.println("fileNameAndType"+fileNameAndType);
\n \/\/\u4ee5 . \u5c06\u540d\u5b57\u548c\u7c7b\u578b\u5206\u5f00，\u5f97\u5230title
\n if(fileNameAndType==null || !fileNameAndType.contains(".")){
\n return new ResponseBodyMessage<>(0,"\u6587\u4ef6\u4e0d\u5408\u6cd5，\u5fc5\u987b\u5305\u542b\u62d3\u5c55\u540d",false);
\n }
\n String title=fileNameAndType.substring(0,fileNameAndType.lastIndexOf("."));<\/p>\n

log.info("Checking if music exists: title = {}, singer = {}", title, singer);
\n \/\/\u5224\u65ad\u6570\u636e\u5e93\u4e2d\u662f\u5426\u6709\u6b64\u6b4c\u66f2
\n Integer exist= mapper.selectByTitleAndSinger(title,singer);
\n if(exist!=null && exist>0){
\n return new ResponseBodyMessage<>(0,"\u6570\u636e\u5e93\u4e2d\u5df2\u7ecf\u5b58\u5728\u6b64\u97f3\u4e50",false);
\n }<\/p>\n

\/\/3..\u4e0a\u4f20\u97f3\u4e50\u5230\u670d\u52a1\u5668
\n String path=SAVE_PATH + fileNameAndType;
\n File dest=new File(path);
\n System.out.println("dest"+dest.getPath());
\n if(!dest.exists()){<\/p>\n

dest.mkdirs();
\n }
\n \/\/\u4e0a\u4f20\u6587\u4ef6\u5230\u76ee\u6807
\n try {
\n file.transferTo(dest);
\n log.info("\u670d\u52a1\u5668\u4e0a\u4f20\u6210\u529f");
\n } catch (IOException e) {
\n throw new RuntimeException(e);
\n }<\/p>\n

\/\/\u5c06\u6b4c\u66f2\u4e0a\u4f20\u5230\u6570\u636e\u5e93
\n SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd");
\n String time=sf.format(new Date());<\/p>\n

String url="music\/get?path="+title;
\n User user=(User) session.getAttribute(Constant.USERINFO_SESSION_KEY);
\n int userId=user.getId();<\/p>\n

try {
\n int ret= mapper.insert(title,singer,time,url,userId);<\/p>\n

if(ret==1){
\n response.sendRedirect("\/list.html");
\n return new ResponseBodyMessage<>(1,"\u6570\u636e\u5e93\u4e0a\u4f20\u6210\u529f",true);
\n }else {<\/p>\n

return new ResponseBodyMessage<>(-1,"\u6570\u636e\u5e93\u4e0a\u4f20\u5931\u8d25",false);
\n }
\n }catch (BindingException e){
\n boolean delete= dest.delete();
\n if(delete){
\n log.info("\u6570\u636e\u5e93\u63d2\u5165\u5931\u8d25，\u5df2\u6210\u529f\u5220\u9664\u670d\u52a1\u5668\u4e0a\u7684\u97f3\u4e50\u6587\u4ef6");
\n }else{
\n log.warn("\u6570\u636e\u5e93\u63d2\u5165\u5931\u8d25，\u672a\u5220\u9664\u670d\u52a1\u5668\u4e0a\u7684\u97f3\u4e50\u6587\u4ef6，\u53ef\u80fd\u9700\u8981\u624b\u52a8\u5220\u9664:{}",dest.getAbsolutePath());
\n }
\n return new ResponseBodyMessage<>(-1,"\u6570\u636e\u5e93\u4e0a\u4f20\u5931\u8d25,\u5728\u670d\u52a1\u5668\u4e2d\u5220\u9664\u97f3\u4e50",false);
\n } catch (IOException e) {
\n throw new RuntimeException(e);
\n }
\n } <\/p>\n

\u65b0\u589e\u65b9\u6cd5：\u5224\u65ad\u4e0a\u4f20\u7684\u6587\u4ef6\u662f\u5426\u662fMP3\u7684\u5f62\u5f0f<\/h3>\n

\u6211\u4eec\u9700\u8981\u5bf9\u4e0a\u4f20\u7684\u6587\u4ef6\u8fdb\u884cMP3\u6587\u4ef6\u7c7b\u578b\u68c0\u6d4b，\u5305\u62ec\u6587\u4ef6\u6269\u5c55\u540d\u548cMIME\u7c7b\u578b\u7684\u4e24\u79cd\u68c0\u67e5<\/p>\n

\u6587\u4ef6\u62d3\u5c55\u540d\u662f\u6587\u4ef6\u540d\u79f0\u7684\u4e00\u90e8\u5206，\u5b83\u53ef\u4ee5\u8f7b\u6613\u88ab\u4fee\u6539，\u4ece\u800c\u4f2a\u88c5\u6210\u53e6\u4e00\u79cd\u6587\u4ef6<\/p>\n

MIME\u7c7b\u578b\u662f\u4e00\u79cd\u8868\u793a\u6587\u4ef6\u7c7b\u578b\u548c\u683c\u5f0f\u7684\u6807\u51c6，\u6bd4\u62d3\u5c55\u540d\u66f4\u52a0\u53ef\u9760<\/p>\n

\"\"<\/p>\n

\/\/\u6839\u636e\u6587\u4ef6\u7684\u62d3\u5c55\u540d\u6765\u5224\u65ad\u662f\u5426\u4e3a.MP3\u6587\u4ef6
\n String extension=fileNameAndType.substring(fileNameAndType.lastIndexOf(".")).toLowerCase();
\n if(!extension.equals(".mp3")){
\n return new ResponseBodyMessage<>(-0,"\u53ea\u652f\u6301MP3\u6587\u4ef6\u4e0a\u4f20",false);
\n }
\n \/\/\u6839\u636eMINE\u5224\u65ad
\n try {
\n String mimeType=file.getContentType();
\n log.info("\u6587\u4ef6\u7684MINI\u7c7b\u578b:{}",mimeType);
\n if(mimeType==null || !mimeType.equals("audio\/mpeg")){
\n return new ResponseBodyMessage<>(0,"\u6587\u4ef6\u683c\u5f0f\u4e0d\u6b63\u786e,\u53ea\u652f\u6301MP3\u97f3\u9891\u4e0a\u4f20",false);
\n }
\n }catch (Exception e){
\n log.error("\u6587\u4ef6\u68c0\u9a8c\u5f02\u5e38:{}",e.getMessage());
\n return new ResponseBodyMessage<>(0,"\u6587\u4ef6\u7c7b\u578b\u68c0\u9a8c\u5f02\u5e38",false);<\/p>\n

} <\/p>\n

\"\"\u00a0<\/p>\n

\u4e0a\u4f20\u6570\u636e\u5e93\u7684\u5b9e\u73b0<\/h3>\n

@Mapper
\npublic interface MusicMapper {<\/p>\n

Integer insert(String title,String singer,String time,String url,Integer userid);
\n}
\n<?xml version="1.0" encoding="UTF-8"?>
\n<!DOCTYPE mapper PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"
\n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">
\n<mapper namespace="com.blame.onlinemusicserver.mapper.MusicMapper"><\/p>\n

<insert id="insert">
\n insert into music (title,singer,time,url,userid) values (#{title},#{singer},#{time},#{url},#{userid})
\n <\/insert> <\/p>\n

\u6d4b\u8bd5<\/p>\n

\"\"\"\"<\/p>\n<\/p>\n

\u64ad\u653e\u2fb3\u4e50\u6a21\u5757\u8bbe\u8ba1\u00a0<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

\u5728MusicController\u4e2d\u65b0\u589eget\u65b9\u6cd5<\/h3>\n

\"\"<\/p>\n

\u662fSpring\u6846\u67b6\u4e2d\u7528\u4e8e\u6784\u5efaHttp\u54cd\u5e94\u7684\u5bf9\u8c61<\/p>\n

\u8fd9\u91cc\u8fd4\u56de\u7684\u662f\u4e00\u4e2a\u5b57\u8282\u6570\u7ec4，\u901a\u5e38\u7528\u4e8e\u4f20\u8f93\u4e8c\u8fdb\u5236\u7684\u6570\u636e，\u56fe\u7247，\u97f3\u9891<\/p>\n

\u6211\u4eec\u5728\u8fd9\u65f6\u4f20\u5165\u7684\u662f\u97f3\u9891<\/p>\n

@GetMapping("\/get")
\n public ResponseEntity<byte[]> get(@RequestParam String path){
\n return musicService.get(path);
\n }<\/p>\n

MsuicService<\/h3>\n

ResponseEntity\u5bf9\u8c61\u662fSpring\u5bf9\u8bf7\u6c42\u54cd\u5e94\u7684\u5c01\u88c5\u3002\u5b83\u7ee7\u627f\u4e86HttpEntity\u5bf9\u8c61，\u5305\u542b\u4e86Http\u7684\u54cd\u5e94\u7801 （httpstatus）\u3001\u54cd\u5e94\u5934（header）\u3001\u54cd\u5e94\u4f53(body)\u4e09\u4e2a\u90e8\u5206\u3002<\/p>\n

\"\"<\/p>\n

\/\/\u64ad\u653e\u97f3\u4e50
\n public ResponseEntity<byte[]> get(String path){
\n File file=new File(SAVE_PATH+path);
\n if(!file.exists()){
\n return ResponseEntity.notFound().build();
\n }
\n try {
\n byte[] bytes= Files.readAllBytes(file.toPath());
\n HttpHeaders headers=new HttpHeaders();
\n headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);
\n headers.setContentLength(bytes.length);
\n return ResponseEntity.ok().headers(headers).body(bytes);
\n } catch (IOException e) {
\n e.printStackTrace();
\n return ResponseEntity.internalServerError().build();
\n }
\n } <\/p>\n

\u00a0\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n<\/p>\n

\u5220\u9664\u2fb3\u4e50\u6a21\u5757\u8bbe\u8ba1<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

\u5b9e\u73b0MusicMapper<\/h3>\n

Integer deleteMusicById(Integer musicId);<\/p>\n

Music selectMusicById(Integer musicId);
\n <delete id="deleteMusicById">
\n delete from music where id=#{id}
\n <\/delete><\/p>\n

<select id="selectMusicById" resultType="com.blame.onlinemusicserver.model.Music">
\n select * from music where id=#{id}
\n <\/select> <\/p>\n

\u5b9e\u73b0MusicController<\/h3>\n

\u6839\u636eId\u6765\u8fdb\u884c\u5220\u9664<\/p>\n

@RequestMapping("\/delete")
\n public ResponseBodyMessage<Boolean> deleteMusicById(@RequestParam Integer id){
\n return musicService.deleteMusicById(id);
\n } <\/p>\n

\u5b9e\u73b0MusicService\u00a0<\/h3>\n

\"\"<\/p>\n

\u5982\u679c\u8981\u5c06\u4e00\u4e2a\u6b4c\u66f2\u5220\u9664，\u9700\u8981\u5224\u65ad\u5b83\u662f\u5426\u5728\u6536\u85cf\u6b4c\u66f2\u4e2d，\u5982\u679c\u5728，\u5219\u9700\u8981\u5c06\u5176\u4ece\u6536\u85cf\u97f3\u4e50\u4e2d\u5220\u9664\u00a0<\/p>\n

Boolean deleteLoveMusicByMusicId(Integer musicId);<\/p>\n

Boolean selectLoveMusicByMusicId(Integer musicId); <\/p>\n

\"\"<\/p>\n

\u5224\u65ad\u5220\u9664\u662f\u5426\u6210\u529f<\/p>\n

\u00a0\"\"<\/p>\n

\/\/\u5220\u9664\u97f3\u4e50
\n public ResponseBodyMessage<Boolean> deleteMusicById(Integer id){
\n Music music=mapper.selectMusicById(id);
\n if(music==null){
\n return new ResponseBodyMessage<>(0,"\u8be5\u97f3\u4e50\u4e0d\u5b58\u5728，\u65e0\u6cd5\u5220\u9664",false);
\n }
\n \/\/\u6b64\u65f6integer\u8868\u793a\u5220\u9664\u7684\u884c\u6570，\u5982\u679c\u884c\u6570\u53c80\u53d8\u4e3a1\u5219\u8868\u793a\u5df2\u7ecf\u8fdb\u884c\u4e86\u5220\u9664\u7684\u6b65\u9aa4
\n Integer integer = mapper.deleteMusicById(id);
\n Boolean isLoved = loveMusicMapper.selectLoveMusicByMusicId(id);
\n if (isLoved != null && isLoved) {
\n \/\/ \u5982\u679c\u5728\u6536\u85cf\u4e2d，\u5220\u9664\u6536\u85cf\u8bb0\u5f55
\n loveMusicMapper.deleteLoveMusicByMusicId(id);
\n } else {
\n log.info("\u6b4c\u66f2\u4e0d\u5728\u6536\u85cf\u97f3\u4e50\u4e2d");
\n }
\n if(integer==1){
\n String title=music.getTitle();
\n File file=new File(SAVE_PATH+File.separator+ title+".mp3");
\n boolean delete=file.delete();<\/p>\n

if(delete){
\n log.info("\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u6210\u529f");
\n return new ResponseBodyMessage<>(1,"\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u6210\u529f",true);
\n }else {
\n log.error("\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u5931\u8d25");
\n return new ResponseBodyMessage<>(-1,"\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u5931\u8d25",false);
\n }
\n }
\n return new ResponseBodyMessage<>(-1,"\u97f3\u4e50\u5220\u9664\u5931\u8d25",false);
\n } <\/p>\n

\u00a0\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n

\u6279\u91cf\u5220\u9664\u9009\u4e2d\u7684\u2fb3\u4e50<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

\u5b9e\u73b0MusicController<\/p>\n

\u53ea\u9700\u8981\u5148\u521a\u521a\u5355\u9996\u6b4c\u66f2\u5220\u9664\u7684\u57fa\u7840\u4e0a，\u5728\u5916\u5c42\u5957\u4e00\u5c42for\u5faa\u73af，\u4f9d\u6b21\u8fdb\u884c\u5220\u9664，\u77e5\u9053for\u5faa\u73af\u7ed3\u675f，\u5220\u9664\u5168\u90e8\u7684\u6b4c\u66f2<\/p>\n

\"\"<\/p>\n

public ResponseBodyMessage<Boolean> deleteMusicByIdMany(List<Integer> id){
\n System.out.println("\u6240\u6709\u7684Id: " + id);
\n int sum=0;
\n for (int i = 0; i < id.size(); i++) {
\n int musicId=id.get(i);
\n Music music=mapper.selectMusicById(musicId);
\n Boolean isLoved = loveMusicMapper.selectLoveMusicByMusicId(musicId);
\n if (isLoved != null && isLoved) {
\n \/\/ \u5982\u679c\u5728\u6536\u85cf\u4e2d，\u5220\u9664\u6536\u85cf\u8bb0\u5f55
\n loveMusicMapper.deleteLoveMusicByMusicId(musicId);
\n } else {
\n log.info("\u6b4c\u66f2\u4e0d\u5728\u6536\u85cf\u97f3\u4e50\u4e2d");
\n }
\n System.out.println("\u5f53\u524d\u6b63\u5728\u5904\u7406\u7684 ID: " + id);
\n if(music==null){
\n log.error("\u8be5\u6b4c\u66f2\u4e0d\u5b58\u5728");
\n continue;
\n }
\n \/\/\u6b64\u65f6integer\u8868\u793a\u5220\u9664\u7684\u884c\u6570，\u5982\u679c\u884c\u6570\u53c80\u53d8\u4e3a1\u5219\u8868\u793a\u5df2\u7ecf\u8fdb\u884c\u4e86\u5220\u9664\u7684\u6b65\u9aa4
\n Integer integer = mapper.deleteMusicById(musicId);
\n if(integer==1){
\n String title=music.getTitle();
\n File file=new File(SAVE_PATH+File.separator+ title+".mp3");
\n boolean delete=file.delete();
\n if(delete){
\n sum+=integer;
\n log.info("\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u6210\u529f");
\n }else {
\n log.error("\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u5220\u9664\u5931\u8d25");
\n }
\n }else {
\n log.error("\u6570\u636e\u5e93\u5220\u9664\u5931\u8d25");
\n }
\n }
\n if(sum==id.size()){
\n log.info("\u6279\u91cf\u5220\u9664\u6210\u529f");
\n return new ResponseBodyMessage<>(1,"\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u6279\u91cf\u5220\u9664\u6210\u529f",true);
\n }else {
\n log.info("\u6279\u91cf\u5220\u9664\u5931\u8d25");
\n return new ResponseBodyMessage<>(-1,"\u670d\u52a1\u5668\u4e2d\u97f3\u4e50\u6279\u91cf\u5220\u9664\u5931\u8d25",false);
\n }
\n } <\/p>\n

\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n

\u67e5\u8be2\u2fb3\u4e50\u6a21\u5757\u8bbe\u8ba1<\/p>\n

\u529f\u80fd：\u652f\u6301\u6a21\u7cca\u67e5\u8be2，\u652f\u6301\u8f93\u5165\u7684\u53c2\u6570\u4e3a\u7a7a<\/p>\n

\u8f93\u5165\u53c2\u6570\u4e3a\u7a7a\u65f6，\u67e5\u51fa\u6240\u6709\u7684\u6b4c\u66f2<\/p>\n

\"\"\"\"<\/p>\n

MusicMapper<\/h3>\n

\u4e00\u4e2a\u662f\u6839\u636e\u6b4c\u540d\u8fdb\u884c\u67e5\u8be2，\u53e6\u4e00\u4e2a\u662f\u67e5\u8be2\u5168\u90e8\u7684\u6b4c\u66f2<\/p>\n

List<Music> findMusicByTitle(String name);<\/p>\n

List<Music> findMusic(); <\/p>\n

MusicController\u00a0<\/h3>\n

@RequestParam\u4e0d\u4f20\u9012\u53c2\u6570\u65f6\u5019，\u53ef\u4ee5\u4e3a\u7a7a\u00a0<\/p>\n

@RequestMapping("\/findmusic")
\n public ResponseBodyMessage<List<Music>> findMusic(@RequestParam(required = false) String musicName){
\n return musicService.findMusic(musicName);
\n } <\/p>\n

MusicService\u00a0<\/h3>\n

\"\"<\/p>\n

public ResponseBodyMessage<List<Music>> findMusic(String musicName){
\n List<Music> musics=null;
\n \/\/musicName!=null\u662f\u5224\u65ad\u4f20\u5165\u7684\u6b4c\u66f2\u540d\u662f\u5426\u4e3a\u7a7a
\n \/\/musicName.trim().isEmpty()\u662f\u53bb\u6389\u524d\u540e\u7684\u7a7a\u683c，\u5224\u65ad\u5b57\u7b26\u4e32\u662f\u5426\u4e3a\u7a7a，\u52a0\u4e0a\u8fd9\u4e2a\u66f4\u52a0\u7684\u4e25\u8c28
\n if(musicName!=null && !musicName.trim().isEmpty()){
\n log.info("\u5df2\u627e\u5230\u8be5\u6b4c\u66f2");
\n musics=mapper.findMusicByTitle(musicName);
\n if(musics.isEmpty()){
\n return new ResponseBodyMessage<>(-1,"\u6ca1\u6709\u627e\u5230\u8be5\u6b4c\u66f2",musics);
\n }
\n return new ResponseBodyMessage<>(1,"\u6210\u529f\u627e\u5230\u8be5\u6b4c\u66f2",musics);
\n }else {
\n log.info("\u627e\u5230\u5168\u90e8\u7684\u6b4c\u66f2");
\n musics=mapper.findMusic();
\n return new ResponseBodyMessage<>(1,"\u6210\u529f\u627e\u5230\u5168\u90e8\u7684\u6b4c\u66f2",musics);
\n }
\n } <\/p>\n

\u9a8c\u8bc1<\/p>\n

\u8f93\u5165\u4e3a\u7a7a，\u67e5\u8be2\u5168\u90e8\u7684\u6b4c\u66f2<\/p>\n

\"\"<\/p>\n

\u8f93\u5165\u4e0d\u4e3a\u7a7a，\u67e5\u8be2\u5355\u4e2a\u6b4c\u66f2<\/p>\n

\"\"<\/p>\n

\u00a0<\/p>\n

\u6dfb\u52a0\u2fb3\u4e50\u2f84\u559c\u6b22\u7684\u5217\u8868\u6a21\u5757\u8bbe\u8ba1\u00a0<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

LoveMusicMapper<\/h3>\n

@Mapper
\npublic interface LoveMusicMapper {<\/p>\n

\/\/\u68c0\u67e5\u8be5\u97f3\u4e50\u662f\u5426\u5df2\u7ecf\u88ab\u6536\u85cf
\n Music selectMusicIsExist(Integer userId,Integer musicId);<\/p>\n

\/\/\u5c06\u8be5\u97f3\u4e50\u52a0\u5165\u6536\u85cf\u5939
\n Boolean insertLoveMusic(Integer userId,Integer musicId);
\n}
\n<select id="selectMusicIsExist" resultType="com.blame.onlinemusicserver.model.Music">
\n select * from lovemusic where user_id=#{userId} and music_id=#{musicId}
\n <\/select><\/p>\n

<insert id="insertLoveMusic">
\n insert into lovemusic (user_id,music_id) values (#{userId},#{musicId})
\n <\/insert> <\/p>\n

\u00a0<\/p>\n

LoveMusicController<\/h3>\n

@RestController
\n@RequestMapping("\/lovemusic")
\npublic class LoveMusicController {<\/p>\n

@Autowired
\n private LoveMusicService loveMusicService;<\/p>\n

@RequestMapping("addLikeMusic")
\n public ResponseBodyMessage<Boolean> addLikeMusic(@RequestParam String id,HttpServletRequest request){
\n return loveMusicService.addLikeMusic(id,request);
\n }
\n} <\/p>\n

LoveMusicService<\/h3>\n

\"\"<\/p>\n

@Slf4j
\n@Service
\npublic class LoveMusicService {<\/p>\n

@Autowired
\n private LoveMusicMapper loveMusicMapper;<\/p>\n

\/\/\u6dfb\u52a0\u6536\u85cf
\n public ResponseBodyMessage<Boolean> addLikeMusic(String id,HttpServletRequest request){<\/p>\n

Integer musicId=Integer.parseInt(id);
\n System.out.println("musicId"+musicId);<\/p>\n

\/\/1.\u68c0\u67e5\u767b\u5f55
\n HttpSession session=request.getSession(false);
\n if(session==null || session.getAttribute(Constant.USERINFO_SESSION_KEY)==null){
\n log.error("\u672a\u767b\u5f55，\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");
\n return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);
\n }
\n User user =(User) session.getAttribute(Constant.USERINFO_SESSION_KEY);<\/p>\n

Integer userId=user.getId();
\n System.out.println("userId"+userId);<\/p>\n

Music music=loveMusicMapper.selectMusicIsExist(userId,musicId);<\/p>\n

if(music!=null){
\n return new ResponseBodyMessage<>(-1,"\u8be5\u97f3\u4e50\u5df2\u7ecf\u52a0\u5165\u4e86\u6536\u85cf\u5939",false);
\n }
\n Boolean successAdd=loveMusicMapper.insertLoveMusic(userId,musicId);
\n if(successAdd){
\n return new ResponseBodyMessage<>(1,"\u97f3\u4e50\u52a0\u5165\u6536\u85cf\u5939\u6210\u529f",true);
\n }
\n return new ResponseBodyMessage<>(-1,"\u97f3\u4e50\u52a0\u5165\u6536\u85cf\u5939\u5931\u8d25",false);
\n } <\/p>\n

\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n

\u67e5\u8be2\u559c\u6b22\u7684\u2fb3\u4e50\u6a21\u5757\u8bbe\u8ba1<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

LoveMusicMapper<\/h3>\n

\/\/\u6839\u636e\u7528\u6237\u4fe1\u606f\u67e5\u8be2\u6536\u85cf\u7684\u6b4c\u66f2，\u652f\u6301\u6a21\u7cca\u67e5\u8be2
\n List<Music> findLoveMusicByUserId(Integer userId);<\/p>\n

\/\/\u6839\u636e\u7528\u6237\u4fe1\u606f\u6765\u67e5\u8be2\u60f3\u8981\u67e5\u8be2\u7684\u6536\u85cf\u7684\u6b4c\u66f2
\n List<Music> findLoveMusicByUserIdAndMusicId(Integer userId,String musicName);
\n <select id="findLoveMusicByUserId" resultType="com.blame.onlinemusicserver.model.Music">
\n select m.* from lovemusic lm,music m where lm.music_id=m.id and lm.user_id=#{userId}
\n <\/select><\/p>\n

<select id="findLoveMusicByUserIdAndMusicId" resultType="com.blame.onlinemusicserver.model.Music">
\n select m.* from lovemusic lm,music m where lm.music_id=m.id and lm.user_id=#{userId} and title like concat('%',#{musicName},'%')
\n <\/select> <\/p>\n

LoveMusicController<\/h3>\n

@RequestMapping("\/findlovemusic")
\n public ResponseBodyMessage<List<Music>> findLoveMusic(HttpServletRequest request,@RequestParam(required = false)
\n String musicName){
\n return loveMusicService.findLoveMusic(request, musicName);
\n } <\/p>\n

\u00a0LoveMusicService<\/h3>\n

public ResponseBodyMessage<List<Music>> findLoveMusic(HttpServletRequest request,String musicName){
\n \/\/\u5224\u65ad\u662f\u5426\u767b\u5f55
\n HttpSession session= request.getSession(false);
\n if(session==null || session.getAttribute(Constant.USERINFO_SESSION_KEY)==null){
\n log.error("\u672a\u767b\u5f55，\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");
\n return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",null);
\n }
\n User user=(User) session.getAttribute(Constant.USERINFO_SESSION_KEY);
\n Integer userId=user.getId();
\n System.out.println("userId"+userId);
\n List<Music> musics=null;
\n if(userId==null){
\n return new ResponseBodyMessage<>(-1,"\u7528\u6237\u4e0d\u5b58\u5728",null);
\n }
\n log.info("\u5df2\u7ecf\u627e\u5230\u8be5\u7528\u6237");
\n \/\/\u67e5\u8be2\u7528\u6237\u7684\u5168\u90e8\u6536\u85cf\u97f3\u4e50
\n if(musicName==null){
\n musics= loveMusicMapper.findLoveMusicByUserId(userId);
\n \/\/\u5224\u65ad musics \u4e0d\u4e3a\u7a7a\u4e14\u4e0d\u4e3a null
\n if(!CollectionUtils.isEmpty(musics)){
\n return new ResponseBodyMessage<>(0,"\u5df2\u7ecf\u627e\u5230\u7528\u6237\u7684\u5168\u90e8\u6536\u85cf\u97f3\u4e50",musics);
\n }else {
\n return new ResponseBodyMessage<>(-1,"\u7528\u6237\u7684\u6536\u85cf\u97f3\u4e50\u4e3a\u7a7a",null);
\n }
\n }else { \/\/\u6839\u636e\u7528\u6237\u4fe1\u606f\u6765\u67e5\u8be2\u60f3\u8981\u67e5\u8be2\u7684\u6536\u85cf\u7684\u6b4c\u66f2
\n System.out.println("musicName"+musicName);
\n musics=loveMusicMapper.findLoveMusicByUserIdAndMusicId(userId,musicName);
\n \/\/\u5224\u65ad musics \u4e0d\u4e3a\u7a7a\u4e14\u4e0d\u4e3a null
\n if(!CollectionUtils.isEmpty(musics)){
\n return new ResponseBodyMessage<>(0,"\u5df2\u7ecf\u627e\u5230\u7528\u6237\u67e5\u8be2\u7684\u6536\u85cf\u6b4c\u66f2",musics);
\n }else {
\n return new ResponseBodyMessage<>(-1,"\u7528\u6237\u6ca1\u6709\u6536\u85cf\u6b64\u97f3\u4e50",null);
\n }<\/p>\n

}
\n } <\/p>\n

\u9a8c\u8bc1\u00a0<\/p>\n

\"\"\"\"<\/p>\n

\u79fb\u9664\u559c\u6b22\u7684\u2fb3\u4e50\u6a21\u5757\u8bbe\u8ba1\u00a0<\/h2>\n

\u8bf7\u6c42\u548c\u54cd\u5e94\u7684\u63a5\u53e3\u5b9e\u73b0<\/h3>\n

\"\"<\/p>\n

LoveMusicMapper<\/h3>\n

Boolean deleteLoveMusic(Integer userId,Integer musicId);
\n <delete id="deleteLoveMusic">
\n delete from lovemusic where user_id=#{userId} and music_id=#{musicId}
\n <\/delete> <\/p>\n

LoveMusicController<\/h3>\n

@RequestMapping("deleteLikeMusic")
\n public ResponseBodyMessage<Boolean> deleteLikeMusic(@RequestParam String id,HttpServletRequest request){
\n return loveMusicService.deleteLikeMusic(id,request);
\n } <\/p>\n

LoveMusicService<\/h3>\n

\/\/\u53d6\u6d88\u6536\u85cf
\n public ResponseBodyMessage<Boolean> deleteLikeMusic(String id,HttpServletRequest request){
\n Integer musicId=Integer.parseInt(id);
\n System.out.println("musicId"+musicId);<\/p>\n

\/\/\u68c0\u67e5\u767b\u5f55
\n HttpSession session=request.getSession(false);
\n if(session==null || session.getAttribute(Constant.USERINFO_SESSION_KEY)==null){
\n log.error("\u672a\u767b\u5f55，\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");
\n return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);
\n }
\n User user =(User) session.getAttribute(Constant.USERINFO_SESSION_KEY);<\/p>\n

Integer userId=user.getId();
\n System.out.println("userId"+userId);
\n Music music=loveMusicMapper.selectMusicIsExist(userId,musicId);
\n if(music==null){
\n return new ResponseBodyMessage<>(-1,"\u8be5\u97f3\u4e50\u4e0d\u5728\u6536\u85cf\u5939\u5185",false);
\n }
\n Boolean successDelete=loveMusicMapper.deleteLoveMusic(userId,musicId);
\n if(successDelete){
\n return new ResponseBodyMessage<>(1,"\u97f3\u4e50\u5df2\u7ecf\u4ece\u6536\u85cf\u5939\u4e2d\u5220\u9664",true);
\n }
\n return new ResponseBodyMessage<>(-1,"\u97f3\u4e50\u4ece\u6536\u85cf\u5939\u4e2d\u5220\u9664\u5931\u8d25",false);
\n } <\/p>\n

\u9a8c\u8bc1<\/p>\n

\"\"<\/p>\n

\u5b9e\u73b0\u5ba2\u6237\u7aef\u7684\u4ee3\u7801<\/h2>\n

\u767b\u5f55\u754c\u9762<\/h3>\n

<script>
\n $(function () {
\n $("#submit").click(function () {
\n var username = $("#user").val().trim();
\n var password = $("#password").val().trim();<\/p>\n

if (username === "" || password === "") {
\n $("#message").text("\u8bf7\u8f93\u5165\u7528\u6237\u540d\u548c\u5bc6\u7801！");
\n $("#messageBox").fadeIn();
\n return;
\n }<\/p>\n

$.ajax({
\n url: "\/user\/login",
\n type: "post",
\n dataType: "json",
\n data: {
\n username: username,
\n password: password
\n },
\n success: function (result) {
\n if (result.status === 0) {
\n alert("\u767b\u5f55\u6210\u529f！");
\n window.location.href = "list.html";
\n } else {
\n $("#message").text("\u8d26\u53f7\u6216\u5bc6\u7801\u9519\u8bef，\u8bf7\u91cd\u8bd5！");
\n $("#messageBox").fadeIn();
\n $("#user").val("");
\n $("#password").val("");
\n }
\n },
\n error: function () {
\n $("#message").text("\u670d\u52a1\u5668\u8fde\u63a5\u5931\u8d25，\u8bf7\u7a0d\u540e\u91cd\u8bd5！");
\n $("#messageBox").fadeIn();
\n }
\n });
\n });
\n });
\n <\/script> <\/p>\n

\u6ce8\u518c\u754c\u9762<\/h3>\n

<script>
\n $(function () {
\n $("#registerBtn").click(function () {
\n var username = $("#regUser").val().trim();
\n var email = $("#regEmail").val().trim();
\n var password = $("#regPassword").val().trim();<\/p>\n

if (username === "" || email === "" || password === "") {
\n $("#regMessage").text("\u8bf7\u5b8c\u5584\u6ce8\u518c\u4fe1\u606f！");
\n $("#regMessageBox").fadeIn();
\n return;
\n }<\/p>\n

$.ajax({
\n url: "\/user\/register",
\n type: "post",
\n dataType: "json",
\n contentType: "application\/json",
\n data: JSON.stringify({
\n username: username,
\n password: password,
\n email: email
\n }),
\n success: function (result) {
\n if (result.status === 0) {
\n alert("\u6ce8\u518c\u6210\u529f！");
\n window.location.href = "login.html";
\n } else {
\n $("#regMessage").text(result.message);
\n $("#regMessageBox").fadeIn();
\n }
\n },
\n error: function () {
\n $("#regMessage").text("\u670d\u52a1\u5668\u8fde\u63a5\u5931\u8d25，\u8bf7\u7a0d\u540e\u91cd\u8bd5！");
\n $("#regMessageBox").fadeIn();
\n }
\n });
\n });
\n });
\n<\/script> <\/p>\n

\u97f3\u4e50\u5217\u8868\u754c\u9762<\/h3>\n

<script type="text\/javascript">
\n $(function() {
\n load(); \/\/ \u9875\u9762\u52a0\u8f7d\u65f6\u9ed8\u8ba4\u52a0\u8f7d\u6240\u6709\u6b4c\u66f2
\n });<\/p>\n

function load(musicName) {
\n $.ajax({
\n url: "\/music\/findmusic",
\n data: { musicName: musicName },
\n type: "get",
\n dataType: "json",
\n success: function(result) {
\n var data = result.data;
\n var s = '';
\n for (var i = 0; i < data.length; i++) {
\n var musicUrl = data[i].url + ".mp3";
\n s += '<tr>';
\n s += '<th> <input id="' + data[i].id + '" type="checkbox"> <\/th>';
\n s += '<td>' + data[i].title + '<\/td>';
\n s += '<td>' + data[i].singer + '<\/td>';
\n s += '<td><button class="btn" onclick="playerSong(\\\\'' + musicUrl + '\\\\')">\u64ad\u653e\u6b4c\u66f2<\/button><\/td>';
\n s += '<td><button class="btn" onclick="deleteInfo(' + data[i].id + ')">\u5220\u9664<\/button>';
\n s += '<button class="btn" onclick="loveInfo(' + data[i].id + ')">\u559c\u6b22<\/button><\/td>';
\n s += '<\/tr>';
\n }
\n $("#info").html(s); \/\/ \u66f4\u65b0\u8868\u683c
\n }
\n });
\n }<\/p>\n

function playerSong(musicUrl) {
\n var name = musicUrl.substring(musicUrl.lastIndexOf('\/') + 1); \/\/ \u83b7\u53d6\u97f3\u4e50\u540d\u79f0
\n SewisePlayer.toPlay(musicUrl, name, 0, true); \/\/ \u64ad\u653e\u6b4c\u66f2
\n }<\/p>\n

function deleteInfo(musicId) {
\n $.ajax({
\n url: "\/music\/delete",
\n data: { id: musicId },
\n type: "post",
\n dataType: "json",
\n success: function(result) {
\n if (result.data) {
\n alert("\u5220\u9664\u6210\u529f");
\n window.location.href = "list.html"; \/\/ \u9875\u9762\u8df3\u8f6c
\n } else {
\n alert("\u5220\u9664\u5931\u8d25");
\n }
\n }
\n });
\n }
\n $(function(){
\n $("#submit1").click( function(){
\n var name = $("#exampleInputName2").val();
\n load(name);
\n });<\/p>\n

$.when(load).done(function(){
\n $("#delete").click(function(){
\n var id = new Array();
\n var i = 0;\/\/\u6570\u7ec4\u7684\u5c0f\u6807
\n \/\/
\n $("input:checkbox").each(function(){
\n \/\/\u5982\u679c\u88ab\u9009\u4e2d,this\u4ee3\u8868\u53d1\u751f\u4e8b\u4ef6\u7684dom\u5143\u7d20，<input>
\n if( $(this).is(":checked")) {
\n id[i] = $(this).attr("id");
\n i++;
\n }
\n });<\/p>\n

console.log(id);<\/p>\n

$.ajax({
\n url:"\/music\/deleteSel",
\n data:{"id":id},
\n dataType:"json",
\n type:"post",<\/p>\n

success:function(obj){
\n if(obj.data == true) {
\n alert("\u5220\u9664\u6210\u529f！");
\n window.location.href = "list.html";
\n }else{
\n alert("\u5220\u9664\u5931\u8d25！");
\n }
\n }
\n });
\n });
\n });
\n });
\n function loveInfo(musicId) {
\n $.ajax({
\n url: "lovemusic\/addLikeMusic",
\n data: { "id": musicId },
\n type: "post",
\n dataType: "json",
\n success: function(result) {
\n if (result.data) {
\n alert("\u6dfb\u52a0\u6536\u85cf\u6210\u529f");
\n window.location.href = "list.html"; \/\/ \u9875\u9762\u8df3\u8f6c
\n } else {
\n alert("\u6dfb\u52a0\u6536\u85cf\u5931\u8d25");
\n }
\n }
\n });
\n }
\n <\/script> <\/p>\n

\u6536\u85cf\u97f3\u4e50\u754c\u9762<\/h3>\n

<script>
\n $(function() {
\n load();<\/p>\n

$("#submit1").click(function() {
\n var name = $("#exampleInputName2").val();
\n load(name);
\n });
\n });<\/p>\n

function load(musicName) {
\n $.ajax({
\n url: "\/lovemusic\/findlovemusic",
\n data: {"musicName": musicName},
\n type: "GET",
\n dataType: "json",
\n success: function(obj) {
\n var data = obj.data;
\n var s = '';
\n for (var i = 0; i < data.length; i++) {
\n var musicUrl = data[i].url + ".mp3";
\n s += '<tr>';
\n s += '<td>' + data[i].title + '<\/td>';
\n s += '<td>' + data[i].singer + '<\/td>';
\n s += '<td><audio src="' + musicUrl + '" controls preload="none" loop><\/audio><\/td>';
\n s += '<td><button class="btn btn-primary" onclick="deleteInfo(' + data[i].id + ')">\u79fb\u9664<\/button><\/td>';
\n s += '<\/tr>';
\n }
\n $("#info").html(s);
\n }
\n });
\n }<\/p>\n

function deleteInfo(id) {
\n $.ajax({
\n url: "\/lovemusic\/deleteLikeMusic",
\n type: "POST",
\n data: {"id": id},
\n dataType: "json",
\n success: function(val) {
\n if (val.data == true) {
\n alert("\u5220\u9664\u6210\u529f！,\u91cd\u65b0\u52a0\u8f7d\u5f53\u524d\u9875\u9762！");
\n window.location.href = "list.html";
\n } else {
\n alert("\u5220\u9664\u5931\u8d25！");
\n }
\n }
\n });
\n }
\n <\/script> <\/p>\n

\u4e0a\u4f20\u97f3\u4e50\u754c\u9762<\/h3>\n

<form method="POST" enctype="multipart\/form-data" action="\/music\/upload">
\n <div class="form-group">
\n <label for="file">🎶 \u97f3\u4e50\u6587\u4ef6<\/label>
\n <input type="file" id="file" name="filename" required \/>
\n <\/div>
\n <div class="form-group">
\n <label for="singer">👤 \u6b4c\u624b\u540d<\/label>
\n <input type="text" id="singer" name="singer" placeholder="\u8bf7\u8f93\u5165\u6b4c\u624b\u540d" required \/>
\n <\/div>
\n <input type="submit" value="📤 \u4e0a\u4f20" \/>
\n <\/form> <\/p>\n

\u00a0\u5728\u8fd9\u91cc\u7684\u64ad\u653e\u97f3\u4e50\u7684\u5de5\u5177，\u6211\u4eec\u4f7f\u7528\u7684\u662f\u4e00\u4e2a\u5f00\u6e90\u7684\u64ad\u653e\u5de5\u5177<\/span><\/p>\n

demos\/\u4f8b\u5b50\u8bf4\u660e.md \u00b7 Jack Zhang\/sewise-player – Gitee.com<\/p>\n

<div style="width: 180px; height: 140px; position: absolute; bottom: 10px; right: 10px;">
\n <script type="text\/javascript" src="player\/sewise.player.min.js"><\/script>
\n <script type="text\/javascript">
\n SewisePlayer.setup({
\n server: "vod",
\n type: "mp3",
\n videourl: "http:\/\/jackzhang1204.github.io\/materials\/where_did_time_go.mp3",
\n skin: "vodWhite",
\n autostart: "false",
\n });
\n <\/script>
\n <\/div> <\/p>\n

\u5b9e\u73b0\u64ad\u653e<\/h3>\n

function playerSong(musicUrl) {
\n var name = musicUrl.substring(musicUrl.lastIndexOf('\/') + 1); \/\/ \u83b7\u53d6\u97f3\u4e50\u540d\u79f0
\n SewisePlayer.toPlay(musicUrl, name, 0, true); \/\/ \u64ad\u653e\u6b4c\u66f2
\n } <\/p>\n

\u00a0\u914d\u7f6e\u62e6\u622a\u5668<\/h2>\n

\u81ea\u5b9a\u4e49\u62e6\u622a\u5668<\/h3>\n

@Component
\npublic class LoginInterceptor implements HandlerInterceptor {
\n @Override
\n public boolean preHandle(HttpServletRequest request,
\n HttpServletResponse response,
\n Object handler) throws Exception {
\n HttpSession session = request.getSession(false);
\n if (session != null && session.getAttribute(Constant.USERINFO_SESSION_KEY) != null) {
\n return true;
\n }
\n \/\/ \u672a\u767b\u5f55\u63d0\u793a
\n \/\/\u662f\u544a\u8bc9\u6d4f\u89c8\u5668\u5185\u5bb9\u662f JSON，\u5e76\u4e14\u662f UTF-8 \u7f16\u7801；
\n response.setContentType("application\/json;charset=utf-8");
\n \/\/\u624b\u52a8\u8fd4\u56de\u4e00\u6bb5json\u6570\u636e，\u8fdb\u884c\u9519\u8bef\u63d0\u793a
\n response.getWriter().write("{\\\\"code\\\\":401,\\\\"msg\\\\":\\\\"\u672a\u767b\u5f55，\u8bf7\u5148\u767b\u5f55\\\\"}");
\n return false;
\n }
\n}<\/p>\n

\u4f7f\u7528\u62e6\u622a\u5668<\/h3>\n

\u53ea\u91ca\u653e\u9759\u6001\u8d44\u6e90\u548c\u767b\u5f55\u63a5\u53e3<\/p>\n

@Configuration
\npublic class AppConfig implements WebMvcConfigurer {<\/p>\n

@Override
\n public void addInterceptors(InterceptorRegistry registry) {
\n LoginInterceptor loginInterceptor = new LoginInterceptor();
\n registry.addInterceptor(loginInterceptor)
\n .addPathPatterns("\/**") \/\/ \u62e6\u622a\u6240\u6709\u8bf7\u6c42
\n .excludePathPatterns(
\n "\/js\/**",
\n "\/css\/**",
\n "\/images\/**",
\n "\/fonts\/**",
\n "\/player\/**",
\n "\/login.html",
\n "\/user\/login"
\n ); \/\/ \u653e\u884c\u9759\u6001\u8d44\u6e90\u548c\u767b\u5f55\u63a5\u53e3
\n }
\n} <\/p>\n

\u00a0\u9879\u76ee\u5728\u6b64\u5168\u90e8\u7ed3\u675f，\u53ef\u4ee5\u5c06\u9879\u76ee\u90e8\u7f72\u5230\u4e91\u670d\u52a1\u5668\u4e0a<\/p>\n<\/p>\n

\u5e0c\u671b\u80fd\u5bf9\u5927\u5bb6\u6709\u6240\u5e2e\u52a9！！！<\/p>\n

\"\"<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb766\u6b21\uff0c\u70b9\u8d5e25\u6b21\uff0c\u6536\u85cf29\u6b21\u3002\u5bf9\u5e94\u6570\u636e\u5e93\u4e2d\u7684music\u8868\u7684\u5b57\u6bb5@Data\u5c06\u97f3\u4e50\u6587\u4ef6\u4e0a\u4f20\u5230\u8fd9\u4e2a\u8def\u5f84Slf4j@Autowired@Slf4j@Service@Autowired@Autowired\/\/\u6dfb\u52a0\u97f3\u4e50\/\/1.\u68c0\u67e5\u767b\u5f55log.error("\u672a\u767b\u5f55\uff0c\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);\/\/2.\u68c0\u67e5\u6570\u6570\u636e\u5e93\u4e2d\u662f\u5426\u6709\u6b64\u97f3\u4e50\/\/\u5f97\u5230\u6587\u4ef6\u7684\u540d\u5b57\u548c\u7c7b\u578b\/\/\u4ee5 . \u5c06\u540d\u5b57\u548c\u7c7b\u578b\u5206\u5f00\uff0c\u5f97\u5230title\u3002<\/p>\n","protected":false},"author":2,"featured_media":39582,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,1769,190],"topic":[],"class_list":["post-39602","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-java","tag-mybatis","tag-190"],"yoast_head":"\n\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/39602.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb766\u6b21\uff0c\u70b9\u8d5e25\u6b21\uff0c\u6536\u85cf29\u6b21\u3002\u5bf9\u5e94\u6570\u636e\u5e93\u4e2d\u7684music\u8868\u7684\u5b57\u6bb5@Data\u5c06\u97f3\u4e50\u6587\u4ef6\u4e0a\u4f20\u5230\u8fd9\u4e2a\u8def\u5f84Slf4j@Autowired@Slf4j@Service@Autowired@Autowired\/\/\u6dfb\u52a0\u97f3\u4e50\/\/1.\u68c0\u67e5\u767b\u5f55log.error("\u672a\u767b\u5f55\uff0c\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);\/\/2.\u68c0\u67e5\u6570\u6570\u636e\u5e93\u4e2d\u662f\u5426\u6709\u6b64\u97f3\u4e50\/\/\u5f97\u5230\u6587\u4ef6\u7684\u540d\u5b57\u548c\u7c7b\u578b\/\/\u4ee5 . \u5c06\u540d\u5b57\u548c\u7c7b\u578b\u5206\u5f00\uff0c\u5f97\u5230title\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/39602.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-24T00:06:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250524000640-68310d90a8f8f.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/39602.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/39602.html\",\"name\":\"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-05-24T00:06:48+00:00\",\"dateModified\":\"2025-05-24T00:06:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/39602.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/39602.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/39602.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/39602.html","og_locale":"zh_CN","og_type":"article","og_title":"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb766\u6b21\uff0c\u70b9\u8d5e25\u6b21\uff0c\u6536\u85cf29\u6b21\u3002\u5bf9\u5e94\u6570\u636e\u5e93\u4e2d\u7684music\u8868\u7684\u5b57\u6bb5@Data\u5c06\u97f3\u4e50\u6587\u4ef6\u4e0a\u4f20\u5230\u8fd9\u4e2a\u8def\u5f84Slf4j@Autowired@Slf4j@Service@Autowired@Autowired\/\/\u6dfb\u52a0\u97f3\u4e50\/\/1.\u68c0\u67e5\u767b\u5f55log.error("\u672a\u767b\u5f55\uff0c\u8bf7\u5148\u8fdb\u884c\u767b\u5f55");return new ResponseBodyMessage<>(0,"\u6ca1\u6709\u767b\u5f55",false);\/\/2.\u68c0\u67e5\u6570\u6570\u636e\u5e93\u4e2d\u662f\u5426\u6709\u6b64\u97f3\u4e50\/\/\u5f97\u5230\u6587\u4ef6\u7684\u540d\u5b57\u548c\u7c7b\u578b\/\/\u4ee5 . \u5c06\u540d\u5b57\u548c\u7c7b\u578b\u5206\u5f00\uff0c\u5f97\u5230title\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/39602.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-05-24T00:06:48+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250524000640-68310d90a8f8f.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"16 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/39602.html","url":"https:\/\/www.wsisp.com\/helps\/39602.html","name":"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-05-24T00:06:48+00:00","dateModified":"2025-05-24T00:06:48+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/39602.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/39602.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/39602.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u9879\u76ee\uff1a\u5728\u7ebf\u97f3\u4e50\u64ad\u653e\u670d\u52a1\u5668\u2014\u2014\u57fa\u4e8eSSM\u6846\u67b6\u548cmybatis"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/39602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=39602"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/39602\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/39582"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=39602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=39602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=39602"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=39602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}