Java源码社

基于javaweb的JSP+Servlet在线旅游路线商城系统(java+jsp+javascript+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

010023582402

020023582402

030023582402

040023582402

050023582402

070023582402

基于javaweb的JSP+Servlet在线旅游路线商城系统(java+jsp+javascript+servlet+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版本； 6.是否Maven项目：否；

技术栈

JSP+CSS+JavaScript+java+servlet+mysql

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中src/com/hr/dao/Basedao.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/ 登录 管理员账号/密码：admin/admin  用户账号/密码：user/123456

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
}

int cpage = 1;//当前页数
int count = 8;//每页行数
String cp = req.getParameter("cp");
if(cp!=null){//如果页面上传递了页数,将当前页数改变掉
	cpage = Integer.parseInt(cp);
}
//查出总页数
int tpage = 0;
String fid = req.getParameter("fid");
String cid = req.getParameter("cid");
String name = req.getParameter("name");
ArrayList<EASYBUY_PRODUCT> list = null;
if(fid==null&&cid==null){
	list = EASYBUY_PRODUCTDao.selectAll(cpage, count);
	req.setAttribute("title", "全部旅游路线");
	tpage = EASYBUY_PRODUCTDao.totalPage(count);
}
if(fid!=null){
	int id = Integer.parseInt(fid);
	list = EASYBUY_PRODUCTDao.selectAllByFid(cpage, count, id);
	tpage = EASYBUY_PRODUCTDao.totalPageByFid(count, id);
	req.setAttribute("title", EASYBUY_PRODUCT_CATEGORYDao.selectById(id).getEPC_NAME());
}
if(cid!=null){
	int id = Integer.parseInt(cid);
	list = EASYBUY_PRODUCTDao.selectAllByCid(cpage, count, id);
	tpage = EASYBUY_PRODUCTDao.totalPageByCid(count, id);
	req.setAttribute("title", EASYBUY_PRODUCT_CATEGORYDao.selectById(id).getEPC_NAME());
}
if(name!=null){
	list = EASYBUY_PRODUCTDao.selectAllByName(name);
	tpage = EASYBUY_PRODUCTDao.totalPageByName(count, name);
	req.setAttribute("title", "搜索旅游路线："+name);
} 
req.setAttribute("list", list);
//当前页数
req.setAttribute("cpage", cpage);
//总页数
req.setAttribute("tpage", tpage);
//搜索关键字
req.setAttribute("search_words", name);
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

public class UserNumServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		int width=120;
		int height=60;
		BufferedImage img=new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB);
		Graphics2D g=img.createGraphics();
		
		g.setColor(Color.LIGHT_GRAY);
		g.fillRect(0, 0, width, height);
		
		g.setColor(Color.YELLOW);
		Random rand=new Random();
		for (int i = 0; i < 15; i++) {
			int x1=rand.nextInt(width);
			int y1=rand.nextInt(width);
			int x2=rand.nextInt(width);
			int y2=rand.nextInt(width);
			g.drawLine(x1, y1, x2, y2);
		}
		
		Font f=new Font("Times New Roman",Font.BOLD,50);
		g.setFont(f);
		int red=0,green=0,blue=0;
		String code="";
		
		for (int i = 0; i < 4; i++) {
			red=rand.nextInt(255);
			green=rand.nextInt(255);
			blue=rand.nextInt(255);
			
			Color c=new Color(red,green,blue);
			g.setColor(c);
			int num=rand.nextInt(10);
			code+=num;
			g.drawString(num+"", i*20+20, 49);
		}
		
		HttpSession session=req.getSession();
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


public class SelectProductViewServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		
		ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
		req.setAttribute("flist", flist);
		ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
		req.setAttribute("clist", clist);
		String id = req.getParameter("id");
		HttpSession session = req.getSession();
		//查询最近浏览的旅游路线
		ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
		if(ids==null){
			ids = new ArrayList<Integer>();
		}
		if(ids.size()>=5){
			ids.remove(0);
		}
		//System.out.println(!ids.contains(Integer.parseInt(id)));
		if(id!=null&&(!ids.contains(Integer.parseInt(id)))){
			ids.add(Integer.parseInt(id));
		}
		session.setAttribute("ids", ids);
		ids = (ArrayList<Integer>) session.getAttribute("ids");
		if(ids!=null){
			ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
			req.setAttribute("lastlylist", lastlylist);
		}
		//查询旅游路线
		EASYBUY_PRODUCT p = null;
		if(id!=null){
			p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id));
		}
		req.setAttribute("p", p);
		req.getRequestDispatcher("product-view.jsp").forward(req, resp);
	}
}

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

public class UserNumServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		int width=120;
		int height=60;
		BufferedImage img=new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB);
		Graphics2D g=img.createGraphics();
		
		g.setColor(Color.LIGHT_GRAY);
		g.fillRect(0, 0, width, height);
		
		g.setColor(Color.YELLOW);
		Random rand=new Random();
		for (int i = 0; i < 15; i++) {
			int x1=rand.nextInt(width);
			int y1=rand.nextInt(width);
			int x2=rand.nextInt(width);
			int y2=rand.nextInt(width);
			g.drawLine(x1, y1, x2, y2);
		}
		
		Font f=new Font("Times New Roman",Font.BOLD,50);
		g.setFont(f);
		int red=0,green=0,blue=0;
		String code="";
		
		for (int i = 0; i < 4; i++) {
			red=rand.nextInt(255);
			green=rand.nextInt(255);
			blue=rand.nextInt(255);
			
			Color c=new Color(red,green,blue);
			g.setColor(c);
			int num=rand.nextInt(10);
			code+=num;
			g.drawString(num+"", i*20+20, 49);
		}
		
		HttpSession session=req.getSession();
		session.setAttribute("syscode", code);
		
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
													fname);
		}
		int count = 0;
		if(p!=null){
			count = EASYBUY_PRODUCTDao.insert(p);
		}
		
		req.getRequestDispatcher("productSelect").forward(req, resp);
		
	}
}





public class SelectProductViewServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		
		ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
		req.setAttribute("flist", flist);
		ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
		req.setAttribute("clist", clist);
		String id = req.getParameter("id");
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

public class SelectProductViewServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		
		ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
		req.setAttribute("flist", flist);
		ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
		req.setAttribute("clist", clist);
		String id = req.getParameter("id");
		HttpSession session = req.getSession();
		//查询最近浏览的旅游路线
		ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
		if(ids==null){
			ids = new ArrayList<Integer>();
		}
		if(ids.size()>=5){
			ids.remove(0);
		}
		//System.out.println(!ids.contains(Integer.parseInt(id)));
		if(id!=null&&(!ids.contains(Integer.parseInt(id)))){
			ids.add(Integer.parseInt(id));
		}
		session.setAttribute("ids", ids);
		ids = (ArrayList<Integer>) session.getAttribute("ids");
		if(ids!=null){
			ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
			req.setAttribute("lastlylist", lastlylist);
		}
		//查询旅游路线
		EASYBUY_PRODUCT p = null;
		if(id!=null){
			p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id));
		}
		req.setAttribute("p", p);
		req.getRequestDispatcher("product-view.jsp").forward(req, resp);
	}
}


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