devbox
2023面试高手
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java项目:轻语音乐网平台(java+Springboot+ssm+mysql+maven+jsp)_轻语怎么上传歌曲

作者：2023面试高手 | 2024-03-10 19:50:34

赞

踩

轻语怎么上传歌曲

源码获取：博客首页 "资源" 里下载！

一、项目简述

功能： 用户管理模块：用户登录、用户注册、修改密码 榜单列表模块：动态地从数据库中获取歌曲的链接和数据 在榜单中显示 歌曲搜索模块：在首页的搜索框中可以输入关键字进行歌 曲的模糊搜索 歌曲收藏模块：在榜单列表中或搜索页面中可以点击歌曲 进行收藏 我的音乐模块：收藏的歌曲会被添加到我的音乐列表中， 在我的音乐列表中也可以对歌曲进行删除操作 音乐播放器模块：在榜单、搜索页面和我的音乐列表等地 方点击歌曲可以炼专到播放页面进行播放。播放页面显示 播放进度条，删除歌曲，暂停等操作。播放页面背景为模 糊背景，根据歌手的专辑图片自动变化。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： JSP +SpringBoot + MyBatis + html+ css + JavaScript + JQuery + Ajax + Bootstrap+ maven 等等。

音乐链接服务：

  1. /**
  2.  * 音乐链接服务
  3.  */
  5. @Controller 
  6. @RequestMapping("/musicLink")
  7. public class MusicLinkController {
  8.  
  9. 	@Autowired
  10. 	protected WebResponse webResponse;
  11.  
  12. 	@Resource
  13. 	protected IMusicLinkService musicLinkService;
  14.  
  15. 	@Resource
  16. 	protected MusicLinkService musicLinkService2;
  17. 	
  18. 	
  19. 	/**
  20. 	 *  //常用注解快速解释：
  21. 	 *  @Controller ：用于标记在一个类上，使用它标记的类就是一个SpringMVC Controller 对象。
  22. 	 *  分发处理器将会扫描使用了该注解的类的方法，并检测该方法是否使用了@RequestMapping 注解。@Controller 
  23. 	 *  只是定义了一个控制器类，而使用@RequestMapping 注解的方法才是真正处理请求的处理器。
  24. 	 *  
  25. 	 *  @RequestMapping ：是一个用来处理请求地址映射的注解，可用于类或方法上。
  26. 	 *  用于类上，表示类中的所有响应请求的方法都是以该地址作为父路径；
  27. 	 *  用于方法上，表示在类的父路径下追加方法上注解中的地址将会访问到该方法
  28. 	 *  
  29. 	 *  @Autowired：@Autowired 注释，它可以对类成员变量、方法及构造函数进行标注，完成自动装配的工作。 通过 @Autowired的使用来消除 set ，get方法。
  30. 	 *  
  31. 	 * 
  32. 	 *  @Resource：@Autowired与@Resource都可以用来装配bean. 都可以写在字段上,或写在setter方法上。
  33. 	 *  
  34. 	 *  
  35. 	 *  @Responsebody 注解表示该方法的返回的结果直接写入 HTTP 响应正文（ResponseBody）中，
  36. 	 *  一般在异步获取数据时使用，通常是在使用 @RequestMapping 后，返回值通常解析为跳转路径，
  37. 	 *  加上 @Responsebody 后返回结果不会被解析为跳转路径，而是直接写入HTTP 响应正文中。 
  38.      *  作用： 该注解用于将Controller的方法返回的对象，通过适当的HttpMessageConverter转换为指定格式后，写入到Response对象的body数据区。
  39.      *   
  40.      *
  41.      *
  42. 	 * 
  43. 	 *  @RequestParam（value="aa" required=false）
  44. 	 *   1.可以对传入参数指定参数名
  45. 	 *   
  46. 	 *   // 下面的对传入参数指定为aa，如果前端不传aa参数名，会报错  
  47. 	 *   @RequestParam(value="aa") String inputStr 
  48. 	 *    
  49. 	 *   2、可以通过required=false或者true来要求@RequestParam配置的前端参数是否一定要传 
  50. 	 *  
  51. 	 *   3、如果@requestParam注解的参数是int类型，并且required=false，此时如果不传参数的话，会报错。原因是，required=false时，不传参数的话，
  52. 	 *   会给参数赋值null，这样就会把null赋值给了int，因此会报错。
  53. 	 *      
  54. 	 *
  55. 	 * 
  56. 	 */ 
  57. 	
  58.  
  59. 	// 从数据库中获取歌曲数据，在榜单中显示
  60. 	@RequestMapping(value = "/getMusicLinkList", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  61. 	@ResponseBody
  62. 	public WebResponse getMusicLinkList(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  63. 			@RequestParam(defaultValue = "1", required = false) Integer pageNo,
  64. 			@RequestParam(defaultValue = "30", required = false) Integer pageSize,
  65. 			@RequestParam(defaultValue = "正常", required = false) String tbStatus,
  66. 			@RequestParam(required = false) String keyword,
  67. 			@RequestParam(defaultValue = "ml_id", required = false) String order,
  68. 			@RequestParam(defaultValue = "desc", required = false) String desc) {
  69. 		Object data = null;
  70. 		String statusMsg = "";
  71. 		int statusCode = 200;
  72. 		LinkedHashMap<String, String> condition = new LinkedHashMap<String, String>();
  73. 		/*
  74. 		 * if (tbStatus != null && tbStatus.length() > 0) { condition.put("tb_status='"
  75. 		 * + tbStatus + "'", "and"); }
  76. 		 */
  77. 		if (keyword != null && keyword.length() > 0) {
  78. 			StringBuffer buf = new StringBuffer();
  79. 			buf.append("(");
  80. 			buf.append("test_name like '%").append(keyword).append("%'");
  81. 			buf.append(" or ");
  82. 			buf.append("info like '%").append(keyword).append("%'");
  83. 			buf.append(" or ");
  84. 			buf.append("other like '%").append(keyword).append("%'");
  85. 			buf.append(")");
  86. 			condition.put(buf.toString(), "and");
  87. 		}
  88. 		String field = null;
  89. 		if (condition.size() > 0) {
  90. 			condition.put(condition.entrySet().iterator().next().getKey(), "");
  91. 		}
  92. 		int count = this.musicLinkService.getCount(condition, field);
  93. 		if (order != null && order.length() > 0 & "desc".equals(desc)) {
  94. 			order = order + " desc";
  95. 		}
  96. 		// 从数据库中获取数据，并把对象的结果集存到list列表中
  97. 		List<MusicLink> list = this.musicLinkService.getList(condition, pageNo, pageSize, order, field);
  98. 		Map<Object, Object> map = new HashMap<Object, Object>();
  99. 		map.put("total", count);
  100.  
  101. 		// 如果数据库有15条音乐，则list中有15个对象，则size的大小为15
  102. 		int size = list.size();
  103. 		if (size > 0) {
  104. 			List<MusicLink> listFont = new ArrayList<MusicLink>();
  105. 			MusicLink vo;
  106. 			MusicLink voFont = new MusicLink();
  107.  
  108. 			// 循环将获取到的对象及结构属性克隆到一个新的voFont对象中，并保存到动态数组中
  109. 			for (int i = 0; i < size; i++) {
  110. 				vo = list.get(i);
  111.  
  112. 				// 通过java反射将类中当前属性字段对应的内容复制到另外一个类中
  113. 				BeanUtils.copyProperties(vo, voFont);
  114. 				listFont.add(voFont);
  115. 				voFont = new MusicLink();
  116. 			}
  117. 			map.put("list", listFont);
  118.  
  119. 			// data是一个map对象
  120. 			data = map;
  121. 			statusMsg = "根据条件获取分页数据成功！！！";
  122. 		} else {
  123. 			map.put("list", list);
  124. 			data = map;
  125. 			statusCode = 202;
  126. 			statusMsg = "no record!!!";
  127. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  128. 		}
  129. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  130. 	}
  131.  
  132. 	// 歌曲搜索功能
  133. 	@RequestMapping(value = "/getSongRearch", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  134. 	@ResponseBody
  135. 	public WebResponse getSongRearch(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  136. 			@RequestParam(required = false) String songName) {
  137.  
  138. 		Object data = null;
  139. 		String statusMsg = "";
  140. 		int statusCode = 200;
  141.  
  142. 		// 调用Mapper层的songRearch方法，进行数据库的操作
  143. 		List<MusicLink> list = this.musicLinkService2.songRearch(songName);
  144.  
  145. 		int count = list.size();
  146. 		System.out.println();
  147. 		System.out.println("搜索到的歌曲数：" + count);
  148. 		System.out.println("结束");
  149. 		Map<Object, Object> map = new HashMap<Object, Object>();
  150. 		map.put("total", count);
  151. 		int size = list.size();
  152. 		if (size > 0) {
  153. 			List<MusicLink> listFont = new ArrayList<MusicLink>();
  154. 			MusicLink vo;
  155. 			MusicLink voFont = new MusicLink();
  156. 			for (int i = 0; i < size; i++) {
  157. 				vo = list.get(i);
  158. 				BeanUtils.copyProperties(vo, voFont);
  159. 				listFont.add(voFont);
  160. 				voFont = new MusicLink();
  161. 			}
  162. 			map.put("list", listFont);
  163. 			data = map;
  164. //				for (int i = 0; i < map.size(); i++) {
  165. //					System.out.println(map.get(listFont).toString());
  166. //				}
  167. //				
  168. 			statusMsg = "根据条件获取分页数据成功！！！";
  169. 		} else {
  170. 			map.put("list", list);
  171. 			data = map;
  172. 			statusCode = 202;
  173. 			statusMsg = "no record!!!";
  174. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  175. 		}
  176.  
  177. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  178. 	}
  179.  
  180. 	// 歌曲收藏
  181. 	@RequestMapping(value = "/addMusicCollect", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  182. 	@ResponseBody
  183. 	public WebResponse addMusicCollect(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  184. 			@RequestParam(required = false) int song_id, @RequestParam(required = false) String user_name,
  185. 			@RequestParam(required = false) String user_password, @RequestParam(required = false) String songName) {
  186. 		WebResponse webResponse = new WebResponse();
  187. 		MusicLink musicLink = new MusicLink();
  188. 		User user = new User();
  189. 		System.out.println("歌曲id：" + song_id + " 用户名：" + user_name + "  户用密码：" + user_password);
  190. 		Object data = null;
  191. 		String statusMsg = "";
  192. 		int statusCode = 200;
  193.  
  194. 		String user_Id = null;
  195. 		try {
  196. 			user_Id = musicLinkService2.getUserId(user_name, user_password);
  197. 		} catch (Exception e) {
  198.  
  199. 		}
  200.  
  201. 		int userId = 0;
  202. 		try {
  203. 			// 判断字符串是否是数字，并且抛出异常
  204. 			boolean NotisNum = (user_Id.equals("null"));
  205. 			// System.out.println(NotisNum);
  206. 			if (!NotisNum) {
  207. 				userId = Integer.parseInt(user_Id);
  208. 			}
  209. 		} catch (Exception e) {
  210.  
  211. 		}
  212.  
  213. 		System.out.println("歌曲名：" + songName);
  214.  
  215. 		String jSong = this.musicLinkService.judgeSong(songName, userId);
  216.  
  217. 		int my_Id = 0;
  218. 		try {
  219. 			// 判断字符串是否是数字，并且抛出异常
  220. 			// boolean NotisNum
  221. 			// =(user_Id.equals(null)||user_Id.equals("")||user_Id.equals("null"));
  222. 			boolean NotisNum = (jSong.equals("null"));
  223.  
  224. 			if (!NotisNum) {
  225. 				my_Id = Integer.parseInt(jSong);
  226. 			}
  227. 		} catch (Exception e) {
  228.  
  229. 		}
  230.  
  231. 		if (my_Id > 0) {
  232. 			statusCode = 201;
  233. 			statusMsg = "已收藏,请不要重复收藏！";
  234. 		} else {
  235. 			this.musicLinkService.insertSongRearch(song_id, userId);
  236. 		}
  237.  
  238. 		System.out.println("收藏歌曲的用户id：" + userId);
  239.  
  240. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  241.  
  242. 	}
  243.  
  244. }

用户信息控制层：

  1. /**
  2.  * 用户信息控制层
  3.  */
  5. @Controller
  6. @RequestMapping("/user")
  7. public class UserController {
  8.  
  9. 	@Autowired
  10. 	protected WebResponse webResponse;
  11.  
  12. 	@Resource
  13. 	protected IUserService userService;
  14.  
  15. 	@Resource
  16. 	protected IMyMusicService MyMusicService;
  17.  
  18. 	@Autowired
  19. 	UserService userService2;
  20.  
  21. 	String newName = null;
  22.  
  23. 	// 登录功能
  24. 	@RequestMapping(value = "/loginPage", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  25. 	@ResponseBody
  26. 	public WebResponse loginCon(HttpServletRequest request, HttpSession session) {
  27.  
  28. 		// 取参数的方法，对应登录表单中的用户名name="user_name"
  29. 		String user_name = request.getParameter("user_name");
  30. 		String user_password = request.getParameter("user_password");
  31.  
  32. 		// 调用mapper层的登录的方法，从数据库中匹配用户名和密码，并放回用户名
  33. 		String tname = userService2.login(user_name, user_password);
  34.  
  35. 		String user_Id = userService2.getUserById(user_name, user_password);
  36. 		// newUserId = user_Id; //修改密码用的
  37. 		int userId = 0;
  38. 		try {
  39. 			// 判断字符串是否是数字，并且抛出异常
  40. 			// boolean NotisNum
  41. 			// =(user_Id.equals(null)||user_Id.equals("")||user_Id.equals("null"));
  42. 			boolean NotisNum = (user_Id.equals("null"));
  43. 			// System.out.println(NotisNum);
  44. 			if (!NotisNum) {
  45. 				userId = Integer.parseInt(user_Id);
  46. 			}
  47. 		} catch (Exception e) {
  48.  
  49. 		}
  50. //	   
  51. 		session.setAttribute("tname", tname);
  52. 		session.setAttribute("userId", userId);
  53. 		Object data = null;
  54. 		String statusMsg = "";
  55. 		Integer statusCode = 200;
  56. 		Map<String, String> paramMap = new HashMap<String, String>();
  57. 		paramMap.put("user_name", user_name);
  58. 		paramMap.put("user_password", user_password);
  59. 		data = paramMap;
  60.  
  61. 		User user = new User();
  62. 		user.setUser_id(userId);
  63. 		System.out.println("登录的id:" + user.getUser_id());
  64. 		System.out.println("登录的用户名:" + session.getAttribute(tname));
  65. 		System.out.println("前端，用户名：" + user_name + " 密码：" + user_password);
  66. 		System.out.println("根据前端在数据库中查找到的用户名：" + tname + " 用户的id:" + userId);
  67.  
  68. 		// 用户名和密码匹配不成功，则返回的用户名为空
  69. 		if (tname == null) {
  70. 			System.out.println("用户不存在");
  71. 			System.out.println();
  72. 			statusMsg = "用户或密码错误！";
  73. 			statusCode = 201;
  74. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  75. 		} else {
  76. 			statusCode = 200;
  77. 			webResponse.setStatusCode(statusCode);
  78. 			System.out.println("状态码：" + webResponse.getStatusCode());
  79. 			System.out.println("登录成功了");
  80. 			System.out.println();
  81. 			return webResponse.getWebResponseUserId(statusCode, statusMsg, data, userId);
  82. 		}
  83. 	}
  84.  
  85. 	// 更改密码 更改密码 更改密码
  86. 	@RequestMapping(value = "/resetUserPassword", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  87. 	@ResponseBody
  88. 	public WebResponse resetUserPassword(HttpServletRequest request, HttpSession session) {
  89.  
  90. 		Object data = null;
  91. 		String statusMsg = "";
  92. 		Integer statusCode = 200;
  93. 		int uId = 0;
  94.  
  95. 		// 取参数的方法，对应登录表单中的用户名
  96. 		String user_name = request.getParameter("user_name");
  97. 		String newUser_password = request.getParameter("newUser_password");
  98. 		try {
  99. 			uId = (int) this.userService2.resetPassword(user_name, newUser_password);
  100. 			System.out.println("修改密码返回的id:" + uId);
  101. 		} catch (Exception e) {
  102.  
  103. 		}
  104.  
  105. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  106.  
  107. 	}
  108.  
  109. 	// 用户注册
  110. 	@RequestMapping(value = "/addOrEditUser", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  111. 	@ResponseBody
  112. 	public WebResponse addOrEditTest(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  113. 			String user_id, @RequestParam(required = false) String user_name,
  114. 			@RequestParam(required = false) String user_password) {
  115.  
  116. 		Object data = null;
  117. 		String statusMsg = "用户名已存在，请重新注册！";
  118. 		Integer statusCode = 201;
  119. 		String rearchName = null;
  120. 		try {
  121. 			rearchName = this.userService.rearchUserName(user_name);
  122.  
  123. 			if (!(rearchName.equals("null"))) {
  124. 				return webResponse.getWebResponse(statusCode, statusMsg, data);
  125. 			}
  126. 		} catch (Exception e) {
  127.  
  128. 		}
  129. 		System.out.println("判断用户是否重复：" + rearchName);
  130.  
  131. 		if (user_id == null || user_id.length() == 0) {
  132. 			return this.addUser(request, response, session, user_name, user_password);
  133. 		} else {
  134. 			return this.editUser(request, response, session, user_id, user_name, user_password);
  135. 		}
  136. 	}
  137.  
  138. 	// 添加用户
  139. 	@RequestMapping(value = "/addUser", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  140. 	@ResponseBody
  141. 	public WebResponse addUser(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  142. 			String user_name, String user_password) {
  143. 		Object data = null;
  144. 		String statusMsg = "";
  145. 		Integer statusCode = 200;
  146. 		Map<String, String> paramMap = new HashMap<String, String>();
  147. 		paramMap.put("user_name", user_name);
  148. 		paramMap.put("user_password", user_password);
  149. 		data = paramMap;
  150. 		if (user_name == null || "".equals(user_name.trim()) || user_password == null
  151. 				|| "".equals(user_password.trim())) {
  152. 			statusMsg = " 参数为空错误！！！！";
  153. 			statusCode = 201;
  154. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  155. 		}
  156. 		if (user_name.length() > 255 || user_password.length() > 65535) {
  157. 			statusMsg = " 参数长度过长错误！！！";
  158. 			statusCode = 201;
  159. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  160. 		}
  161. 		User user = new User();
  162.  
  163. 		boolean isAdd = true;
  164.  
  165. 		return this.addOrEditUser(request, response, session, data, user, user_name, user_password, isAdd);
  166. 	}
  167.  
  168. 	@RequestMapping(value = "/editUser", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  169. 	@ResponseBody
  170. 	public WebResponse editUser(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  171. 			String user_id, @RequestParam(required = false) String user_name,
  172. 			@RequestParam(required = false) String user_password) {
  173. 		Object data = null;
  174. 		String statusMsg = "";
  175. 		Integer statusCode = 200;
  176. 		Map<String, String> paramMap = new HashMap<String, String>();
  177. 		paramMap.put("user_id", user_id);
  178. 		paramMap.put("user_name", user_name);
  179. 		paramMap.put("user_password", user_password);
  180. 		data = paramMap;
  181. 		if (user_id == null || "".equals(user_id.trim())) {
  182. 			statusMsg = "未获得主键参数错误！！！";
  183. 			statusCode = 201;
  184. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  185. 		}
  186. 		Integer user_idNumeri = user_id.matches("^[0-9]*$") ? Integer.parseInt(user_id) : 0;
  187. 		if (user_idNumeri == 0) {
  188. 			statusMsg = "主键不为数字错误！！！";
  189. 			statusCode = 201;
  190. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  191. 		}
  192. 		User userVo = this.userService.getById(user_idNumeri);
  193. 		User user = new User();
  194. 		BeanUtils.copyProperties(userVo, user); // 浅复制，重要
  195.  
  196. 		boolean isAdd = false;
  197. 		return this.addOrEditUser(request, response, session, data, user, user_name, user_password, isAdd);
  198. 	}
  199.  
  200. 	/*
  201. 	 * 
  202. 	 */
  203. 	private WebResponse addOrEditUser(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  204. 			Object data, User user, String user_name, String user_password, boolean isAdd) {
  205. 		String statusMsg = "";
  206. 		Integer statusCode = 200;
  207. 		if (user_name != null && !("".equals(user_name.trim()))) {
  208. 			if (user_name.length() > 255) {
  209. 				statusMsg = " 参数长度过长错误,testName";
  210. 				statusCode = 201;
  211. 				return webResponse.getWebResponse(statusCode, statusMsg, data);
  212. 			}
  213. 			// 重要，建立数据，以便后期数据库能调用数据
  214. 			user.setUser_name(user_name); // 建立用户名
  215. 			user.setUser_password(user_password); // 建立密码
  216.  
  217. 		}
  218. 		if (user_password != null && !("".equals(user_password.trim()))) {
  219. 			if (user_password.length() > 65535) {
  220. 				statusMsg = " 参数长度过长错误,info";
  221. 				statusCode = 201;
  222. 				return webResponse.getWebResponse(statusCode, statusMsg, data);
  223. 			}
  224. 		}
  225.  
  226. 		if (isAdd) {
  227.  
  228. 			// 插入语句，插入数据库，重要
  229.  
  230. 			this.userService.insert(user);
  231. 			if (user.getUser_id() > 0) {
  232. 				statusMsg = "成功插入！！！";
  233. 			} else {
  234. 				statusCode = 202;
  235. 				statusMsg = "insert false";
  236. 			}
  237. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  238. 		}
  239. 		int num = this.userService.update(user);
  240. 		if (num > 0) {
  241. 			statusMsg = "成功修改！！！";
  242. 		} else {
  243. 			statusCode = 202;
  244. 			statusMsg = "update false";
  245. 		}
  246. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  247. 	}
  248.  
  249. 	@RequestMapping(value = "/getUserById", produces = "application/json;charset=UTF-8")
  250. 	@ResponseBody
  251. 	public WebResponse getUserById(String user_id) {
  252. 		Object data = user_id;
  253. 		Integer statusCode = 200;
  254. 		String statusMsg = "";
  255. 		if (user_id == null || user_id.length() == 0 || user_id.length() > 11) {
  256. 			statusMsg = "参数为空或参数过长错误！！！";
  257. 			statusCode = 201;
  258. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  259. 		}
  260. 		Integer user_idNumNumeri = user_id.matches("^[0-9]*$") ? Integer.parseInt(user_id) : 0;
  261. 		if (user_idNumNumeri == 0) {
  262. 			statusMsg = "参数数字型错误！！！";
  263. 			statusCode = 201;
  264. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  265. 		}
  266. 		User userVo = this.userService.getById(user_idNumNumeri);
  267.  
  268. 		if (userVo != null && userVo.getUser_id() > 0) {
  269. 			data = userVo;
  270. 			statusMsg = "获取单条数据成功！！！";
  271. 		} else {
  272. 			statusCode = 202;
  273. 			statusMsg = "no record!!!";
  274. 		}
  275. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  276. 	}
  277.  
  278. 	@RequestMapping(value = "/getOneUser", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  279. 	@ResponseBody
  280. 	public WebResponse getOneTest(@RequestParam(defaultValue = "正常", required = false) String tbStatus) {
  281. 		LinkedHashMap<String, String> condition = new LinkedHashMap<String, String>();
  282. 		condition.put("tb_status='" + tbStatus + "'", "");
  283. 		User userVo = this.userService.getOne(condition);
  284. 		Object data = null;
  285. 		String statusMsg = "";
  286. 		if (userVo != null && userVo.getUser_id() > 0) {
  287. 			data = userVo;
  288. 			statusMsg = "根据条件获取单条数据成功！！！";
  289. 		} else {
  290. 			statusMsg = "no record!!!";
  291. 		}
  292. 		return webResponse.getWebResponse(statusMsg, data);
  293. 	}
  294.  
  295. 	@RequestMapping(value = "/getUserList", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  296. 	@ResponseBody
  297. 	public WebResponse getTestList(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  298. 			@RequestParam(defaultValue = "1", required = false) Integer pageNo,
  299. 			@RequestParam(defaultValue = "10", required = false) Integer pageSize,
  300. 			@RequestParam(defaultValue = "正常", required = false) String tbStatus,
  301. 			@RequestParam(required = false) String keyword,
  302. 			@RequestParam(defaultValue = "test_id", required = false) String order,
  303. 			@RequestParam(defaultValue = "desc", required = false) String desc) {
  304. 		Object data = null;
  305. 		String statusMsg = "";
  306. 		int statusCode = 200;
  307. 		LinkedHashMap<String, String> condition = new LinkedHashMap<String, String>();
  308. 		/*
  309. 		 * if (tbStatus != null && tbStatus.length() > 0) { condition.put("tb_status='"
  310. 		 * + tbStatus + "'", "and"); }
  311. 		 */
  312. 		if (keyword != null && keyword.length() > 0) {
  313. 			StringBuffer buf = new StringBuffer();
  314. 			buf.append("(");
  315. 			buf.append("test_name like '%").append(keyword).append("%'");
  316. 			buf.append(" or ");
  317. 			buf.append("info like '%").append(keyword).append("%'");
  318. 			buf.append(" or ");
  319. 			buf.append("other like '%").append(keyword).append("%'");
  320. 			buf.append(")");
  321. 			condition.put(buf.toString(), "and");
  322. 		}
  323. 		String field = null;
  324. 		if (condition.size() > 0) {
  325. 			condition.put(condition.entrySet().iterator().next().getKey(), "");
  326. 		}
  327. 		int count = this.userService.getCount(condition, field);
  328. 		if (order != null && order.length() > 0 & "desc".equals(desc)) {
  329. 			order = order + " desc";
  330. 		}
  331. 		List<User> list = this.userService.getList(condition, pageNo, pageSize, order, field);
  332. 		Map<Object, Object> map = new HashMap<Object, Object>();
  333. 		map.put("total", count);
  334. 		int size = list.size();
  335. 		if (size > 0) {
  336. 			List<User> listFont = new ArrayList<User>();
  337. 			User vo;
  338. 			User voFont = new User();
  339. 			for (int i = 0; i < size; i++) {
  340. 				vo = list.get(i);
  341. 				BeanUtils.copyProperties(vo, voFont);
  342. 				listFont.add(voFont);
  343. 				voFont = new User();
  344. 			}
  345. 			map.put("list", listFont);
  346. 			data = map;
  347. 			statusMsg = "根据条件获取分页数据成功！！！";
  348. 		} else {
  349. 			map.put("list", list);
  350. 			data = map;
  351. 			statusCode = 202;
  352. 			statusMsg = "no record!!!";
  353. 			return webResponse.getWebResponse(statusCode, statusMsg, data);
  354. 		}
  355. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  356. 	}
  357.  
  358. 	@RequestMapping(value = "/getAdminUserList", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  359. 	@ResponseBody
  360. 	public String getAdminTestList(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  361. 			@RequestParam(defaultValue = "1", required = false) Integer pageNo,
  362. 			@RequestParam(defaultValue = "10", required = false) Integer pageSize,
  363. 			@RequestParam(defaultValue = "正常", required = false) String tbStatus,
  364. 			@RequestParam(required = false) String keyword,
  365. 			@RequestParam(defaultValue = "test_id", required = false) String order,
  366. 			@RequestParam(defaultValue = "desc", required = false) String desc) {
  367. 		Object data = null;
  368. 		String statusMsg = "";
  369. 		int statusCode = 200;
  370. 		LinkedHashMap<String, String> condition = new LinkedHashMap<String, String>();
  371.  
  372. 		if (tbStatus != null && tbStatus.length() > 0) {
  373. 			condition.put("tb_status='" + tbStatus + "'", "and");
  374. 		}
  375. 		if (keyword != null && keyword.length() > 0) {
  376. 			StringBuffer buf = new StringBuffer();
  377. 			buf.append("(");
  378. 			buf.append("test_name like '%").append(keyword).append("%'");
  379. 			buf.append(" or ");
  380. 			buf.append("info like '%").append(keyword).append("%'");
  381. 			buf.append(" or ");
  382. 			buf.append("other like '%").append(keyword).append("%'");
  383. 			buf.append(")");
  384. 			condition.put(buf.toString(), "and");
  385. 		}
  386. 		String field = null;
  387. 		if (condition.size() > 0) {
  388. 			condition.put(condition.entrySet().iterator().next().getKey(), "");
  389. 		}
  390. 		int count = this.userService.getCount(condition, field);
  391. 		if (order != null && order.length() > 0 & "desc".equals(desc)) {
  392. 			order = order + " desc";
  393. 		}
  394. 		List<User> list = this.userService.getList(condition, pageNo, pageSize, order, field);
  395. 		Map<Object, Object> map = new HashMap<Object, Object>();
  396. 		map.put("total", count);
  397. 		int size = list.size();
  398. 		if (size > 0) {
  399. 			map.put("list", list);
  400. 			data = map;
  401. 			statusMsg = "根据条件获取分页数据成功！！！";
  402. 		} else {
  403. 			map.put("list", list);
  404. 			data = map;
  405. 			statusCode = 202;
  406. 			statusMsg = "no record!!!";
  407. 		}
  408. 		return JSON.toJSONString(data);
  409. 	}
  410.  
  411. 	@RequestMapping(value = "/delUser", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  412. 	@ResponseBody
  413. 	public WebResponse delTest(int id) {
  414. 		int num = this.userService.delBySign(id);
  415. 		Object data = null;
  416. 		String statusMsg = "";
  417. 		if (num > 0) {
  418. 			statusMsg = "成功删除！！！";
  419. 		} else {
  420. 			statusMsg = "no record!!!";
  421. 		}
  422. 		return webResponse.getWebResponse(statusMsg, data);
  423. 	}
  424.  
  425. }

我的音乐控制层：

  1. /**
  2.  * 我的音乐控制层
  3.  */
  5. @Controller
  6. @RequestMapping("/myMusic")
  7. public class MyMusicController {
  8.  
  9. 	@Autowired
  10. 	protected WebResponse webResponse;
  11.  
  12. 	@Resource
  13. 	protected IMyMusicService myMusicService;
  14.  
  15. //	@Autowired
  16. //	MyMusicService myMusicService2;
  17.  
  18. 	// 歌曲收藏
  19. 	@RequestMapping(value = "/addMusicCollect", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  20. 	@ResponseBody
  21. 	public WebResponse addMusicCollect(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  22. 			@RequestParam(required = false) String user_name) {
  23. 		WebResponse webResponse = new WebResponse();
  24. 		MyMusic myMusic = new MyMusic();
  25. 		System.out.println("接收到的用户名:" + user_name);
  26.  
  27. 		Integer statusCode = 200;
  28.  
  29. 		// 数据库插入语句，对应xml文件的insert
  30. 		this.myMusicService.insert(myMusic);
  31.  
  32. 		webResponse.setStatusCode(statusCode);
  33. 		return webResponse;
  34.  
  35. 	}
  36.  
  37. 	// 从数据库中获取歌曲数据，在我的音乐中显示
  38. 	@RequestMapping(value = "/getMyMusicList", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  39. 	@ResponseBody
  40. 	public WebResponse getMyMusicList(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  41. 			@RequestParam(defaultValue = "1", required = false) Integer pageNo,
  42. 			@RequestParam(defaultValue = "10", required = false) Integer pageSize,
  43. 			@RequestParam(defaultValue = "正常", required = false) String tbStatus,
  44. 			@RequestParam(required = false) String keyword,
  45. 			@RequestParam(defaultValue = "ml_id", required = false) String order,
  46. 			@RequestParam(defaultValue = "desc", required = false) String desc,
  47. 			@RequestParam(required = false) String user_name, @RequestParam(required = false) String user_password
  48. 			) {
  49.  
  50. //		System.out.println("我的音乐显示列表前收藏的歌曲id:" + song_id);
  51. 		String user_Id = null;
  52. 		try {
  53. 			user_Id = myMusicService.getUserById(user_name, user_password);
  54. 		} catch (Exception e) {
  55.  
  56. 		}
  57. 		int userId = 0;
  58. 		try {
  59. 			// 判断字符串是否是数字，并且抛出异常
  60. 			boolean NotisNum = (user_Id.equals("null"));
  61. 			// System.out.println(NotisNum);
  62. 			if (!NotisNum) {
  63. 				userId = Integer.parseInt(user_Id);
  64. 			}
  65. 		} catch (Exception e) {
  66.  
  67. 		}
  68. 		System.out.println("我的音乐显示列表前用户id:" + userId);
  69.  
  70. 		Object data = null;
  71. 		String statusMsg = "";
  72. 		int statusCode = 200;
  73. 		LinkedHashMap<String, String> condition = new LinkedHashMap<String, String>();
  74. 		/*
  75. 		 * if (tbStatus != null && tbStatus.length() > 0) { condition.put("tb_status='"
  76. 		 * + tbStatus + "'", "and"); }
  77. 		 */
  78. 		if (keyword != null && keyword.length() > 0) {
  79. 			StringBuffer buf = new StringBuffer();
  80. 			buf.append("(");
  81. 			buf.append("test_name like '%").append(keyword).append("%'");
  82. 			buf.append(" or ");
  83. 			buf.append("info like '%").append(keyword).append("%'");
  84. 			buf.append(" or ");
  85. 			buf.append("other like '%").append(keyword).append("%'");
  86. 			buf.append(")");
  87. 			condition.put(buf.toString(), "and");
  88. 		}
  89. 		String field = null;
  90. 		if (condition.size() > 0) {
  91. 			condition.put(condition.entrySet().iterator().next().getKey(), "");
  92. 		}
  93. 		// int count = this.myMusicService.getCount(condition, field);
  94. 		if (order != null && order.length() > 0 & "desc".equals(desc)) {
  95. 			order = order + " desc";
  96. 		}
  97.  
  98. 		// List<MyMusic> list = this.myMusicService.getList(condition, pageNo, pageSize,
  99. 		// order, field);
  100.  
  101. 		try {
  102. 			List<MyMusic> list = this.myMusicService.getMyMusicList(userId);
  103.  
  104. 			Map<Object, Object> map = new HashMap<Object, Object>();
  105. 			// map.put("total", count);
  106. 			int size = list.size();
  107. 			if (size > 0) {
  108. 				List<MyMusic> listFont = new ArrayList<MyMusic>();
  109. 				MyMusic vo;
  110. 				MyMusic voFont = new MyMusic();
  111. 				for (int i = 0; i < size; i++) {
  112. 					vo = list.get(i);
  113. 					// 通过java反射将类中当前属性字段对应的内容复制到另外一个类中
  114. 					BeanUtils.copyProperties(vo, voFont);
  115. 					listFont.add(voFont);
  116. 					voFont = new MyMusic();
  117. 				}
  118. 				map.put("list", listFont);
  119. 				data = map;
  120. 				statusMsg = "根据条件获取分页数据成功！！！";
  121. 			} else {
  122. 				map.put("list", list);
  123. 				data = map;
  124. 				statusCode = 202;
  125. 				statusMsg = "no record!!!";
  126. 				return webResponse.getWebResponse(statusCode, statusMsg, data);
  127. 			}
  128.  
  129. 		}catch (Exception e){
  130.  
  131. 		}
  132.  
  133.  
  134.  
  135.  
  136.  
  137.  
  138. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  139. 	}
  140.  
  141. 	// 删除音乐
  142. 	@RequestMapping(value = "/deleteMyMusic", method = RequestMethod.POST, produces = "application/json;charset=UTF-8")
  143. 	@ResponseBody
  144. 	public WebResponse deleteMyMusic(HttpServletRequest request, HttpServletResponse response, HttpSession session,
  145. 			@RequestParam(required = false) Integer user_id, @RequestParam(required = false) Integer song_id) {
  146. 		WebResponse webResponse = new WebResponse();
  147. 		MyMusic myMusic = new MyMusic();
  148. 		System.out.println("删除音乐前的用户名id:" + user_id);
  149.  
  150. 		Object data = null;
  151. 		String statusMsg = "";
  152. 		int statusCode = 201;
  153. 		int del = 0;
  154.  
  155. 		if (user_id == null){
  156. 			 del = this.myMusicService.deleteMyMusic(song_id, 0);
  157. 		}else {
  158. 			del = this.myMusicService.deleteMyMusic(song_id, user_id);
  159. 		}
  160.  
  161. 		if (del > 0) {
  162. 			statusCode = 200;
  163. 		}
  164.  
  165. 		return webResponse.getWebResponse(statusCode, statusMsg, data);
  166. 	}
  167.  
  168. }

 

源码获取：博客首页 "资源" 里下载！

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/2023面试高手/article/detail/218434
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号