device_in.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_In extends JPanel//入库管理
{
	public Device_In()
	{
		this.setLayout(new BorderLayout());
		this.setBackground(new Color(187,242,24));
		
		devicein.setForeground(Color.red);
        devicein.setFont(new Font("Serif",Font.BOLD,40));
		add(devicein,"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);
		l6.setFont(f);
		innPanel.add(l6,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(l6.isVisible()==false)
											l6.setVisible(true);
										if(tf6.isVisible()==false)
											tf6.setVisible(true);
									}
									if(cai_liao.getSelectedIndex()==1)
									{
										l2.setVisible(false);
										yuancailiao_chengping.setVisible(false);
										l5.setVisible(false);
										tf5.setVisible(false);
										l6.setVisible(false);
										tf6.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);
										l6.setVisible(false);
										tf6.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);
		innPanel.add(tf6,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 
		{ 
			pstmt.close();
			pstm.close();
			st.close(); 
			con.close(); 
		} 
		catch(SQLException e ) 
		{ 
			JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
		} 
	}
	private void closeDB2()
	{
		try 
		{ 
			pstmt.close();
			pst.close();
			st.close(); 
			con.close(); 
		} 
		catch(SQLException e ) 
		{ 
			JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
		} 
	}

	AbstractAction clearAction=new AbstractAction()
	{
		{
			putValue(NAME,"清空");
			putValue(SHORT_DESCRIPTION,"重新填写");
		}
		public void actionPerformed(ActionEvent evt)
		{
			tf3.setText("");
			tf4.setText("");
			tf5.setText("");
			tf6.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;
	}
	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()+1;//获得材料的类别编号
			String s2=(String)yuancailiao_chengping.getSelectedItem();//材料入库原因
			String s3=tf3.getText();//材料的名称
			String s4=tf4.getText();//材料的数目
			String s5=tf5.getText();//材料的单价
			String s6=tf6.getText();//材料的供应商
			boolean suc=false;//用于判断材料是否已分配编码
			boolean succ=false;//用于判断device_total中是否已插入这种材料
			if(id==1)
			{
				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 if(s6.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入入库原材料的供应商！");
				}
				else
				{
					connDB();
					String query="select code from device_code where device_name='"+s3+"' and id='"+id+"';";
					try
					{
						rs=st.executeQuery(query);
						while(rs.next())
						{
							suc=true;
						}
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					if(suc==false)
					{
						JOptionPane.showMessageDialog(null,"还没有为这种原材料分配编号，请到“编码维护”中分配编码");
						closeDB();
					}
					else
					{
						String s=getTime();
						query="insert into log values(?,?,?,?,?,?,?,?);";
						try
						{
							pstmt=con.prepareStatement(query);
							pstmt.setString(1,s3);
							pstmt.setString(2,s);
							pstmt.setString(3,s1);
							pstmt.setString(4,s2);
							pstmt.setString(5,s4);