Java源码社

基于javaweb的JSP+Servlet在线药店管理系统(java+jsp+bootstrap+jquery+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

410023572402

420023572402

430023572402

450023572402

460023572402

470023572402

基于javaweb的JSP+Servlet在线药店管理系统(java+jsp+bootstrap+jquery+mysql)

含PPT

项目介绍

基于jsp+servlet在线药店管理系统。 该项目是一个后管系统，只有一个管理员角色，功能比较简单，适合java初学者或者学生做课程设计等；

主要功能包括：

用户登录、注册；系统管理、药品管理、顾客信息管理、供货商管理、订单管理等；

环境需要

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.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目  6.数据库：MySql 5.7版本；

技术栈

  1. 后端：servlet 2. 前端：JSP+bootstrap+jQuery

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行； 3. 将项目中c3p0.properties配置文件中的数据库配置改为自己的配置 4. 运行项目，输入http://localhost:8080/shop 登录 5. 账户admin 密码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
			customer.setCemail(cemail);
			customer.setCaddress(caddress);
			//System.out.println(customer);//检查。
			boolean z=customerService.updateCustomer(customer);
			if(z)
			{
				showCustomerByPage(request,response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void updateCustomerByCid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is updateCustomerByCid....");
		int cid=Integer.parseInt(request.getParameter("cid"));
		//System.out.println(did);

		Customer customer=customerService.showCustomerByCid(cid);
		if(customer!=null)
		{
			request.setAttribute("customer", customer);
			request.getRequestDispatcher("customer/edit.jsp").forward(request, response);
		}
	}

}
package servlet;




/**
 * Servlet implementation class OrderServlet
 */
@WebServlet("/orderServlet.do")
public class OrderServlet extends BaseServlet{
	private static final long serialVersionUID = 1L;
	private OrderService orderService=new OrderService();

	public void insertOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
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
			drug.setFunction(function);
			//System.out.println(drug);//检查。
			boolean z=drugService.updateDrug(drug);
			if(z)
			{
				showDrugByPage(request,response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void updateDrugByDid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is updateDrugByDid....");
		String did=request.getParameter("did");
		Drug drug=drugService.showDrugByDid(did);
		if(drug!=null)
		{
			request.setAttribute("drug", drug);
			request.getRequestDispatcher("drug/edit.jsp").forward(request, response);
		}
	}
}
package servlet;




/**
 * Servlet implementation class CustomerServlet
 */
@WebServlet("/customerServlet.do")
public class CustomerServlet extends BaseServlet {
	private static final long serialVersionUID = 1L;
	private CustomerService customerService=new CustomerService();

	public void insertCustomer(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is insertCustomer....");
		try {
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
		order.setDid(did);
		order.setOquantity(oquantity);
		order.setOprice(oprice);
		order.setCid(cid);
		order.setOdate(odate);

		System.out.println(order);//检查。
		boolean z=orderService.insertOrder(order);
		if(z)
		{
			showOrderByPage(request,response);
		}
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}

public void deleteOrderByOid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	System.out.println("this is deleteOrderByOid....");
	int oid=Integer.parseInt(request.getParameter("oid"));
	boolean z= orderService.deleteOrderByOid(oid);
	System.out.println("z:"+z);
	if(z)
	{
		showOrderByPage(request,response);
	}
}

public void showOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	System.out.println("this is showOrder.....");
	List<Order> order=orderService.showOrder();
	request.setAttribute("order", order);
	request.getRequestDispatcher("order/index.jsp").forward(request, response);
}

public void showOrderByPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	System.out.println("this is showOrderByPage.....");
	String current_page=request.getParameter("current_page");
	//先有鸡还是先有蛋。
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
50
51
52
53

/**
 * Servlet implementation class DrugServlet
 */
@WebServlet("/drugServlet.do")
public class DrugServlet extends BaseServlet {
	private static final long serialVersionUID = 1L;
	private DrugService drugService=new DrugService();

	public void insertDrug(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is insertDrug....");
		try {
			String did=request.getParameter("did");
			String dname=request.getParameter("dname");
			String dclass=request.getParameter("dclass");
			String dprice=request.getParameter("dprice");

			String pro = request.getParameter("prodate");
			//SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
			java.sql.Date prodate=java.sql.Date.valueOf(pro);

			String ex = request.getParameter("exdate");
			java.sql.Date exdate=java.sql.Date.valueOf(ex);

			int requantity=Integer.parseInt(request.getParameter("requantity"));
			String sname= request.getParameter("sname");
			String function= request.getParameter("function");
			Drug drug=new Drug();
			drug.setDid(did);
			drug.setDname(dname);
			drug.setDclass(dclass);
			drug.setDprice(dprice);
			drug.setProdate(prodate);
			drug.setExdate(exdate);
			drug.setRequantity(requantity);
			drug.setSname(sname);
			drug.setFunction(function);

			System.out.println(drug);//检查。
			boolean z=drugService.insertDrug(drug);
			if(z)
			{
				showDrugByPage(request,response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void deleteDrugByDid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is deleteDrugByDid....");
		String did=request.getParameter("did");
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





/**
 * Servlet implementation class AdminServlet
 */
@WebServlet("/adminServlet.do")
public class AdminServlet extends BaseServlet {
	private static final long serialVersionUID = 1L;
	private AdminService adminService=new AdminService();

	public void insertAdmin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("this is insertAdmin....");
		try {
			String aname=request.getParameter("aname");
			String apassword=request.getParameter("apassword");
			String aphone= request.getParameter("aphone");
			String aaddress= request.getParameter("aaddress");
			Admin admin=new Admin();
			admin.setAname(aname);
			admin.setApassword(apassword);
			admin.setAphone(aphone);
			admin.setAaddress(aaddress);
			//System.out.println(admin);//检查。
			boolean z=adminService.insertAdmin(admin);
			if(z)
			{
				showAdminByPage(request,response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

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