cukuchuli.java

基于Java的仓库信息管理系统。本系统主要完成对超市仓库的库存管理

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
import java.io.*;


public class CukuChuli extends JFrame implements ActionListener
{
	JLabel lb1,lb2,lb3,lb4,lb5,lb6,lbda,lb7;//lbda用来做头
	JButton b1,b2;
	JTextField jt1,jt2,jt3,jt4,jt5,jt6;
	 JPanel p[]=new JPanel[8];
	 JPanel p1=new JPanel();
	 JComboBox cbb=new JComboBox();

	 int i;
	 int j=0;
	public CukuChuli()
	{
		super("出货表");
		lb1=new JLabel("商品名称:");
		lb2=new JLabel("商品单价:");
		lb3=new JLabel("出货数量:");
		cbb.addItem("");
		try
		{
		  String url="jdbc:odbc:Test";
	      Connection con=DriverManager.getConnection(url);
		  Statement  s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		  ResultSet r=s.executeQuery("select * from chuhuodanwei");
		  r.first();
		  do{
		  	cbb.addItem(r.getString(2));
		  }while(r.next());
		  r.close();
		  s.close();
		}
		catch(Exception e)
		{
		}
		cbb.setSelectedIndex(0);
		lb4=new JLabel("接手人   :");
	    lb5=new JLabel("出货时间");
	    lb6=new JLabel("出货金额:");
	    lbda=new JLabel("    出     货     表");
	    jt1=new JTextField(20);
	    jt2=new JTextField(20);
	    jt3=new JTextField(20);
	    jt4=new JTextField(20);
	    jt5=new JTextField(20);
	    jt6=new JTextField(20);
	    jt6.setEditable(false);
	    Statement s;
	    ResultSet rs;
	    
	    b1=new JButton("确定");
	    b2=new JButton("取消");
	    
	    lb7=new JLabel("购货单位:");
	    p1=new JPanel();
	    p1.setBackground(new Color(190,190,190));
	    Container con=getContentPane();
	    con.setLayout(new GridLayout(9,1));
	    for(int i=0;i<=7;i++)
	    {
	    	p[i]=new JPanel();
	    	p[i].setBackground(new Color(190,190,190));
	    }
	    p[0].add(lbda);
	    
	    p[1].add(lb1);
	    p[1].add(jt1);
	    p[2].add(lb2);
	    p[2].add(jt2);
	    p[3].add(lb3);
	    p[3].add(jt3);
	    p[4].add(lb4);
	    p[4].add(jt4);
	    p1.add(lb7);
	    p1.add(cbb);
	    p[5].add(lb5);
	    p[5].add(jt5);
	    p[6].add(lb6);
	    p[6].add(jt6);
	    
	    p[7].add(b1);
	    p[7].add(b2);
	    
	   
	   
	    
	    b1.addActionListener(this);
	    b2.addActionListener(this);
	    
	    
	    
	    con.add(p[0]);
		con.add(p[1]);
	    con.add(p[2]);
	   	con.add(p[3]);
	    
	   	con.add(p[4]);
	   	con.add(p1);
	   	con.add(p[5]);
	   	con.add(p[6]);
	   	con.add(p[7]);
	    super.setVisible(true);
	    super.setSize(350,500);
	    super.setResizable(false);
	    
	    
	    
	}
	public void actionPerformed(ActionEvent e)
	{
		try
		{
			if(e.getSource()==b2)
			{
				jt1.setText("");
				jt2.setText("");
				jt3.setText("");
				jt4.setText("");
				jt5.setText("");
				jt6.setText("");
				cbb.setSelectedIndex(0);

			}
			else if(e.getSource()==b1)
			{
				if(jt1.getText().equals("")||jt2.getText().equals("")||jt3.getText().equals("")||jt4.getText().equals("")||jt5.getText().equals(""))
			    {
			    	JOptionPane.showMessageDialog(null,"信息必须全部填满","提示",JOptionPane.WARNING_MESSAGE);
			    	
			    }
			    else
			    {
			    	String x1=null;
			    	String x2=null;
			    	String x3=null;
			     x1=JOptionPane.showInputDialog(null,"请输入商品名称:");
			     x2=JOptionPane.showInputDialog(null,"请输入商品单价:");
			     x3=JOptionPane.showInputDialog(null,"请输入商品数量:");
			     
			     if(x1.equals(jt1.getText())&&x2.equals(jt2.getText())&&x3.equals(jt3.getText()))
			     {
			     	
			     
			    	Float i1,i2;
			    	i1=Float.parseFloat(jt2.getText());
			    	i2=Float.parseFloat(jt3.getText());
			    	Float i3=i1*i2;
			    	jt6.setText(""+i3);
			    	
	      String url="jdbc:odbc:Test";
	      Connection con=DriverManager.getConnection(url);
		  Statement  s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	//	  String  sql1="insert into out1 "
	//	    +"values('"+jt1.getText()+"','"+jt2.getText()+"','"+jt3.getText()+"','"+jt6.getText()+"','"+jt4.getText()+"','"+jt5.getText()+"')";
	//	   s.executeUpdate(sql1);
		 //      System.out.print(1);
		 //  	float m;
		  // 	m=Float.parseFloat(jt3.getText());
		 //  	   System.out.print(m);
		   //     String  sql2="insert into tj "
		  //  +"values('"+jt1.getText()+"',1,'"+jt3.getText()+"',0,0,'"+jt3.getText()+"')";
		  //     s.executeUpdate(sql2);
		   //    System.out.print(21);	
	//	   JOptionPane.showMessageDialog(null,"商品成功入库，可以记录","提示",JOptionPane.INFORMATION_MESSAGE);
		   
		   
		   
		   ///////////////////////////接下来是统计功能模块
		   ///////////首先查找这个货物有没有
		   ResultSet rs=s.executeQuery("select * from tj");
		   rs.first();
		   do{
		   	/////查找
		   	
		   	if(rs.getString(2).equals(jt1.getText()))
		   	{
		   		i=1;
		   		break;
		   	}
		   }while(rs.next());
		   
		   if(i==1)//只有在这个里面才能处理
		   {
		   	String s1,s2,s3,s4,s5;
		   	float m1,m2,m3,m4,m5;
		   	s1=rs.getString(5);
		   	m1=Float.parseFloat(s1);
		   	m1++;
		   	s3=jt3.getText();
		   	m3=Float.parseFloat(s3);
		   	s2=rs.getString(6);
		   	m2=Float.parseFloat(s2);
		   	m2=m2+m3;
		   	s4=rs.getString(7);
		   	m4=Float.parseFloat(s4);
		   	m4=m4-m3;
		   	if(m4<0)
		   	{
		   		JOptionPane.showMessageDialog(null,"没有这么多存货,不能出货","提示",JOptionPane.ERROR_MESSAGE);
		       	jt1.setText("");
				jt2.setText("");
				jt3.setText("");
				jt4.setText("");
				jt5.setText("");
				jt6.setText("");
				cbb.setSelectedIndex(0);
		   	}
		   	else
		   	{
		   	
		   	s5=rs.getString(8);
		   	m5=Float.parseFloat(s5);
		   	m5=m5+Float.parseFloat(jt6.getText());
		   	String cbbS=cbb.getSelectedItem().toString();
		   	String sql2="update tj set chusl ='"+m1+"',chuhuo='"+m2+"',zlsum='"+m4+"',yl='"+m5+"' where spmc ='"+jt1.getText()+"' ";
		   	s.executeUpdate(sql2);
		   	///////////////////////////////////////////////////上面是统计表
		   	JOptionPane.showMessageDialog(null,"商品数量成功已经更新","提示",JOptionPane.INFORMATION_MESSAGE);
		   		  String  sql1="insert into out1 "
		    +"values('"+jt1.getText()+"','"+jt2.getText()+"','"+jt3.getText()+"','"+jt6.getText()+"','"+jt4.getText()+"','"+jt5.getText()+"','"+cbbS+"')";
		   s.executeUpdate(sql1);
		    JOptionPane.showMessageDialog(null,"商品成功出库，可以记录","提示",JOptionPane.INFORMATION_MESSAGE);
		   //////////////////////////////////////////////////////上面是出库表
		   float mm;
		   mm=Float.parseFloat(jt6.getText());//把一共收入的钱取出来了
		   ResultSet  re=s.executeQuery("select * from zhangben");
		   re.first();
		   do{
		   	if(re.getString(2).equals(jt1.getText()))
		   	{
		   		float mmm=Float.parseFloat(re.getString(4));
		   		float mmmm=Float.parseFloat(re.getString(5));
		   		
		   		mmm=mmm+mm;//处理了出货数据
		   		mmmm=mmmm+mm;//盈利
		   	 String sql21="update zhangben set mcjg ='"+mmm+"',yl='"+mmmm+"' where spmc ='"+jt1.getText()+"' ";
		  	s.executeUpdate(sql21);
		  	JOptionPane.showMessageDialog(null,"账本处理成功","提示",JOptionPane.INFORMATION_MESSAGE);
		  		jt1.setText("");
				jt2.setText("");
				jt3.setText("");
				jt4.setText("");
				jt5.setText("");
				jt6.setText("");
				cbb.setSelectedIndex(0);
		   	}
		   }while(re.next());
		   
		   
		 //  String sql21="update zhangben set mcjg ='"+m1+"',chuhuo='"+m2+"',zlsum='"+m4+"',yl='"+m5+"' where spmc ='"+jt1.getText()+"' ";
		 //  	s.executeUpdate(sql21);
		   	
		   }
		   }
		   else if(i==0)
		   {
		  
		     JOptionPane.showMessageDialog(null,"原本没有该商品，不能出货","提示",JOptionPane.WARNING_MESSAGE);
		   		jt1.setText("");
				jt2.setText("");
				jt3.setText("");
				jt4.setText("");
				jt5.setText("");
				jt6.setText("");
				cbb.setSelectedIndex(0);
		   }

		 }
		 else{
		 	JOptionPane.showMessageDialog(null,"两次输入的不一样，所以不能出库");
		     	jt1.setText("");
				jt2.setText("");
				jt3.setText("");
				jt4.setText("");
				jt5.setText("");
				jt6.setText("");
				cbb.setSelectedIndex(0);
		 }
		 }//else 
		
			}//b1
		    
			
		}///try
		catch(Exception we)
		{

		}
	}
	public static void main(String args[])
	{
		new CukuChuli();
	} 
	
}