data.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 Data extends JPanel
{
	public Data()
	{
		this.setLayout(new BorderLayout());
		this.setBackground(new Color(187,242,24));
		data.setForeground(Color.red);
        data.setFont(new Font("Serif",Font.BOLD,40));
		add(data,"North");

		JPanel centerPanel=new JPanel();
		centerPanel.setLayout(new BorderLayout());
		centerPanel.setBackground(new Color(187,242,24));
		centerPanel.setBorder(BorderFactory.createEtchedBorder());
		
		data_table=new JTable(model)
		{
			public boolean isCellEditable(int rowIndex,int columnIndex)
			{
				return false;
			}
		};
		data_table.setPreferredScrollableViewportSize(viewsize);
		JScrollPane data_scroll=new JScrollPane(data_table);
		centerPanel.add(data_scroll,"Center");

		JPanel inn=new JPanel();
		inn.setBackground(new Color(187,242,24));
		inn.add(new JButton(caigouAction));		
		inn.add(new JButton(xiaoshouAction));		
		inn.add(new JButton(moneyAction));
		inn.add(new JButton(shengchangAction));
		centerPanel.add(inn,"South");

		add(centerPanel,"Center");

		description0.setFont(f);
		add(description0,"South");
	}
	AbstractAction caigouAction=new AbstractAction()
	{
		{
			putValue(NAME,"采购数据表");
			putValue(SHORT_DESCRIPTION,"为采购部门提供需采购的原材料数量");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("原材料名称");
			title.addElement("原材料数量");
			int id=1;
			data_table.setModel(setData(model,id,title));
		}
	};
	AbstractAction xiaoshouAction=new AbstractAction()
	{
		{
			putValue(NAME,"销售数据表");
			putValue(SHORT_DESCRIPTION,"为销售部门提供需销售的成品数量");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("成品名称");
			title.addElement("成品数量");
			int id=2;
			data_table.setModel(setData(model,id,title));
		}
	};
	AbstractAction moneyAction=new AbstractAction()
	{
		{
			putValue(NAME,"应付帐款数据表");
			putValue(SHORT_DESCRIPTION,"为财务部门提供需付款的原材料资金数量");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("原材料名称");
			title.addElement("原材料资金");
			int id=3;
			data_table.setModel(setData(model,id,title));
		}
	};
	AbstractAction shengchangAction=new AbstractAction()
	{
		{
			putValue(NAME,"生产数据表");
			putValue(SHORT_DESCRIPTION,"为生产部门提供需生产的原材料数量");
		}
		public void actionPerformed(ActionEvent e)
		{
			Vector title=new Vector();
			title.addElement("原材料名称");
			title.addElement("原材料数量");
			int id=1;
			data_table.setModel(setData(model,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(String.valueOf(rs.getInt(2)));
					v2.addElement(v1);
				}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
			model.setDataVector(v2,title);
		}
		if(id==2)
		{
			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(String.valueOf(rs.getInt(2)));
					v2.addElement(v1);
					}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
			model.setDataVector(v2,title);
		}
		if(id==3)
		{
			Vector v2=new Vector();
			connDB();
			String query="select device_name,total_money from yuancailiao_total;";
			try
			{
				rs=st.executeQuery(query);
				while(rs.next())
				{
					Vector v1=new Vector();
					v1.addElement(rs.getString(1));
					v1.addElement(String.valueOf(rs.getFloat(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 data=new JLabel("部门数据接口",SwingConstants.CENTER);
	JTable data_table=null;
	private Dimension viewsize=new Dimension(120,50);//表格所占的空间大小
	private DefaultTableModel model=new DefaultTableModel();//空数据模型
	private JLabel description0=new JLabel("部门数据接口：为其它部门提供各种数据",SwingConstants.CENTER);

	Connection con=null; 
	ResultSet rs=null; 
	Statement st=null;
}