code_manager.java

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

package warehouse;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.border.*;

public class  Code_Manager extends JPanel
{
	public Code_Manager()
	{
		this.setLayout(new BorderLayout());
		this.setBackground(new Color(187,242,24));
		//this.setBorder(new MatteBorder(new ImageIcon(getClass().getResource("image/5.gif"))));
		
		code.setForeground(Color.red);
        code.setFont(new Font("Serif",Font.BOLD,40));
		add(code,"North");
		
		JPanel centerPanel=new JPanel();
		centerPanel.setBackground(new Color(187,242,24));
		centerPanel.setLayout(new BorderLayout());
		Border b=BorderFactory.createEtchedBorder();
        centerPanel.setBorder(BorderFactory.createTitledBorder(b,"材料分类编码",TitledBorder.TOP,TitledBorder.CENTER));

		JPanel innerPanel=new JPanel();
		innerPanel.setLayout(new BoxLayout(innerPanel,BoxLayout.X_AXIS));
		innerPanel.setBackground(new Color(187,242,24));

		JPanel yuancailiaoPanel=new JPanel();
		yuancailiaoPanel.setBorder(BorderFactory.createTitledBorder(b,"原材料编码",TitledBorder.TOP,TitledBorder.CENTER));
		yuancailiaoPanel.setBackground(new Color(187,242,24));
		yuancailiaoPanel.setLayout(new BoxLayout(yuancailiaoPanel,BoxLayout.Y_AXIS));
		
		JPanel pp1=new JPanel();
		pp1.setBackground(new Color(187,242,24));
		l1.setFont(f);
		pp1.add(l1);
		pp1.add(tf1);
		yuancailiaoPanel.add(Box.createGlue());
		yuancailiaoPanel.add(pp1);
		JPanel pp2=new JPanel();
		pp2.setBackground(new Color(187,242,24));
		pp2.add(new JButton(code1Action));
		pp2.add(jl1);
		yuancailiaoPanel.add(pp2);
		yuancailiaoPanel.add(Box.createGlue());

		worning.setFont(f);
		yuancailiaoPanel.add(worning);
		yuancailiaoPanel.add(Box.createGlue());

		JPanel pp13=new JPanel();
		pp13.setBackground(new Color(187,242,24));
		min_text.setFont(f);
		pp13.add(min_text);
		pp13.add(min_number);
		yuancailiaoPanel.add(pp13);
		yuancailiaoPanel.add(Box.createGlue());

		JPanel pp14=new JPanel();
		pp14.setBackground(new Color(187,242,24));
		max_text.setFont(f);
		pp14.add(max_text);
		pp14.add(max_number);
		yuancailiaoPanel.add(pp14);
		yuancailiaoPanel.add(Box.createGlue());

		yuancailiaoPanel.add(new JButton(worningAction));
		

		innerPanel.add(Box.createGlue());
		innerPanel.add(yuancailiaoPanel);

		JPanel banchengpingPanel=new JPanel();
		banchengpingPanel.setBorder(BorderFactory.createTitledBorder(b,"半成品编码",TitledBorder.TOP,TitledBorder.CENTER));
		banchengpingPanel.setBackground(new Color(187,242,24));
		banchengpingPanel.setLayout(new BoxLayout(banchengpingPanel,BoxLayout.Y_AXIS));
				
		JPanel pp3=new JPanel();
		pp3.setBackground(new Color(187,242,24));
		l2.setFont(f);
		pp3.add(l2);
		pp3.add(tf2);
		banchengpingPanel.add(Box.createGlue());
		banchengpingPanel.add(pp3);
		JPanel pp4=new JPanel();
		pp4.setBackground(new Color(187,242,24));
		pp4.add(new JButton(code2Action));
		pp4.add(jl2);
		banchengpingPanel.add(pp4);
		banchengpingPanel.add(Box.createGlue());

		innerPanel.add(Box.createGlue());
		innerPanel.add(banchengpingPanel);

		JPanel chengpingPanel=new JPanel();
		chengpingPanel.setBackground(new Color(187,242,24));
		chengpingPanel.setBorder(BorderFactory.createTitledBorder(b,"成品编码",TitledBorder.TOP,TitledBorder.CENTER));
		chengpingPanel.setLayout(new BoxLayout(chengpingPanel,BoxLayout.Y_AXIS));
				
		JPanel pp5=new JPanel();
		pp5.setBackground(new Color(187,242,24));
		l3.setFont(f);
		pp5.add(l3);
		pp5.add(tf3);
		chengpingPanel.add(Box.createGlue());
		chengpingPanel.add(pp5);
		JPanel pp6=new JPanel();
		pp6.setBackground(new Color(187,242,24));
		pp6.add(new JButton(code3Action));
		pp6.add(jl3);
		chengpingPanel.add(pp6);
		chengpingPanel.add(Box.createGlue());
		
		innerPanel.add(Box.createGlue());
		innerPanel.add(chengpingPanel);
		innerPanel.add(Box.createGlue());

		centerPanel.add(innerPanel,"Center");

		JPanel searchPanel=new JPanel();
		searchPanel.setBackground(new Color(187,242,24));
		searchPanel.setBorder(BorderFactory.createTitledBorder(b,"编码查询",TitledBorder.TOP,TitledBorder.CENTER));
		searchPanel.setLayout(new BoxLayout(searchPanel,BoxLayout.X_AXIS));
		JPanel pp7=new JPanel();
		pp7.setBackground(new Color(187,242,24));
		search_label.setFont(f);
		pp7.add(search_label);
		pp7.add(search_text);
		searchPanel.add(Box.createGlue());
		searchPanel.add(pp7);
		JPanel pp8=new JPanel();
		pp8.setBackground(new Color(187,242,24));
		pp8.add(new JButton(searchAction));
		pp8.add(search_result);
		searchPanel.add(pp8);
		searchPanel.add(Box.createGlue());

		centerPanel.add(searchPanel,"South");
		
		add(centerPanel,"Center");

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

	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,"数据库关闭失败！"); 
			} 
	}

	public void closeDB2()
	{
		try 
			{ 
				st.close(); 
				pstmt.close();
				con.close(); 
			} 
			catch(SQLException e ) 
			{ 
				JOptionPane.showMessageDialog(null,"数据库关闭失败！"); 
			} 
	}
	AbstractAction worningAction=new AbstractAction()
	{
		{
			putValue(NAME,"确定");
			putValue(SHORT_DESCRIPTION,"确定安全范围");
		}
		public void actionPerformed(ActionEvent evt)
		{
			String yuancailiaoName=tf1.getText();
			String min=min_number.getText();
			String max=max_number.getText();
			boolean suc=false;
			if(yuancailiaoName.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入原材料的名称！");
			}
			else if(min.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入最小值！");
			}
			else if(max.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入最大值！");
			}
			else if(Integer.parseInt(max)<=Integer.parseInt(min))
			{
				JOptionPane.showMessageDialog(null,"最大值不能小于等于最小值！");
			}
			else
			{
				connDB();
				String query="select * from yuancailiao_worning where device_name='"+yuancailiaoName+"';";
				try
				{
					rs=st.executeQuery(query);
					while (rs.next())
					{
						suc=true;
					}
				}
				catch(SQLException e)
				{
					JOptionPane.showMessageDialog(null,"数据库操作失败！");
				}
				if(suc==true)
				{
					JOptionPane.showMessageDialog(null,"已经为这种原材料确定安全范围了！");
					closeDB1();
				}
				else
				{
					query="insert into yuancailiao_worning values(?,?,?);";
					try
					{
						pstmt=con.prepareStatement(query);
						pstmt.setString(1,yuancailiaoName);
						pstmt.setInt(2,Integer.parseInt(min));
						pstmt.setInt(3,Integer.parseInt(max));
						pstmt.execute();
						JOptionPane.showMessageDialog(null,"已经成功确定安全范围！");
					}
					catch(NumberFormatException e)
					{
						JOptionPane.showMessageDialog(null,"最大，最小值不能输入数字以外的字符！请重新输入");
						min_number.setText("");
						max_number.setText("");
						min_number.requestFocus();
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					
					closeDB2();
				}
			}
		}
	};

	AbstractAction code1Action=new AbstractAction()
	{
		{
			putValue(NAME,"生成编码");//按钮的文本
			putValue(SHORT_DESCRIPTION,"生成原材料的唯一编码");
		}
		public void actionPerformed(ActionEvent evt)
		{
			String yuancailiaoName=tf1.getText();