1 概述
该系统分为后台管理员登录、前台用户，具体功能描述如下所示：
管理员(后台用户)
系统管理：该模块实现的功能有公告管理、发布公告、友情链接、网站留言管理、管理员设置、后台登录日志。
会员管理：对注册的用户进行管理，包括删除、修改等操作，可按日期、会员名进行搜索。
音乐管理：可对歌曲进行分类，在每个分类下，可进行音乐的添加、删除、修改等操作。并提供多种条件的查询。
音乐资讯管理：该模块实现的功能有管理音乐资讯、发布音乐资讯，如标题、是否显示等。
注册会员管理：该模块是对注册会员的信息管理，如会员名、注册时间、登录次数、上次登录时间等。
网站投票管理：该模块是管理网站投票、发布网站投票，如名称、好评票数、差评票数。
会员（前台用户）
注册、登录界面：用户通过填写自己的个人信息进行注册。注册后的用户可以通过会员登录界面进行登录，登录后可以进行相应的操作，如下载歌曲，评论歌曲等。
主界面：包括系统公告，音乐资讯、音乐列表、热点音乐、网站投票、音乐查询、留言板等。
系统公告：用户可在主界面查看公告。
搜索歌曲：可按照歌曲类型、地区、歌名、歌手名等条件进行搜索。
网站投票：注册的会户可对网站进行投票，如投票名称、总票数、好评率、差评率等。
歌曲下载:注册的用户可对歌曲进行下载。在下载时，要有免责提示。
留言板：会员登录网站后可以查看网站留言和在线留言等。
2 数据库表
表7 music 音乐
| 字段名称 | 自动增长 | 字段大小 | 字段类型 | 说明 |
| id | - | 4 | int | - |
| title | - | 255 | varchar | 标题 |
| url | - | 255 | varchar | 图片 |
| address | - | 255 | varchar | 附件 |
| linkman | - | 255 | varchar | 歌手 |
| content | - | 255 | varchar | 内容 |
| addtime | - | 255 | varchar | 日期 |
| flag | - | 255 | varchar | 标志 |
| type | - | 4 | int | 类型 |
| erwei | - | 255 | varchar | 图片 |
| userid | - | 255 | varchar | 用户Id |
3 关键代码
package com.action;import java.io.IOException;
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import com.bean.musicBean;
import com.util.Constant;public class musicactionServlet extends HttpServlet {/*** Constructor of the object.*/public musicactionServlet() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get.* * @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post.* * @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding(Constant.CHARACTERENCODING);response.setContentType(Constant.CONTENTTYPE);musicBean tb=new musicBean();String method=request.getParameter("method").trim();if(method.equals("delmusic")){String id=request.getParameter("id").trim();int flag = tb.delmusic(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/music/index.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/music/index.jsp").forward(request, response);}}else if(method.equals("delmusicm")){String id=request.getParameter("id").trim();int flag = tb.delmusic(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("hy_music.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("hy_music.jsp").forward(request, response);}}else if(method.equals("delshoucang")){//删除收藏 String id=request.getParameter("id").trim();HttpSession session = request.getSession();String member = (String) session.getAttribute("member");int flag = tb.delShoucang(id,member);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("hy_shoucang.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("hy_shoucang.jsp").forward(request, response);}}else if(method.equals("hotdelmusic")){String id=request.getParameter("id").trim();int flag = tb.delmusic(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/music/hot.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/music/hot.jsp").forward(request, response);}}else if(method.equals("hotmusic")){String id=request.getParameter("id").trim();int flag = tb.hotmusic(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/music/index.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/music/index.jsp").forward(request, response);}}else if(method.equals("nohotmusic")){String id=request.getParameter("id").trim();int flag = tb.nohotmusic(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/music/hot.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/music/hot.jsp").forward(request, response);}}else if(method.equals("addTP")){String name=request.getParameter("name").trim();String good=request.getParameter("good");String bad=request.getParameter("bad");int flag=tb.addTP(name, good, bad);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}}else if(method.equals("upTP")){String id=request.getParameter("id").trim();String name=request.getParameter("name");String good=request.getParameter("good");String bad=request.getParameter("bad");int flag=tb.upTP(id,name, good, bad);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}}else if(method.equals("delTP")){String id=request.getParameter("id").trim();int flag=tb.delTP(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("admin/tp/index.jsp").forward(request, response);}}else if(method.equals("goodTP")){String id=request.getParameter("id").trim();int flag=tb.goodTP(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("tp.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("tp.jsp").forward(request, response);}}else if(method.equals("badTP")){String id=request.getParameter("id").trim();int flag=tb.badTP(id);if(flag == Constant.SUCCESS){request.setAttribute("message", "操作成功！");request.getRequestDispatcher("tp.jsp").forward(request, response);}else{request.setAttribute("message", "系统维护中，请稍后再试！");request.getRequestDispatcher("tp.jsp").forward(request, response);}}}/*** Initialization of the servlet. <br>** @throws ServletException if an error occure*/public void init() throws ServletException {// Put your code here}}
