Java源码社

基于javaweb的JSP+Servlet会员卡积分管理系统(java+jsp+javascript+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

192025381302

392025381302

480023422402

490023422402

500023422402

510023422402

322025341302

基于javaweb的JSP+Servlet会员卡积分管理系统(java+jsp+javascript+mysql)

项目介绍

管理员角色包含以下功能： 登录,系统用户管理,修改后台登录密码,会员管理,添加会员,注册用户管理,会员卡管理,添加会员卡,会员卡充值,商品管理,会员积分统计,留言管理,信息统计图,积分兑换商品等功能。

用户角色包含以下功能： 登录,登录后页面,修改密码,修改详细资料,留言板等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；  5.数据库：MySql 5.7版本；

技术栈

HTML+CSS+JavaScript+jsp+mysql

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/login.jsp 登录  

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
}
else{
	String method = request.getParameter("method").trim();
	
	/**********************************************
	 * 新闻
	 ************************************************/
	if(method.equals("DELNEWS")){//删除新闻 来自普通新闻页面index.jsp
		String strDirPath = request.getSession().getServletContext().getRealPath("/");
		String check[] = request.getParameterValues("checkit");
     			if(check == null){
			request.setAttribute("message", "请选择要删除的记录！");
			request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
		}
		else{
			int id2[]= new int[check.length];
			for(int i = 0;i<check.length;i++){
				int s = Integer.parseInt(check[i]);				
				id2[i] = s;
			}
			int flag = new NewsBean().delNews(id2); 
			if(flag == Constant.SUCCESS){
				request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "系统维护中，请稍后再试！");
				request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
			}
		}
	}
	else if(method.equals("HIDENEWS")){//隐藏、显示新闻 来自普通新闻页面index.jsp
		String id = Filter.escapeHTMLTags(request.getParameter("id").trim());
		int flag = new NewsBean().hideNews(Integer.parseInt(id));
		if(flag == Constant.SUCCESS){
			request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
		}
		else{
			request.setAttribute("message", "系统维护中，请稍后再试！");
			request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
		}
	}
	else if(method.equals("UPNEWS")){//置顶 新闻 来自普通新闻页面index.jsp
		String id = Filter.escapeHTMLTags(request.getParameter("id").trim());
		int flag = new NewsBean().upNews(Integer.parseInt(id));
		if(flag == Constant.SUCCESS){
			request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
		}
		else{
			request.setAttribute("message", "系统维护中，请稍后再试！");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
/**
 * 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 {

	response.setContentType(Constant.CONTENTTYPE);
	request.setCharacterEncoding(Constant.CHARACTERENCODING);
	HttpSession session = request.getSession();
	MemberBean memberBean = new MemberBean();
	String method = Filter.escapeHTMLTags(request.getParameter("method").trim());
	/*********************************************
	 * 会员注册通用（检查用户名 修改密码 reg2.jsp页面跳转）
	 *********************************************/
	if(method.equals("reg2")){//会员注册 reg2.jsp
		String username = Filter.escapeHTMLTags(request.getParameter("username").trim());
		String password = Filter.escapeHTMLTags(request.getParameter("password").trim());
		String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim());
		request.setAttribute("username", username);
		request.setAttribute("password", password);
		request.setAttribute("reg_type", reg_type);
		if(username.trim().equals("admin")){
			request.setAttribute("username", username);
			request.setAttribute("message", "非法的用户名，请重新选择！");
			request.getRequestDispatcher("reg2.jsp").forward(request, response);
		}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
}
else if(method.equals("checksame")){//检查注册名是否可用
	String username = Filter.escapeHTMLTags(request.getParameter("username").trim());
	if(username.trim().equals("admin")){
		request.setAttribute("username", username);
		request.setAttribute("message", "非法的用户名，请重新选择！");
		request.getRequestDispatcher("reg2.jsp").forward(request, response);
	}
	else{
		int flag = memberBean.checkRegName(username);
		if(flag == Constant.SUCCESS){
			request.setAttribute("username", username);
			request.setAttribute("message", "恭喜您，这个名字可以使用！");
			request.getRequestDispatcher("reg2.jsp").forward(request, response);
		}
		else if(flag == Constant.SAME_NAME){
			request.setAttribute("username", username);
			request.setAttribute("message", "对不起，该用户名已存在，请重新选择！");
			request.getRequestDispatcher("reg2.jsp").forward(request, response);
		}
		else{
			request.setAttribute("message", "系统维护中，请稍后再试！");
			request.getRequestDispatcher("reg2.jsp").forward(request, response);
		}
	}
}
else if(method.equals("Editpwd")){//会员修改登陆密码
	String member=(String)session.getAttribute("member");
	String type=(String)session.getAttribute("type");
	if(member==null||type==null){
		response.sendRedirect("error.jsp");
	}
	else{
		String oldpwd = MD5.MD5(request.getParameter("oldpwd").trim());
		String newpwd = MD5.MD5(request.getParameter("newpwd").trim());
		int flag = memberBean.editPassword(member, oldpwd, newpwd);
		switch (flag){
			case Constant.SUCCESS:
				request.setAttribute("message", "密码修改成功！");
				request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response);
				break;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
	}

}

/**
 * 上传控制servlet中无法实现的功能由此操作 
 * 
 * 通用操作控制
 * 
 */




public class CommonAction extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public CommonAction() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
	}
}
else if(method.equals("delNews")){
	String id = request.getParameter("id");
	int flag = new NewsBean().exeUp("delete from news  where id='"+id+"'");
	if(flag == Constant.SUCCESS){
		request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
	}
}
else if(method.equals("addPrep")){
	String member=(String)session.getAttribute("member");
	String sid = request.getParameter("sid");
	String title = request.getParameter("title");
	String rs = request.getParameter("rs");
	String sj = request.getParameter("sj");
	String ts = request.getParameter("ts");
	String lxr = request.getParameter("lxr");
	String lxfs = request.getParameter("lxfs");
	new NewsBean().exeUp("update sale set dj=dj+1 where id='"+sid+"'");
	int flag = new NewsBean().exeUp("insert into prep(title,rs,sj,ts,lxr,lxfs,addtime,member,zt,ddid) " +
			"values('"+title+"','"+rs+"','"+sj+"','"+ts+"','"+lxr+"','"+lxfs+"','"+date+"','"+member+"','未提交','0')");
	if(flag == Constant.SUCCESS){
		request.setAttribute("message", "预订成功，稍后本站客服人员会与您取得联系。您可以在会员中心查看您的预订记录！");
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}
}
else if(method.equals("upPrep")){
	String member=(String)session.getAttribute("member");
	String id = request.getParameter("id"); 
	String rs = request.getParameter("rs");
	String sj = request.getParameter("sj");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {

	response.setContentType(Constant.CONTENTTYPE);
	request.setCharacterEncoding(Constant.CHARACTERENCODING);
	String sysdir = new SystemBean().getDir();
	HttpSession session = request.getSession();
	try{
		String username2 = (String)session.getAttribute("user");
		if(username2 == null){
			request.getRequestDispatcher("error.jsp").forward(request, response);
		}
		else{
			String method = request.getParameter("method").trim();
			
			/**********************************************
			 * 新闻
			 ************************************************/
			if(method.equals("DELNEWS")){//删除新闻 来自普通新闻页面index.jsp
				String strDirPath = request.getSession().getServletContext().getRealPath("/");
				String check[] = request.getParameterValues("checkit");
       			if(check == null){
					request.setAttribute("message", "请选择要删除的记录！");
					request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
				}
				else{
					int id2[]= new int[check.length];
					for(int i = 0;i<check.length;i++){
						int s = Integer.parseInt(check[i]);				
						id2[i] = s;
					}
					int flag = new NewsBean().delNews(id2); 
					if(flag == Constant.SUCCESS){
						request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);
					}
					else{
						request.setAttribute("message", "系统维护中，请稍后再试！");
						request.getRequestDispatcher(sysdir+"/news/index.jsp").forward(request, response);

项目链接：
https://javayms.github.io?id=541122512008200nk
https://javayms.pages.dev?id=541122512008200nk