Java源码社

基于javaweb的JSP+Servlet超市账单管理系统(java+mysql+jsp)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

442023440509

452023440509

462023440509

482023440509

492023440509

502023440509

基于javaweb的JSP+Servlet超市账单管理系统(java+mysql+jsp)

登录：
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



/**
 * Servlet implementation class InsertBillServlet
 */
@WebServlet("/InsertBillServlet")
public class InsertBillServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
		
		doPost(request,response);
;	}
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		//获取账单编号
		String bill_no =  request.getParameter("billNo");
		
		System.out.println(request.getParameter("billNo"));
		//交易金额
		System.out.println(request.getParameter("billprice"));
		float bill_price = Float.valueOf(request.getParameter("billprice")).floatValue();
		//交易数量
		Integer bill_num = Integer.parseInt(request.getParameter("productNum"));
		//商品名称
		String bill_name = request.getParameter("billName");
		//商品描述
		String bill_prodescribe	 = request.getParameter("discription");
		//所属供应商
		Integer provider_id = Integer.parseInt(request.getParameter("provider"));
		//是否付款
		String bill_payment = (String) request.getParameter("isPay");
		Bill bill= new Bill(bill_no,bill_name,bill_num,bill_price,bill_payment,bill_prodescribe,getNowDate(),provider_id);
		BillDao bd =new BillDao();
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
				request.getRequestDispatcher("userAdmin.jsp").forward(request, response);
				
			}else {
				request.getSession().setAttribute("userResult", list);
				request.getRequestDispatcher("userAdmin.jsp").forward(request, response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.getRequestDispatcher("userAdmin.jsp").forward(request,response);
		}
		
		
	}

}




@WebServlet("/ProviderRetrieveServlet")
public class ProviderRetrieveServlet extends HttpServlet  {
		private static final long serialVersionUID = 1L;
	       
	    /**
	     * @see HttpServlet#HttpServlet()
	     */
	    public ProviderRetrieveServlet() {
	        super();
	        // TODO Auto-generated constructor stub
	    }
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
				request.getSession().setAttribute("upselfmessage", "失败");
				request.getRequestDispatcher("userSearch.jsp").forward(request, response);
				//response.sendRedirect("userUpdate.jsp");
			}
		}else {
			request.getRequestDispatcher("userselfUpdate.jsp").forward(request, response);
			//response.sendRedirect("userUpdate.jsp");					
		}
	}

}








/**
 * Servlet implementation class RegisterServlet
 */
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public RegisterServlet() {
        super();
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
		@Override
		protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			// TODO Auto-generated method stub
			//获取请求前 设置字符集编码
			request.setCharacterEncoding("utf-8");
			//MIME类型
			response.setContentType("text/html;charset=utf-8");
			
			//获取修改的表单信息
			Integer provider_id = Integer.parseInt(request.getParameter("proId"));
			String provider_name = request.getParameter("proName");
			String provider_desc = request.getParameter("proDesc");
			String provider_contact = request.getParameter("contact");
			String provider_phone = request.getParameter("phone");
			String provider_fax = request.getParameter("fax");
			String provider_address = request.getParameter("address");
			
			
			//providerDao(链接,方法)
			ProviderDao pd = new ProviderDao();
			Provider provider= new Provider();
			provider.setProvider_id(provider_id);
			provider.setProvider_name(provider_name);
			provider.setProvider_desc(provider_desc);
			provider.setProvider_contact(provider_contact);
			provider.setProvider_phone(provider_phone);
			provider.setProvider_fax(provider_fax);
			provider.setProvider_address(provider_address);
			
			
			if(provider_name !=null && provider_desc!=null && provider_contact!=null &&
					provider_phone!=null && provider_fax!=null && provider_address!=null) {
				//若修改成功则成功
				if(pd.updateProByID(provider_id,provider)) {
					//返回结果
					request.getSession().setAttribute("providermessage", "成功");
					request.getRequestDispatcher("providerAdmin.jsp").forward(request, response);
				}else {
					request.getSession().setAttribute("providermessage", "失败");
					response.sendRedirect("providerUpdate.jsp");
				}
			}else {
				request.getSession().setAttribute("providermessage", "失败");
				response.sendRedirect("providerUpdate.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
private static final long serialVersionUID = 1L;
      
   /**
    * @see HttpServlet#HttpServlet()
    */
   public RetrieveServlet() {
       super();
       // TODO Auto-generated constructor stub
   }

/**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 */
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	// TODO Auto-generated method stub
	doPost(request, response);
}

/**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 */
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	// TODO Auto-generated method stub
	request.setCharacterEncoding("utf-8");
	
	response.setContentType("text/html;charset=utf-8");
	
	UserDao ud=new UserDao();
	//获取用户输入的检索
	String userName = request.getParameter("username");
	String userPhone = request.getParameter("user_tel");
	
	//操作数据库，返回结果
	try {
		List<User> list = ud.selectUser(userName,userPhone);
		System.out.println(list.size()+"个");
		//处理
		if(list==null || list.size()==0) {
			request.getRequestDispatcher("userAdmin.jsp").forward(request, response);
			
		}else {
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
				request.getRequestDispatcher("userAdmin.jsp").forward(request, response);
				
			}else {
				request.getSession().setAttribute("userResult", list);
				request.getRequestDispatcher("userAdmin.jsp").forward(request, response);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.getRequestDispatcher("userAdmin.jsp").forward(request,response);
		}
		
		
	}

}




@WebServlet("/ProviderRetrieveServlet")
public class ProviderRetrieveServlet extends HttpServlet  {
		private static final long serialVersionUID = 1L;
	       
	    /**
	     * @see HttpServlet#HttpServlet()
	     */
	    public ProviderRetrieveServlet() {
	        super();
	        // TODO Auto-generated constructor stub
	    }

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