基于SSM企业仓库库存管理系统商品分类出库入库进货退货销售供应商客户员工统计盘存损耗报警(idea-javaweb-javaee-j2ee-springboot)

 

1 概述

 

2 数据库表

 

表4 ruku 入库信息表

名称	类型	说明
id	int	编号
danjuhao	varchar(50)	单据号
shijian	datetime	时间
zongjiage	int	价格
jingshouren	varchar(50)	经手人
beizhu	varchar(50)	备注

 

表5 catelog 分类表

名称	类型	说明
id	int	编号
name	varchar(50)	名称
jieshao	varchar(5000)	介绍

3 关键代码

 

package com.action;

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

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tgoods;
import com.orm.Tchuku;
import com.orm.TchukuMingxi;
import com.orm.Yuangong;
import com.service.liuService;

public class chuku_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");
		
		if(type.endsWith("chukuAdd"))
		{
			chukuAdd(req, res);
		}
		if(type.endsWith("chukuEdit"))
		{
			chukuEdit(req, res);
		}
		if(type.endsWith("chukuMana"))
		{
			chukuMana(req, res);
		}
		if(type.endsWith("chukuDel"))
		{
			chukuDel(req, res);
		}
		
		if(type.endsWith("chukuMingxiAdd"))
		{
			chukuMingxiAdd(req, res);
		}
		if(type.endsWith("chukuMingxiMana"))
		{
			chukuMingxiMana(req, res);
		}
		if(type.endsWith("chukuMingxiDel"))
		{
			chukuMingxiDel(req, res);
		}
	}
	
	
	
	
	public void chukuAdd(HttpServletRequest req,HttpServletResponse res)
	{
		String danjuhao=req.getParameter("danjuhao");
		String shijian=req.getParameter("shijian");
		int zongjiage=Integer.parseInt(req.getParameter("zongjiage"));
		String jingshouren=req.getParameter("jingshouren");
		String beizhu=req.getParameter("beizhu");
		String del="no";
		
		String sql="insert into t_chuku  (`danjuhao`, `shijian`, `zongjiage`, `jingshouren`, `beizhu`, `del`)  values(?,?,?,?,?,?)";
		Object[] params={danjuhao,shijian,zongjiage,jingshouren,beizhu,del};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chuku?type=chukuMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void chukuEdit(HttpServletRequest req,HttpServletResponse res)
	{
		String danjuhao=req.getParameter("danjuhao");
		String shijian=req.getParameter("shijian");
		int zongjiage=Integer.parseInt(req.getParameter("zongjiage"));
		String jingshouren=req.getParameter("jingshouren");
		String beizhu=req.getParameter("beizhu");
		String del="no";
		
		String sql="update t_chuku set danjuhao='"+danjuhao+"',shijian='"+shijian+"',zongjiage='"+zongjiage+"',jingshouren='"+jingshouren+"',beizhu='"+beizhu+"' where id="+Integer.parseInt(req.getParameter("id"));
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chuku?type=chukuMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void chukuDel(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="update t_chuku set del='yes' where id=?";
		Object[] params={id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chuku?type=chukuMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void chukuMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_chuku where del='no'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List chukuList=new ArrayList();
		String sql="select * from t_chuku where del='no'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				Tchuku chuku=new Tchuku();
				chuku.setId(rs.getInt("id"));
				chuku.setDanjuhao(rs.getString("danjuhao"));
				chuku.setShijian(rs.getDate("shijian"));
				chuku.setZongjiage(rs.getInt("zongjiage"));
				chuku.setJingshouren(rs.getString("jingshouren"));
				chuku.setBeizhu(rs.getString("beizhu"));
				chukuList.add(chuku);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("chukuList", chukuList);
		req.getRequestDispatcher("admin/chuku/chukuMana.jsp").forward(req, res);
	}
	
	
	
	public void chukuMingxiAdd(HttpServletRequest req,HttpServletResponse res)
	{
		
		int chuku_id=Integer.parseInt(req.getParameter("chuku_id"));
		int goods_id=Integer.parseInt(req.getParameter("goods_id"));
		int shuliang=Integer.parseInt(req.getParameter("shuliang"));
		String beizhu=req.getParameter("beizhu");
		
		String sql="insert into t_chukuMingxi  (`chuku_id`, `goods_id`, `shuliang`, `beizhu`)  values(?,?,?,?)";
		Object[] params={chuku_id,goods_id,shuliang,beizhu};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("msg", "操作成功");
        String targetURL = "/common/msg.jsp";
		dispatch(targetURL, req, res);
	}
	
	
	public void chukuMingxiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		int chuku_id=Integer.parseInt(req.getParameter("chuku_id"));
		
		List chukuMingxiList=new ArrayList();
		String sql="select * from t_chukuMingxi where chuku_id="+chuku_id;
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				TchukuMingxi chukuMingxi=new TchukuMingxi();
				
				chukuMingxi.setId(rs.getInt("id"));
				chukuMingxi.setChuku_id(rs.getInt("chuku_id"));
				chukuMingxi.setGoods_id(rs.getInt("goods_id"));
				chukuMingxi.setShuliang(rs.getInt("shuliang"));
				chukuMingxi.setBeizhu(rs.getString("beizhu"));
				chukuMingxi.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
				
				chukuMingxiList.add(chukuMingxi);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		System.out.println(chukuMingxiList.size());
		req.setAttribute("chukuMingxiList", chukuMingxiList);
		req.setAttribute("chuku_id", chuku_id);
		req.getRequestDispatcher("admin/chuku/chukuMingxiMana.jsp").forward(req, res);
	}
	
	public void chukuMingxiDel(HttpServletRequest req,HttpServletResponse res)
	{
		
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="delete from t_chukuMingxi where id="+id;
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("msg", "操作成功");
        String targetURL = "/common/msg.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}

4 效果演示

 

idea或eclipse开发,mysql数据库