stockteldialog.java

用java编写的人事管理系统,很好的 学习下吧

/**
 * 源文件：StockTelDialog.java
 * 作用：进货信息窗体
 */
package mypro;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.util.*;

public class StockTelDialog extends JDialog implements ActionListener,MouseListener
{
	StockTelData std=new StockTelData();
	Check check=new Check();
	private JLabel labStockInvoice,labImei,labUnitPrice,labStockDate,labUserCode,labSupplierBrief,labContents;
	private JTextField txtStockInvoice,txtImei,txtUnitPrice,txtStockDate,txtUserCode,txtSupplierBrief;
	private JButton btnInsert,btnUpdate,btnDelete;
	private JTextArea teaContents;
	private JScrollPane scop, scop1;
	private JTable tabShow;
	private DefaultTableModel dtm;
	private int row=0;
	
	static 
	{
   	 	//设置窗体为豪华框架
   		JDialog.setDefaultLookAndFeelDecorated(true);		
	}
	
	public StockTelDialog(MainFrame owner,boolean bo)
	{
		super(owner,bo);
		labStockInvoice = new JLabel("*进货单号");
  		txtStockInvoice = new JTextField();
  		labImei = new JLabel("*手机串号");
  		txtImei = new JTextField();
  		labUnitPrice = new JLabel("*进货单价");
  		txtUnitPrice = new JTextField();
  		labStockDate = new JLabel("*进货日期");
  		txtStockDate = new JTextField();
  		labUserCode = new JLabel("*工号");
  		txtUserCode = new JTextField();
  		labSupplierBrief = new JLabel("*供货商代码");
  		txtSupplierBrief = new JTextField();
  		labContents = new JLabel("备注信息");
  		teaContents = new JTextArea();
		btnInsert = new JButton("插入");
  		btnUpdate = new JButton("修改");
  		btnDelete = new JButton("删除");
  		scop = new JScrollPane();
  		scop1 = new JScrollPane();
  		tabShow = new JTable();
  		
  		labStockInvoice.setBounds(new Rectangle(12, 16, 73, 14));
    	txtStockInvoice.setBounds(new Rectangle(82, 16, 121, 23));
    	labImei.setBounds(new Rectangle(12, 49, 73, 14));
    	txtImei.setBounds(new Rectangle(82, 49, 121, 23));
    	labUnitPrice.setBounds(new Rectangle(12, 82, 73, 14));
    	txtUnitPrice.setBounds(new Rectangle(82, 82, 121, 23));
    	labStockDate.setBounds(new Rectangle(12, 114, 73, 14));
   		txtStockDate.setBounds(new Rectangle(82, 114, 121, 23));
   		labUserCode.setBounds(new Rectangle(254, 18, 73, 14));
    	txtUserCode.setBounds(new Rectangle(330, 18, 121, 23));
    	labSupplierBrief.setBounds(new Rectangle(254, 49, 73, 14));
    	txtSupplierBrief.setBounds(new Rectangle(330, 49, 121, 23));
    	labContents.setBounds(new Rectangle(254, 82, 73, 14));
    	scop1.setBounds(new Rectangle(330, 82, 121, 55));
        
  		btnInsert.setBounds(new Rectangle(12, 148, 89, 28));
  		btnInsert.setActionCommand("Insert");
  		btnInsert.setToolTipText("插入新的进货信息");
      	btnUpdate.setBounds(new Rectangle(187, 148, 89, 28));
      	btnUpdate.setActionCommand("Update");
      	btnUpdate.setToolTipText("修改进货信息");
    	btnDelete.setBounds(new Rectangle(362, 148, 89, 28));
    	btnDelete.setActionCommand("Delete");
    	btnDelete.setToolTipText("删除进货信息");
        scop.setBounds(new Rectangle(12, 190, 439, 98));
        
    	btnInsert.addActionListener(this);
    	btnUpdate.addActionListener(this);
    	btnDelete.addActionListener(this);
    	tabShow.addMouseListener(this);

        
        Container me=this.getContentPane();
  		me.setLayout(null);
  		me.add(labStockInvoice);
        me.add(txtStockInvoice);
        me.add(labImei);
        me.add(txtImei);
        me.add(labUnitPrice);
        me.add(txtUnitPrice);
     	me.add(labStockDate);
   	 	me.add(txtStockDate);
   	 	me.add(labUserCode);
    	me.add(txtUserCode);
    	me.add(labSupplierBrief);
    	me.add(txtSupplierBrief);
    	me.add(labContents);
    	me.add(btnInsert);
    	me.add(btnDelete);
    	me.add(btnUpdate);
    	me.add(scop);
        me.add(scop1);
        scop1.getViewport().add(teaContents);
        scop.getViewport().add(tabShow);
        DatabaseOperate datao = new DatabaseOperate();
  		dtm = new DefaultTableModel(datao.getDataByTabname("stockTel"),datao.getColumnNamesByTabname("stockTel"));
        tabShow.setModel(dtm);//通过dtm模型构造表
        tabShow.setAutoResizeMode(tabShow.AUTO_RESIZE_OFF);//当调整表的大小时，设置表的自动调整模式为不自动调整列的宽度；使用滚动条
        
        this.setTitle("进货信息");
	  	this.setSize(480,380);
	  	this.setLocationRelativeTo(this);
	  	this.setResizable(false);
	  	this.setVisible(true);	
	}
	public void actionPerformed(ActionEvent stae)
	{
		String strbtn=stae.getActionCommand();
		if(strbtn.equals("Insert"))
		{
			String strimei=txtImei.getText().trim();
			if(check.checkPrimary("stockTel","手机串号",strimei))
			{
			  	JOptionPane.showMessageDialog(null,"该手机串号已存在","提示",JOptionPane.INFORMATION_MESSAGE);
			  	txtImei.setText("");
		 		txtImei.requestFocus();			
		 	}
			else if(operationBeforeCheck())
			{
				InsertData ind =new InsertData();
				Vector vid =dataVector();
				if(ind.StockTelInsert(std))
			  	{
			  		JOptionPane.showMessageDialog(null,"成功插入一行数据,请添加手机信息","提示",JOptionPane.INFORMATION_MESSAGE);
			  		dtm.addRow(vid);//添加一行到模型的结尾
			  		new ProductsTelDialog(null,true);	
			  	}
			  	else
			  	{
			  		JOptionPane.showMessageDialog(null,"数据插入失败","提示",JOptionPane.INFORMATION_MESSAGE);	
			  	}
			}
		}
		else if(strbtn.equals("Update"))
		{
			String strimei1=tabShow.getValueAt(row,1).toString().trim();
			String strimei=txtImei.getText().trim();
			if(!strimei.equals(strimei1))
			{
				if(check.checkPrimary("productsTel","手机串号",strimei1))
				{
					JOptionPane.showMessageDialog(null,"该手机串号被手机信息表引用,禁止更改","提示",JOptionPane.INFORMATION_MESSAGE);
				  	txtImei.setText(strimei1);
				}
				else if(check.checkUpdataAfterUnique("stockTel","手机串号",strimei,strimei1))
				{
					JOptionPane.showMessageDialog(null,"该手机串号已存在,无法修改","提示",JOptionPane.INFORMATION_MESSAGE);
				  	txtImei.setText(strimei1);
			 		txtImei.requestFocus();
				}
			}
			else if(operationBeforeCheck())
			{
				UpdateData upd=new UpdateData();
					
				if(upd.stockTelUpdate(std,strimei1))
				{
					JOptionPane.showMessageDialog(null,"成功修改一行数据","提示",JOptionPane.INFORMATION_MESSAGE);
					changeRowData();//修改表模型中的数据
				}
				else
				{
					JOptionPane.showMessageDialog(null,"数据修改失败","提示",JOptionPane.INFORMATION_MESSAGE);
				}
			}
		  		
		}
		else if(strbtn.equals("Delete"))
		{
			String strimeid=tabShow.getValueAt(row,1).toString().trim();
			DeleteData ded=new DeleteData();
			if(check.checkPrimary("productsTel","手机串号",strimeid))
			{
				JOptionPane.showMessageDialog(null,"该手机串号被手机信息表引用,请先删除或修改其他表中相关数据","提示",JOptionPane.INFORMATION_MESSAGE);
			}
			else
			{
				if(ded.deleteDate("stockTel","手机串号",strimeid))
				{
					JOptionPane.showMessageDialog(null,"成功删除一行数据","提示",JOptionPane.INFORMATION_MESSAGE);
					dtm.removeRow(row);//移除模型中 row 位置的行
				}
				else
				{
					JOptionPane.showMessageDialog(null,"数据删除失败","提示",JOptionPane.INFORMATION_MESSAGE);
				}	
			}		
		}
		txtStockInvoice.setText("");
		txtImei.setText("");
		txtUnitPrice.setText("");
		txtStockDate.setText("");
		txtUserCode.setText("");
		txtSupplierBrief.setText("");
		teaContents.setText("");
	}
	/*单击表中的一行将数据返回到组件中*/
	public void mouseEntered(MouseEvent me){}
	public void mouseExited(MouseEvent me){}
	public void mousePressed(MouseEvent me){}
	public void mouseReleased(MouseEvent me){}
	public void mouseClicked(MouseEvent me)
	{
	  row=tabShow.getSelectedRow();
	  String strstoi=String.valueOf(tabShow.getValueAt(row,0));
	  String strimei=(String)tabShow.getValueAt(row,1);
	  String strup=String.valueOf(tabShow.getValueAt(row,2));
	  String strstod=(String)tabShow.getValueAt(row,3);
	  String strcode=(String)tabShow.getValueAt(row,4);
	  String strsub=(String)tabShow.getValueAt(row,5);
	  String strcots=(String)tabShow.getValueAt(row,6);
	  	
	  txtStockInvoice.setText(strstoi.trim());
	  txtImei.setText(strimei.trim());
	  txtUnitPrice.setText(strup.trim());
	  txtStockDate.setText(strstod.trim());
	  txtUserCode.setText(strcode.trim());
	  txtSupplierBrief.setText(strsub.trim());
	  if(strcots==null)
	  {
	  	teaContents.setText(strcots);
	  }
	  else
	  {
	  	teaContents.setText(strcots.trim());
	  }
	}
	/* 执行操作前对数据进行验证*/
	public boolean operationBeforeCheck()
	{
		int strstoi=0;
		double strup=0;
		try
		{
		  	strstoi=Integer.parseInt(txtStockInvoice.getText().trim());
		  	strup=Double.parseDouble(txtUnitPrice.getText().trim());
		}
		catch(NumberFormatException ne)
		{
		  	JOptionPane.showMessageDialog(null,"请输入数字","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtStockInvoice.setText("");
	 		txtStockInvoice.requestFocus();
		  	return false;
		}
		String strimei=txtImei.getText().trim();
		String strstod=txtStockDate.getText().trim();
		String strcode=txtUserCode.getText().trim();
		String strsub=txtSupplierBrief.getText().trim();
		String strcots=teaContents.getText().trim();
		
		if(strcots.equals(""))
		{
			strcots=null;	
		}
		
		std.setStockInvoice(strstoi);
		std.setImei(strimei);
		std.setUnitPrice(strup);
		std.setStockDate(strstod);
		std.setUserCode(strcode);
		std.setSupplierBrief(strsub);
		std.setContents(strcots);
		
		if(strstoi==0||strimei.length()==0||strup==0||strstod.length()==0||strcode.length()==0||strsub.length()==0)
		{
			JOptionPane.showMessageDialog(null,"带*号的必填,请填写完整","提示",JOptionPane.INFORMATION_MESSAGE);
			return false;
		}
		else if(strstoi>9999&&strstoi<0)
		{
		  	JOptionPane.showMessageDialog(null,"请输入4位以内整数","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtStockInvoice.setText("");
	 		txtStockInvoice.requestFocus();
	 		return false;
		}
		else if(strup<0)
		{
			JOptionPane.showMessageDialog(null,"请输入8位以内数字","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtUnitPrice.setText("");
	 		txtUnitPrice.requestFocus();
	 		return false;
		}
		else if(!check.checkDate(strstod))
		{
		  	JOptionPane.showMessageDialog(null,"请输入准确的,如1996-02-03格式的日期","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtStockDate.setText("");
	 		txtStockDate.requestFocus();
	 		return false;
		}
		else if(!(check.checkPrimary("users","工号",strcode)))
		{
			JOptionPane.showMessageDialog(null,"无此员工信息","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtUserCode.setText("");
	 		txtUserCode.requestFocus();
	 		return false;
		}
		else if(!(check.checkPrimary("suppliers","供货商代码",strsub)))
		{
			JOptionPane.showMessageDialog(null,"无此供货商信息","提示",JOptionPane.INFORMATION_MESSAGE);
		  	txtSupplierBrief.setText("");
	 		txtSupplierBrief.requestFocus();
	 		return false;	
		}
		else if(strcots!=null&&strcots.length()>25)
		{
		  	JOptionPane.showMessageDialog(null,"字数过长","提示",JOptionPane.INFORMATION_MESSAGE);
		  	teaContents.setText("");
	 		teaContents.requestFocus();	
	 		return false;		
		}
		else
		{
			return true;
		}
	}
	/*得到一行加入模型中的数据*/
	public Vector dataVector()
	  {
	  	Vector vd=new Vector();
		vd.add(std.getStockInvoice());
		vd.add(std.getImei());
		vd.add(std.getUnitPrice());
		vd.add(std.getStockDate());
		vd.add(std.getUserCode());
		vd.add(std.getSupplierBrief());
		vd.add(std.getContents());
		return vd;
	  }
	  /*修改表模型中的数据*/
	  public void changeRowData()
	  {
	  	tabShow.setValueAt(std.getStockInvoice(),row,0);
	  	tabShow.setValueAt(std.getImei(),row,1);
	  	tabShow.setValueAt(std.getUnitPrice(),row,2);
	  	tabShow.setValueAt(std.getStockDate(),row,3);
	  	tabShow.setValueAt(std.getUserCode(),row,4);
	  	tabShow.setValueAt(std.getSupplierBrief(),row,5);
	  	tabShow.setValueAt(std.getContents(),row,6);
	  }
}