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

		JPanel innPanel=new JPanel();
		innPanel.setBackground(new Color(187,242,24));
		innPanel.setLayout(new GridBagLayout());
		innPanel.setBorder(BorderFactory.createEtchedBorder());

		GridBagConstraints c=new GridBagConstraints();
		c.gridx=0;
		c.gridy=GridBagConstraints.RELATIVE;
		c.gridwidth=1;
		c.gridheight=1;
		c.insets=new Insets(5,5,5,5);
		c.anchor=GridBagConstraints.EAST;
		l0.setFont(f);
		innPanel.add(l0,c);
		l2.setFont(f);
		innPanel.add(l2,c);
		l3.setFont(f);
		innPanel.add(l3,c);
		l4.setFont(f);
		innPanel.add(l4,c);
		l5.setFont(f);
		innPanel.add(l5,c);
		innPanel.add(new JButton(intoAction),c);

		c.gridx=1;
		c.gridy=0;
		c.weightx=1.0;
		c.fill=GridBagConstraints.HORIZONTAL;
		c.anchor=GridBagConstraints.CENTER;
		cai_liao.addItemListener(new ItemListener(){
								public void itemStateChanged(ItemEvent evt)
								{
									if(cai_liao.getSelectedIndex()==0)
									{
										yuancailiao_chengping.setModel(model2);
										if(l2.isVisible()==false)
											l2.setVisible(true);
										if(yuancailiao_chengping.isVisible()==false)
											yuancailiao_chengping.setVisible(true);
										if(l5.isVisible()==false)
											l5.setVisible(true);
										if(tf5.isVisible()==false)
											tf5.setVisible(true);
									}
									if(cai_liao.getSelectedIndex()==1)
									{
										l2.setVisible(false);
										yuancailiao_chengping.setVisible(false);
										l5.setVisible(false);
										tf5.setVisible(false);
									}
									if(cai_liao.getSelectedIndex()==2)
									{
										yuancailiao_chengping.setModel(model3);
										if(l2.isVisible()==false)
											l2.setVisible(true);
										if(yuancailiao_chengping.isVisible()==false)
											yuancailiao_chengping.setVisible(true);
										l5.setVisible(false);
										tf5.setVisible(false);
									}
								}
		});
		cai_liao.setFont(f);
		innPanel.add(cai_liao,c);
		c.gridx=1;
		c.gridy=GridBagConstraints.RELATIVE;
		yuancailiao_chengping.setFont(f);
		innPanel.add(yuancailiao_chengping,c);
		innPanel.add(tf3,c);
		innPanel.add(tf4,c);
		innPanel.add(tf5,c);
		c.weightx=0.0;
		c.fill=GridBagConstraints.NONE;
		innPanel.add(new JButton(clearAction),c);

		add(innPanel,"Center");

		description0.setFont(f);
		add(description0,"South");

	}
	private 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,"数据库连接失败！"); 
			} 
	}
	private void closeDB()
	{
		try 
		{ 
			st.close(); 
			con.close(); 
		} 
		catch(SQLException e ) 
		{ 
			JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
		} 
	}
	private void closeDB1()
	{
		try 
		{ 
			st.close(); 
			pstmt.close();
			pstm.close();
			con.close(); 
		} 
		catch(SQLException e ) 
		{ 
			JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
		} 
	}
	
	private AbstractAction clearAction=new AbstractAction()
	{
		{
			putValue(NAME,"清空");
			putValue(SHORT_DESCRIPTION,"重新填写");
		}
		public void actionPerformed(ActionEvent evt)
		{
			tf3.setText("");
			tf4.setText("");
			tf5.setText("");
			cai_liao.requestFocus();//获得焦点
		}
	};
	private String getTime()
	{
		GregorianCalendar g=new GregorianCalendar();
		int Year=g.get(g.YEAR);
		int Month=g.get(g.MONTH);
		int DATE=g.get(g.DATE);
		int Hour=g.get(g.HOUR);
		int Minute=g.get(g.MINUTE);
		int Second=g.get(g.SECOND);
		int AP=g.get(g.AM_PM);
		if(AP==1)
			Hour=Hour+12;
		String time=Year+"年"+Month+"月"+DATE+"日"+Hour+":"+Minute+":"+Second;
		return time;
	}
	private boolean isInt(String s)
	{
		boolean suc=true;
		try
		{
			if(Integer.parseInt(s)>=0)
			{
				suc=false;
			}
		}
		catch(NumberFormatException e)
		{}
		return suc;
	}
	private boolean isFloat(String s)
	{
		boolean suc=true;
		try
		{
			if(Float.parseFloat(s)>=0)
			{
				suc=false;
			}
		}
		catch(NumberFormatException e)
		{}
		return suc;
	}
	private AbstractAction intoAction=new AbstractAction()
	{
		{
			putValue(NAME,"出库");
			putValue(SHORT_DESCRIPTION,"把材料出库");
		}
		public void actionPerformed(ActionEvent evt)
		{	
			String s1=(String)cai_liao.getSelectedItem();//材料的类别
			int id=cai_liao.getSelectedIndex()+4;//获得材料的类别编号
			String s2=(String)yuancailiao_chengping.getSelectedItem();//材料入库原因
			String s3=tf3.getText();//材料的名称
			String s4=tf4.getText();//材料的数目
			String s5=tf5.getText();//材料的单价
			boolean suc=false;//判断仓库中是否有出库的材料
			int total=0;//判断仓库中是否还有这种材料
			if(id==4)
			{
				if(s3.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库原材料的名称！");
					tf3.requestFocus();//获得焦点
				}
				else if(s4.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库原材料的数目！");
					tf4.requestFocus();//获得焦点
				}
				else if(isInt(s4))
				{
					JOptionPane.showMessageDialog(null,"请输入正确的整数！");
					tf4.setText("");
					tf4.requestFocus();
				}
				else if(s5.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入入库原材料的单价！");
				}
				else if(isFloat(s5))
				{
					JOptionPane.showMessageDialog(null,"请输入正确的浮点数！");
					tf5.setText("");
					tf5.requestFocus();
				}
				else
				{
					connDB();
					String query="select * from yuancailiao_total where device_name='"+s3+"';";
					try
					{
						rs=st.executeQuery(query);
						while (rs.next())
						{
							suc=true;
						}
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					if(suc==false)
					{
						JOptionPane.showMessageDialog(null,"仓库中不存在这种原材料");
						closeDB();
					}
					else
					{
						query="select total_number from yuancailiao_total where device_name='"+s3+"';";
						try
						{
							rs=st.executeQuery(query);