ckguanli.java

基于Java——SQL2005 的java课程设计 仓库管理系统。主要功能

package windows;

import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JComponent;
import javax.swing.JFileChooser;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.border.TitledBorder;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import javax.swing.filechooser.FileFilter;

import com.sun.corba.se.pept.transport.Connection;

import sql.sql;
import windows.RKGuanLi.InputKeyListener;
import model.TbUserlist;
import Login.Item;
import Login.Login;

public class CKGuanLi extends JInternalFrame{

	private final JTextField Out_ID = new JTextField(); 
	private final JComboBox Eqp_Name = new JComboBox(); 
	private final JTextField Out_Num = new JTextField(); 
	private final JComboBox Eqp_Style = new JComboBox(new String[]{"CPU","主板","内存","显卡","硬盘","电源","光驱","机箱","键鼠","声卡"}); 
	private final JTextField Eqp_Para=new JTextField();
	private final JTextField Out_Time = new JTextField(); 
	private final JTextField Out_Oper = new JTextField(); 
	private final JTextField Out_Per = new JTextField(); 
	private final JLabel photoLabel = new JLabel("显示图片"); 
	private final JButton CZ= new JButton("重置");
	private final JTextField Out_Remark = new JTextField(); 
	private TbUserlist user = Login.getUser(); // 登录用户信息
	private int NumSum=0;
	public CKGuanLi() throws SQLException {
		super();
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		getContentPane().setLayout(new GridBagLayout());
		setTitle("仓库管理之出库管理");
		setBounds(20, 20,800,350);


		setupComponet(new JLabel("出库编号："), 0, 0, 1, 1 , 0, false);
		setupComponet(Out_ID, 1, 0, 1, 1 ,  140, true);
		Out_ID.setFocusable(false);
		Date IDDate = new Date();
		java.sql.Date date = new java.sql.Date(IDDate.getTime());
		final String dateStr = date.toString().replace("-", "");
		Out_ID.setText("E_OUT_"+dateStr+getMaxId());
		
		setupComponet(new JLabel("出库时间："), 2,0, 1, 1 , 0, false);
		setupComponet(Out_Time,3, 0, 1, 1 , 1, true);
		Out_Time.setFocusable(false);
		
		setupComponet(new JLabel("操作员："), 4,0, 1, 1 , 0, false);
		setupComponet(Out_Oper,5, 0, 1,  1 ,100, true);
		Out_Oper.setText(user.getName());
		Out_Oper.setFocusable(false);
		
		setupComponet(new JLabel("设备名称："),2,1, 1, 1 , 0, false);
		setupComponet(Eqp_Name ,3, 1,3, 1 , 200, true);
		
		setupComponet(new JLabel("经手人："),2,2, 1, 1 , 0, false);
		setupComponet(Out_Per,3,2, 2, 1 , 100, true);
		
		setupComponet(new JLabel("出库数量："), 0, 2, 1, 1 , 0, false);
		setupComponet(Out_Num ,1, 2, 1, 1 , 140, true);
		Out_Num.addKeyListener(new InputKeyListener());

		
		setupComponet(new JLabel("设备类型："), 0,1, 1, 1 ,0, false);
		setupComponet(Eqp_Style,1,1, 1, 1, 140, true);
		
		setupComponet(new JLabel("设备参数：") ,0,3, 1, 1, 0, false);
		setupComponet(Eqp_Para, 1, 3, 4,1, 140, true);
		Eqp_Para.setPreferredSize(new Dimension(20, 100));
		Eqp_Para.setFocusable(false);
		
		setupComponet(new JLabel("备注："), 0, 4, 1, 1 , 0, false);
		setupComponet(Out_Remark,1, 4, 4,  1 ,140, true);
	

		photoLabel.setHorizontalAlignment(SwingConstants.CENTER);// 设置照片或文字居中显示
		photoLabel.setBorder(new TitledBorder(null, "",
				TitledBorder.DEFAULT_JUSTIFICATION,
				TitledBorder.DEFAULT_POSITION, null, null));// 设置边框
		photoLabel.setPreferredSize(new Dimension(20, 135));// 设置显示照片的大小
		setupComponet(photoLabel,5, 1, 1, 5,140, true);
		
		JButton Exit =new JButton("退出");
		JPanel panel = new JPanel();
		panel.add(CZ);
		panel.add(Exit);
		JButton CK =new JButton("出库");
		setupComponet(CK, 2, 7, 1,8, 0, false);
		setupComponet(panel, 3, 7, 1,8, 0, false);
		
		//重置
		CZ.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				Eqp_Name.removeAll();
				Out_Num.setText(null);
				Eqp_Para.setText(null);
				Out_Per.setText(null);
				photoLabel.setIcon(null);
				photoLabel.setText("显示图片");
				Out_Remark.setText(null);
				Eqp_Name.requestFocus();
			}
		});
		//退出
		Exit.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				dispose();
			}
		});
		
		
		CK.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
			}	
		});
		/*
		Eqp_Style.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Item selectedItem;
				if (!(Eqp_Style.getSelectedItem() instanceof Item)) {
					return;
				}
				//selectedItem = (Item) Eqp_Style.getSelectedItem();
				
				//JOptionPane.showMessageDialog(null, "dddddd");
				//String sqlyuju = "select * from tb_Stor where ";
				//ResultSet set = sql.query(sqlyuju + "Eqp_Style='" + Eqp_Style.getItemAt(Eqp_Style.getSelectedIndex()) +"'");
				
				//final TbUserlist Eqp_nametemp = sql.getUser((Item)userCombo.getItemAt(0));
				
				//Eqp_Name=Eqp_Name.getItemAt(0);
				
			}
			});*/
		
		Eqp_Style.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {	
				/*if (!(Eqp_Style.getSelectedItem() instanceof Item)) {
					JOptionPane.showMessageDialog(null, "ddddgggggg");
					return;
				}*/
				initComboBox();
							
			}
		});
		
		
		/*Eqp_Name.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Item selectedItem;
				if (!(Eqp_Name.getSelectedItem() instanceof Item)) {
					return;
				}
				selectedItem = (Item) Eqp_Name.getSelectedItem();
				}
			});*/
		
		Eqp_Name.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {	
				if (!(Eqp_Name.getSelectedItem() instanceof Item)) {
					return;
				}
				String sqlyuju = "select * from tb_Stor where ";
				ResultSet set = sql.query(sqlyuju + "Eqp_Name = '" + Eqp_Name.getItemAt(Eqp_Name.getSelectedIndex())  +"'");
				try {
					if(set.next())   
					{
						//Eqp_Para.setText(set.getString(4));
						//Eqp_Para.setText("dddddd");
						//JOptionPane.showMessageDialog(null, set.getString(4));
						NumSum=set.getInt(2);
						Eqp_Para.setText(set.getString(4).trim());
						
						//取照片
						java.sql.Connection   cn   =   null;
						try   
						  {         
							  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						      cn = (java.sql.Connection) DriverManager.getConnection("jdbc:odbc:Storage");	
						  //PreparedStatement   st=((java.sql.Connection) cn).prepareStatement("select   abc   from   img");   
						      PreparedStatement   st = ((java.sql.Connection) cn).prepareStatement("select * from tb_Stor where "+ "Eqp_Name = '" + Eqp_Name.getItemAt(Eqp_Name.getSelectedIndex())  +"'");
						      
						      // st.setBinaryStream(1,file,file.available());   
						        ResultSet   rs=st.executeQuery();   
						        
						        byte   b[]=new   byte[10240000];   
						        File file;
						                          while(rs.next())     
						                        {   
						                        	  //JOptionPane.showMessageDialog(null, rs.getString(1));  
						                            InputStream   in=rs.getBinaryStream(5);   
						                            in.read(b);   
						                              
						                          file=new   File("Eqp_Pot.jpg");   
						    FileOutputStream   write=new   FileOutputStream(file);   
						    write.write(b);