eacontrol.java

使用Java和sql开发的固定资产管理系统!

/*
 * 创建日期 2006-6-29
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package contorl;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.Timestamp;

import javax.swing.JOptionPane;

import model.DBManager;

import view.AddEquipment;

/**
 * @author 21660313010
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class EAControl implements ActionListener, ItemListener {

	private AddEquipment eq;
	private DBManager db=new DBManager();

	/**
	 * @param equipment
	 */
	public EAControl(AddEquipment equipment) {
		eq=equipment;
		
		// TODO 自动生成构造函数存根
	}

	/* （非 Javadoc）
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent e) {
		// TODO 自动生成方法存根
		int big=eq.bigcbx.getSelectedIndex();
		int small=eq.smallcbx.getSelectedIndex();
		int stute=eq.stutecbx.getSelectedIndex();
		String name=eq.nametex.getText().trim();
		String model=eq.modeltex.getText().trim();
		
		float value=Float.valueOf(eq.valuetex.getText().trim()).floatValue() ;
		String remark=eq.notetex.getText().trim();
		Object button=e.getSource();
		if(button==eq.addbtn)
		{
			Timestamp timestamp;
			try{
				timestamp=Timestamp.valueOf(eq.datetex.getText().trim()+" 00:00:00.000");
			}
			catch(IllegalArgumentException ie)
			{
				JOptionPane.showMessageDialog(null,"输入的时间格式有误,请参考:yyyy-mm-dd");
				eq.datetex.setText("");
				return;
			}
			if(small==-1|value<2000)
			{
				JOptionPane.showMessageDialog(null,"请选择小类或者价格必须大于2000");
				return;
			}
			String sql="insert into equipment(eclass,ekind,evalue,ebuyday,estute,eremark,edel,euid,emodel,ename) values("+big+","+small+","+value+",'"+timestamp+"',"+stute+",' "+remark+"',0,0,'"+model+"',' "+name+"')";
			boolean isexist=false;
			isexist=db.executeSql(sql);	
				if(!isexist)
				{
					JOptionPane.showMessageDialog(null,"添加不成功,请重新添加");
					return;
				}
				else
				{
					JOptionPane.showMessageDialog(null,"添加成功");
					eq.nametex.setText("");
					eq.modeltex.setText("");
					eq.notetex.setText("");
					eq.valuetex.setText("");
					eq.datetex.setText("");				
			}		
		}
		if(button==eq.cancelbtn)
		{
			eq.nametex.setText("");
			eq.modeltex.setText("");
			eq.notetex.setText("");
			eq.valuetex.setText("");
			eq.datetex.setText("");		
			return;
			
		}
		
		
		



	}

	/* （非 Javadoc）
	 * @see java.awt.event.ItemListener#itemStateChanged(java.awt.event.ItemEvent)
	 */
	public void itemStateChanged(ItemEvent e) {
		// TODO 自动生成方法存根
		
		Object big=e.getItem();
		if(big.equals("办公室外设"))
		{
			eq.smallchange(1);
		}
		if(big.equals("数码产品"))
		{
			eq.smallchange(2);
		}
		if(big.equals("计算机"))
		{
			eq.smallchange(3);
		}
		
	}

}