pandian.java

库存管理子系统帮助企业的仓库管理人员对库存物品的入库

package warehouse;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.border.*;
import javax.swing.table.*;
import java.util.*;
public class Pandian extends JPanel
{
	public Pandian()
	{
		this.setLayout(new BorderLayout());
		this.setBackground(new Color(187,242,24));
		
		pandian.setForeground(Color.red);
        pandian.setFont(new Font("Serif",Font.BOLD,40));
		add(pandian,"North");

		Border b=BorderFactory.createEtchedBorder();
		JPanel centerPanel=new JPanel();
		centerPanel.setBackground(new Color(187,242,24));
		centerPanel.setLayout(new BoxLayout(centerPanel,BoxLayout.X_AXIS));
		centerPanel.setBorder(BorderFactory.createTitledBorder(b,"材料分类盘点",TitledBorder.TOP,TitledBorder.CENTER));
		
		JPanel innPanel0=new JPanel();
		innPanel0.setBackground(new Color(187,242,24));
		innPanel0.setLayout(new BoxLayout(innPanel0,BoxLayout.Y_AXIS));
		innPanel0.setBorder(BorderFactory.createTitledBorder(b,"原材料盘点",TitledBorder.TOP,TitledBorder.CENTER));
		innPanel0.add(new JButton(yuancailiaoAction));
		yuancailiao_table=new JTable(model0)
		{
			public boolean isCellEditable(int rowIndex,int columnIndex)
			{
				return false;
			}
		};
		yuancailiao_table.setPreferredScrollableViewportSize(viewsize);
		JScrollPane yuancailiao_scroll=new JScrollPane(yuancailiao_table);
		innPanel0.add(yuancailiao_scroll);
		centerPanel.add(innPanel0);

		JPanel innPanel2=new JPanel();
		innPanel2.setBackground(new Color(187,242,24));
		innPanel2.setLayout(new BoxLayout(innPanel2,BoxLayout.Y_AXIS));
		innPanel2.setBorder(BorderFactory.createTitledBorder(b,"半成品盘点",TitledBorder.TOP,TitledBorder.CENTER));
		innPanel2.add(new JButton(banchengpingAction));
	    banchengping_table=new JTable(model2)//设置此表格为不可编辑状态
		{
			public boolean isCellEditable(int rowIndex,int columnIndex)
			{
				return false;
			}
		};
		banchengping_table.setPreferredScrollableViewportSize(viewsize);
		JScrollPane banchengping_scroll=new JScrollPane(banchengping_table);
		innPanel2.add(banchengping_scroll);
		centerPanel.add(innPanel2);

		JPanel innPanel3=new JPanel();
		innPanel3.setBackground(new Color(187,242,24));
		innPanel3.setLayout(new BoxLayout(innPanel3,BoxLayout.Y_AXIS));
		innPanel3.setBorder(BorderFactory.createTitledBorder(b,"成品盘点",TitledBorder.TOP,TitledBorder.CENTER));
		innPanel3.add(new JButton(chengpingAction));
		chengping_table=new JTable(model3)
		{
			public boolean isCellEditable(int rowIndex,int columnIndex)
			{
				return false;
			}
		};
		chengping_table.setPreferredScrollableViewportSize(viewsize);
		JScrollPane chengping_scroll=new JScrollPane(chengping_table);
		innPanel3.add(chengping_scroll);
		centerPanel.add(innPanel3);

		add(centerPanel,"Center");

		description0.setFont(f);
		add(description0,"South");
	}
	AbstractAction yuancailiaoAction=new AbstractAction()
	{
		{
			putValue(NAME,"原材料盘点");
			putValue(SHORT_DESCRIPTION,"统计仓库中原材料的数目");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("原材料名称");
			title.addElement("原材料数目");
			int id=1;
			yuancailiao_table.setModel(setData(model0,id,title));
		}
	};
	AbstractAction banchengpingAction=new AbstractAction()
	{
		{
			putValue(NAME,"半成品盘点");
			putValue(SHORT_DESCRIPTION,"统计仓库中半成品的数目");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("半成品名称");
			title.addElement("半成品数目");
			int id=2;
			banchengping_table.setModel(setData(model2,id,title));
		}
	};
	AbstractAction chengpingAction=new AbstractAction()
	{
		{
			putValue(NAME,"成品盘点");
			putValue(SHORT_DESCRIPTION,"统计仓库中成品的数目");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("成品名称");
			title.addElement("成名数目");
			int id=3;
			chengping_table.setModel(setData(model3,id,title));
		}
	};
	public void connDB()
	{
		try 
			{ 
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

			} 
			catch(ClassNotFoundException e) 
			{ 
				JOptionPane.showMessageDialog(null,"数据库加载失败！"); 
			} 
			try 
			{ 
				con = DriverManager.getConnection("jdbc:odbc:warehouse"); 
				st = con.createStatement(); 
			} 
			catch(SQLException e) 
			{ 
				JOptionPane.showMessageDialog(null,"数据库连接失败！"); 
			} 
	}
	public void closeDB1()
	{
		try 
			{ 
				st.close(); 
				con.close(); 
			} 
			catch(SQLException e ) 
			{ 
				JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
			} 
	}
	private DefaultTableModel setData(DefaultTableModel model,int id,Vector title)
	{
		if(id==1)
		{
			Vector v2=new Vector();
			connDB();
			String query="select device_name,total_number from yuancailiao_total;";
			try
			{
				rs=st.executeQuery(query);
				while(rs.next())
				{
					Vector v1=new Vector();
					v1.addElement(rs.getString(1));
					v1.addElement(rs.getString(2));
					v2.addElement(v1);
				}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
			model.setDataVector(v2,title);
		}
		else if(id==2)
		{
			
			Vector v2=new Vector();
			connDB();
			String query="select device_name,total_number from banchengping_total;";
			try
			{
				rs=st.executeQuery(query);
				while(rs.next())
				{
					Vector v1=new Vector();
					v1.addElement(rs.getString(1));
					v1.addElement(rs.getString(2));
					v2.addElement(v1);
				}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
			model.setDataVector(v2,title);
		}
		else if(id==3)
		{
			Vector v2=new Vector();
			connDB();
			String query="select device_name,total_number from chengping_total;";
			try
			{
				rs=st.executeQuery(query);
				while(rs.next())
				{
					Vector v1=new Vector();
					v1.addElement(rs.getString(1));
					v1.addElement(rs.getString(2));
					v2.addElement(v1);
				}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
			model.setDataVector(v2,title);
		}
		return model;
	}
	Font f=new Font("Monospaced", Font.PLAIN,12);
	private JLabel pandian=new JLabel("盘点作业",SwingConstants.CENTER);
	private JLabel description0=new JLabel("盘点作业：统计出数据库中和仓库中数量不一致的材料",SwingConstants.CENTER);
	JTable yuancailiao_table=null;
	JTable banchengping_table=null;
	JTable chengping_table=null;
	private Dimension viewsize=new Dimension(40,50);//表格所占的空间大小
	private DefaultTableModel model0=new DefaultTableModel();//空数据模型
	private DefaultTableModel model2=new DefaultTableModel();//空数据模型
	private DefaultTableModel model3=new DefaultTableModel();//空数据模型
	Connection con=null; 
	ResultSet rs=null; 
	Statement st=null; 
}