code_manager.java

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

			int max_yuancailiao=0;
			boolean exit=false;

			if(yuancailiaoName.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入原材料的名称！");
			}
			else
			{
				connDB();
				String query="select * from device_code where device_name='"+yuancailiaoName+"';";
				try
				{
					rss=st.executeQuery(query);
					while(rss.next())
					{
						exit=true;
					}
				}
				catch(SQLException e)
				{
					JOptionPane.showMessageDialog(null,"数据库操作失败！");
				}
				if(exit==true)
				{
					JOptionPane.showMessageDialog(null,"已经为这种原材料分配编码了！");
					closeDB1();
				}
				else
				{
					query="select max(code) from device_code where code between 1000 and 1999;";
					try
					{
						rs=st.executeQuery(query);
						while(rs.next())
						{
							max_yuancailiao=rs.getInt(1)+1;
						}
						jl1.setText(String.valueOf(max_yuancailiao));
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					try
					{
						query="insert into device_code values(?,?,?);";
						pstmt=con.prepareStatement(query);
						pstmt.setInt(1,max_yuancailiao);
						pstmt.setString(2,yuancailiaoName);
						pstmt.setInt(3,1);
						pstmt.execute();
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					closeDB2();
				}
			}
		}
	};
	AbstractAction code2Action=new AbstractAction()
	{
		{
			putValue(NAME,"生成编码");//按钮的文本
			putValue(SHORT_DESCRIPTION,"生成半成品的唯一编码");
		}
		
		public void actionPerformed(ActionEvent evt)
		{
			String banchengpingName=tf2.getText();
			int max_banchengping=0;
			boolean exit=false;

			if(banchengpingName.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入半成品的名称！");
			}
			else
			{
				connDB();
				String query="select * from device_code where device_name='"+banchengpingName+"';";
				try
				{
					rss=st.executeQuery(query);
					while(rss.next())
					{
						exit=true;
					}
				}
				catch(SQLException e)
				{
					JOptionPane.showMessageDialog(null,"数据库操作失败！");
				}
				if(exit==true)
				{
					JOptionPane.showMessageDialog(null,"已经为这种半成品分配编码了！");
					closeDB1();
				}
				else
				{

					query="select max(code) from device_code where code between 2000 and 2999;";
					try
					{
						rs=st.executeQuery(query);
						while(rs.next())
						{
							max_banchengping=rs.getInt(1)+1;
						}
						jl2.setText(String.valueOf(max_banchengping));
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					try
					{
						query="insert into device_code values(?,?,?);";
						pstmt=con.prepareStatement(query);
						pstmt.setInt(1,max_banchengping);
						pstmt.setString(2,banchengpingName);
						pstmt.setInt(3,2);
						pstmt.execute();
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					closeDB2();
				}
			}
		}
	};
	AbstractAction code3Action=new AbstractAction()
	{
		{
			putValue(NAME,"生成编码");//按钮的文本
			putValue(SHORT_DESCRIPTION,"生成成品的唯一编码");
		}
		public void actionPerformed(ActionEvent evt)
		{
			String chengpingName=tf3.getText();
			int max_chengping=0;
			boolean exit=false;

			if(chengpingName.length()==0)
			{
				JOptionPane.showMessageDialog(null,"请输入成品的名称！");
			}
			else
			{
				connDB();
				String query="select * from device_code where device_name='"+chengpingName+"';";
				try
				{
					rss=st.executeQuery(query);
					while(rss.next())
					{
						exit=true;
					}
				}
				catch(SQLException e)
				{
					JOptionPane.showMessageDialog(null,"数据库操作失败！");
				}
				if(exit==true)
				{
					JOptionPane.showMessageDialog(null,"已经为这种成品分配编码了！");
					closeDB1();
				}
				else
				{
					query="select max(code) from device_code where code between 3000 and 3999;";
					try
					{
						rs=st.executeQuery(query);
						while(rs.next())
						{
							max_chengping=rs.getInt(1)+1;
						}
						jl3.setText(String.valueOf(max_chengping));
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					try
					{
						query="insert into device_code values(?,?,?);";
						pstmt=con.prepareStatement(query);
						pstmt.setInt(1,max_chengping);
						pstmt.setString(2,chengpingName);
						pstmt.setInt(3,3);
						pstmt.execute();
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					closeDB2();
				}
			}
		}
	};
	AbstractAction searchAction=new AbstractAction()
	{
		{
			putValue(NAME,"查询编码");//按钮的文本
			putValue(SHORT_DESCRIPTION,"为这种材料查询编码");
		}
		public void actionPerformed(ActionEvent evt)
		{
			connDB();
			String selectName=search_text.getText();
			int selectCode=0;
			String query="select code from device_code where device_name='"+selectName+"';";
			try
			{
				rs=st.executeQuery(query);
				while(rs.next())
				{
					selectCode=rs.getInt(1);
				}
				if(selectCode==0)
				{
					JOptionPane.showMessageDialog(null,"仓库里不存在这种材料！");
					search_result.setText("");
				}
				else
				{
					search_result.setText(String.valueOf(selectCode));
				}
			}
			catch(SQLException e)
			{
				JOptionPane.showMessageDialog(null,"数据库操作失败！");
			}
			closeDB1();
		}
	};
	Font f=new Font("Monospaced", Font.PLAIN,12);
	private JLabel code=new JLabel("编码维护",SwingConstants.CENTER);
	
	private JLabel l1=new JLabel("原材料名称:",SwingConstants.LEFT);
	
	private JTextField tf1=new JTextField(10);
	private JTextField jl1=new JTextField(5);
	private JLabel worning=new JLabel("确定此原材料的安全范围",SwingConstants.CENTER);
	
	private JLabel min_text=new JLabel("最小值：",SwingConstants.RIGHT);
	
	private JTextField min_number=new JTextField(5);
	private JLabel max_text=new JLabel("最大值：",SwingConstants.RIGHT);
	
	private JTextField max_number=new JTextField(5);

	private JLabel l2=new JLabel("半成品名称:",SwingConstants.LEFT);
	
	private JTextField tf2=new JTextField(10);
	private JTextField jl2=new JTextField(5);

	private JLabel l3=new JLabel("成品名称:",SwingConstants.LEFT);
	
	private JTextField tf3=new JTextField(10);
	private JTextField jl3=new JTextField(5);

	private JLabel search_label=new JLabel("查询材料的名称:",SwingConstants.CENTER);
	
	private JTextField search_text=new JTextField(10);
	private JTextField search_result=new JTextField(10);

	private JLabel description0=new JLabel("编码维护：为每一种新的原材料，半成品，成品分配一个可以互相区分的唯一字段",SwingConstants.CENTER);
	
	
	Connection con=null; 
	ResultSet rs=null; 
	ResultSet rss=null;
	Statement st=null; 
	PreparedStatement pstmt=null;
}