商品销售管理系统

用JSP servlet和jquery以及SQLServer数据库实现商品销售管理系统。

功能详解：
1.查询商品
2.添加商品
3.删除商品
4.添加销售记录
5.查看销售记录

效果演示：

进入界面

商品显示页面

删除提示

销售记录查询

商品销售系统需要SQLServer数据库和程序两大部分

一：设计并实现数据库

二：程序设计

在程序正式开始之前先看一下目录结构吧

==特别注意：==引入sqljdbc4.jar和jquery-3.3.1.js架包

程序演示

bean包

Product.java

package com.hnpi.bean;

public class Product {
   
	private int ProductID;
	private String ProductName;
	private String IsUp;
	private int UnitPrice;
	private String Remark;
	public int getProductID() {
   
		return ProductID;
	}
	public void setProductID(int productID) {
   
		ProductID = productID;
	}
	public String getProductName() {
   
		return ProductName;
	}
	public void setProductName(String productName) {
   
		ProductName = productName;
	}
	public String getIsUp() {
   
		return IsUp;
	}
	public void setIsUp(String isUp) {
   
		IsUp = isUp;
	}
	public int getUnitPrice() {
   
		return UnitPrice;
	}
	public void setUnitPrice(int unitPrice) {
   
		UnitPrice = unitPrice;
	}
	public String getRemark() {
   
		return Remark;
	}
	public void setRemark(String remark) {
   
		Remark = remark;
	}
	public Product() {
   
		super();
		// TODO Auto-generated constructor stub
	}
	public Product(int productID, String productName, String isUp,
			int unitPrice, String remark) {
   
		super();
		ProductID = productID;
		ProductName = productName;
		IsUp = isUp;
		UnitPrice = unitPrice;
		Remark = remark;
	}
	
	
	
	

}

Sale.java

package com.hnpi.bean;

import java.util.Date;

public class Sale {
   
	private int SaleID;
	private String SalePerson;
	private int Amount;
	private Date SaleDate;
	private int ProductID;
	public int getSaleID() {
   
		return SaleID;
	}
	public void setSaleID(int saleID) {
   
		SaleID = saleID;
	}
	public String getSalePerson() {
   
		return SalePerson;
	}
	public void setSalePerson(String salePerson) {
   
		SalePerson = salePerson;
	}
	public int getAmount() {
   
		return Amount;
	}
	public void setAmount(int amount) {
   
		Amount = amount;
	}
	public Date getSaleDate() {
   
		return SaleDate;
	}
	public void setSaleDate(Date saleDate) {
   
		SaleDate = saleDate;
	}
	public int getProductID() {
   
		return ProductID;
	}
	public void setProductID(int productID) {
   
		ProductID = productID;
	}
	public Sale() {
   
		super();
		// TODO Auto-generated constructor stub
	}
	public Sale(int saleID, String salePerson, int amount, Date saleDate,
			int productID) {
   
		super();
		SaleID = saleID;
		SalePerson = salePerson;
		Amount = amount;
		SaleDate = saleDate;
		ProductID = productID;
	}
	
	
	
	

}

servlet包

AddServlet.java

package com.hnpi.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.hnpi.bean.Product;
import com.hnpi.util.DBUtil;

public class AddServlet extends HttpServlet {
   


	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   

		doPost(request, response);
	}


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		
		String ProductName = request.getParameter("ProductName");
		String IsUp = request.getParameter("IsUp");
		String UnitPrice = request.getParameter("UnitPrice");
		String Remark = request.getParameter("Remark");
		
		Connection conn = DBUtil.getConn();
		PreparedStatement ps = null;
		String sql = "insert into Product(ProductName, IsUp, UnitPrice, Remark) values(?,?,?,?)";
		
		try {
   
			ps = conn.prepareStatement(sql);
			ps.setString(1, ProductName);
			ps.setString(2, IsUp);
			ps.setInt(3, Integer.parseInt(UnitPrice));
			ps.setString(4, Remark);
			ps.executeUpdate();

			
		} catch (SQLException e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();