device_in.java

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

							pstmt.setString(6,s5);
							pstmt.setString(7,s6);
							pstmt.setInt(8,id);
							pstmt.execute();
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						
						query="select * from yuancailiao_total where device_name='"+s3+"';";
						try
						{
							rss=st.executeQuery(query);
							while(rss.next())
							{
								succ=true;
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(succ==true)
						{
							query="update yuancailiao_total set total_number=total_number+?,total_money=total_money+? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setFloat(2,Float.parseFloat(s5)*Integer.parseInt(s4));
								pstm.setString(3,s3);
								pstm.execute();
								closeDB1();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"原材料已成功入库！");
						}
						else
						{
							query="insert into yuancailiao_total values(?,?,?);";
							try
							{
								pst=con.prepareStatement(query);
								pst.setString(1,s3);
								pst.setInt(2,Integer.parseInt(s4));
								pst.setFloat(3,Float.parseFloat(s5)*Integer.parseInt(s4));
								pst.execute();
								closeDB2();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}	
							JOptionPane.showMessageDialog(null,"原材料已成功入库！");
						}						
					}					
				}
			}
			else if(id==2)
			{
				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
				{
					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(device_name,time,kind,numbers,id) values(?,?,?,?,?);";
						try
						{
							pstmt=con.prepareStatement(query);
							pstmt.setString(1,s3);//名称
							pstmt.setString(2,s);//时间
							pstmt.setString(3,s1);//类别
							pstmt.setString(4,s4);//数目
							pstmt.setInt(5,id);
							pstmt.execute();
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						
						query="select * from banchengping_total where device_name='"+s3+"';";
						try
						{
							rss=st.executeQuery(query);
							while(rss.next())
							{
								succ=true;
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(succ==true)
						{
							query="update banchengping_total set total_number=total_number+? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setString(2,s3);
								pstm.execute();
								closeDB1();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"半成品已成功入库！");
						}
						else
						{
							query="insert into banchengping_total values(?,?);";
							try
							{
								pst=con.prepareStatement(query);
								pst.setString(1,s3);
								pst.setInt(2,Integer.parseInt(s4));
								pst.execute();
								closeDB2();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"半成品已成功入库！");
							
						}
					}
				}
			}
			else if(id==3)
			{	
				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
				{
					connDB();
					String query="select code from device_code 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
					{
						String s=getTime();
						query="insert into log(device_name,time,kind,reason,numbers,id) 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);//数目
							pstmt.setInt(6,id);
							pstmt.execute();
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						
						query="select * from chengping_total where device_name='"+s3+"';";
						try
						{
							rss=st.executeQuery(query);
							while(rss.next())
							{
								succ=true;
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(succ==true)
						{
							query="update chengping_total set total_number=total_number+? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setString(2,s3);
								pstm.execute();
								closeDB1();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"成品已成功入库！");
						}
						else
						{
							query="insert into chengping_total values(?,?);";
							try
							{
								pst=con.prepareStatement(query);
								pst.setString(1,s3);
								pst.setInt(2,Integer.parseInt(s4));
								pst.execute();
								closeDB2();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"成品已成功入库！");
							
						}
					}
				}
			}
		}
	};
	Font f=new Font("Monospaced", Font.PLAIN,12);
	private JLabel devicein=new JLabel("入库管理",SwingConstants.CENTER);

	private JLabel l0=new JLabel("请选择入库材料类别：",SwingConstants.CENTER);
	private JLabel l2=new JLabel("请选择入库原因：",SwingConstants.CENTER);
	private JLabel l3=new JLabel("请输入入库材料名称：",SwingConstants.CENTER);
	private JTextField tf3=new JTextField(20);
	private JLabel l4=new JLabel("请输入入库材料数目：",SwingConstants.CENTER);
	private JTextField tf4=new JTextField(20);
	private JLabel l5=new JLabel("请输入入库材料单价：",SwingConstants.CENTER);
	private JTextField tf5=new JTextField(20);
	private JLabel l6=new JLabel("请输入入库材料供应商：",SwingConstants.CENTER);
	private JTextField tf6=new JTextField(20);
	
	private String[] cailiao={"原材料入库","半成品入库","成品入库"};
	private String[] yuancailiao={"等待检验原材料入库","合格原材料入库","质量不合格待退原材料入库","型号不对待退原材料入库","归还原材料入库"};
	private String[] chengping={"合格成品入库","不合格待退成品入库","归还成品入库","型号不对待退成品入库"};
	DefaultComboBoxModel model1=new DefaultComboBoxModel(cailiao);
	DefaultComboBoxModel model2=new DefaultComboBoxModel(yuancailiao);
	DefaultComboBoxModel model3=new DefaultComboBoxModel(chengping);
	JComboBox cai_liao=new JComboBox(model1);
	JComboBox yuancailiao_chengping=new JComboBox(model2);


	private JLabel description0=new JLabel("入库管理：记录每一种原材料，半成品，成品入库的情况",SwingConstants.CENTER);

	Connection con=null; 
	ResultSet rs=null; 
	ResultSet rss=null;
	Statement st=null; 
	PreparedStatement pstmt=null;
	PreparedStatement pstm=null;
	PreparedStatement pst=null;
}