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
}
}