eecontrol.java

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

/*
 * 创建日期 2006-6-30
 *
 * 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.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;

import javax.swing.JOptionPane;

import model.DBManager;

import view.EditEquipmentPane;

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

	private EditEquipmentPane ee;
	private DBManager db=new DBManager();
	private ResultSet rs;
	String seid="";
	private int eid;

	/**
	 * @param pane
	 */
	public EEControl(EditEquipmentPane pane) {
		ee=pane;
		
		// TODO 自动生成构造函数存根
	}

	/* （非 Javadoc）
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent e) {
//		 TODO 自动生成方法存根
		Object button=e.getSource();
		String sql="select * from equipment where eid=";
		boolean success=false;
		String seid=ee.idtex.getText().trim();
		if(seid.equals(""))
		{
			JOptionPane.showMessageDialog(null,"请输入资产编号");
			return;
		}
		eid=Integer.parseInt(seid);
		if(button==ee.finebtn)
		{
			
				dofine(sql);
				
				
		}
			if(button==ee.editbtn)
			{
				Timestamp timestamp;
				try{
					 timestamp = Timestamp.valueOf(ee.datetex.getText().trim()+" 00:00:00.000");
				}
				catch(IllegalArgumentException ie)
				{
					JOptionPane.showMessageDialog(null,"输入的时间格式有误,请参考:yyyy-mm-dd");
					ee.datetex.setText("");
					return;
				}
				
				int big=ee.bigcbx.getSelectedIndex();
				int small=ee.smallcbx.getSelectedIndex();
				int stute=ee.stutecbx.getSelectedIndex();
				String name=ee.nametex.getText().trim();
				String model=ee.modeltex.getText().trim();
				float value=Float.valueOf(ee.valuetex.getText().trim()).floatValue() ;
				int confirm=JOptionPane.showConfirmDialog(null,"是否修改?","修改确认",JOptionPane.YES_NO_OPTION);
				if(confirm==JOptionPane.YES_OPTION)
				{
					
					sql="update equipment set ename='"+name+"',eclass="+big+",ekind="+small+",evalue="+value+" ,ebuyday='"+timestamp+"',estute="+stute+",emodel='"+model+"'  where eid="+seid;
					System.out.println(sql);
					success=db.executeSql(sql);
					if(!success)
					{
						JOptionPane.showMessageDialog(null,"修改不成功，请重试");
					}
					else
					{
						JOptionPane.showMessageDialog(null,"修改成功");
						ee.idtex.setText("");			
						ee.nametex.setText("");
						ee.valuetex.setText("");
						ee.datetex.setText("");
						ee.modeltex.setText("");
						ee.bigcbx.setEnabled(false);
						ee.cancelbtn.setEnabled(false);
						ee.datetex.setEditable(false);
						ee.editbtn.setEnabled(false);
						ee.modeltex.setEditable(false);
						ee.nametex.setEditable(false);
						ee.smallcbx.setEnabled(false);
						ee.stutecbx.setEnabled(false);
						ee.valuetex.setEditable(false);
						return;
					}
				}
			}
			if(button==ee.cancelbtn)
			{
				ee.idtex.setText("");
				ee.nametex.setText("");
				ee.valuetex.setText("");
				ee.datetex.setText("");
				ee.modeltex.setText("");
				return;
				
			}
		}
	
	/* （非 Javadoc）
	 * @see java.awt.event.ItemListener#itemStateChanged(java.awt.event.ItemEvent)
	 */
	public void itemStateChanged(ItemEvent e) {
		Object big=e.getItem();
		if(big.equals("办公室外设"))
		{
			ee.smallchange(0);
		}
		if(big.equals("数码产品"))
		{
			ee.smallchange(1);
		}
		if(big.equals("计算机"))
		{
			ee.smallchange(2);
		}
		
		// TODO 自动生成方法存根
		
	}

	private void dofine(String sql)
	{
		sql=sql+eid;
		rs=db.getResult(sql);
		int big=0;
		int small=0;
		int stute=-1;
		try
		{
			if(!rs.first()|(rs.getInt(8)==1))
			{
				JOptionPane.showMessageDialog(null,"没有该资产或者已经被删除");
				ee.idtex.setText("");
				ee.nametex.setText("");
				ee.valuetex.setText("");
				ee.datetex.setText("");
				ee.modeltex.setText("");
				ee.bigcbx.setEnabled(false);
				ee.cancelbtn.setEnabled(false);
				ee.datetex.setEditable(false);
				ee.editbtn.setEnabled(false);
				ee.modeltex.setEditable(false);
				ee.nametex.setEditable(false);
				ee.smallcbx.setEnabled(false);
				ee.stutecbx.setEnabled(false);
				ee.valuetex.setEditable(false);
				return;
			}
			else
			{
				rs.beforeFirst();
				while(rs.next())
				{
					big=rs.getInt(2);
					small=rs.getInt(3);
					ee.valuetex.setText(rs.getString(4));
					ee.datetex.setText((rs.getString(5)).substring(0,11));
					stute=rs.getInt(6);
					ee.modeltex.setText(rs.getString(10));
					ee.nametex.setText(rs.getString(11));
					ee.bigcbx.setEnabled(true);
					ee.cancelbtn.setEnabled(true);
					ee.datetex.setEditable(true);
					ee.editbtn.setEnabled(true);
					ee.modeltex.setEditable(true);
					ee.nametex.setEditable(true);
					ee.smallcbx.setEnabled(true);
					ee.stutecbx.setEnabled(true);
					ee.valuetex.setEditable(true);
				}
			}
		}catch(SQLException sqle)
		{
			JOptionPane.showMessageDialog(null,"没有该资产或者已经被删除");
					System.out.println(sqle);
					ee.idtex.setText("");
					ee.nametex.setText("");
					ee.valuetex.setText("");
					ee.datetex.setText("");
					ee.modeltex.setText("");
					ee.bigcbx.setEnabled(false);
					ee.cancelbtn.setEnabled(false);
					ee.datetex.setEditable(false);
					ee.editbtn.setEnabled(false);
					ee.modeltex.setEditable(false);
					ee.nametex.setEditable(false);
					ee.smallcbx.setEnabled(false);
					ee.stutecbx.setEnabled(false);
					ee.valuetex.setEditable(false);
					return;
		}
		if(big==0)
			{
				ee.bigcbx.setSelectedIndex(big);
				switch(small)
					{
						case 1:
							ee.smallcbx.setSelectedIndex(small);
							break;
						case 2:
							ee.smallcbx.setSelectedIndex(small);
							break;
						case 3:
							ee.smallcbx.setSelectedIndex(small);
							break;
						case 4:
							ee.smallcbx.setSelectedIndex(small);
							break;
					}
				}
			if(big==1)
				{
					ee.bigcbx.setSelectedIndex(1);
					switch(small)
					{
						case 1:
						ee.smallcbx.setSelectedIndex(small);
						break;
						case 2:
						ee.smallcbx.setSelectedIndex(small);
						break;
						case 3:
						ee.smallcbx.setSelectedIndex(small);
						break;
					}
						
				}
			if(big==2)
				{
					ee.bigcbx.setSelectedIndex(2);
					switch(small)
					{
						case 1:
						ee.smallcbx.setSelectedIndex(small);
						break;
						case 2:
						ee.smallcbx.setSelectedIndex(small);
						break;
						case 3:
						ee.smallcbx.setSelectedIndex(small);
						break;
						case 4:
						ee.smallcbx.setSelectedIndex(small);
						break;
					}
				}
			switch(stute)
			{
			case 0:
				ee.stutecbx.setSelectedIndex(stute);
				break;
			case 1:
				ee.stutecbx.setSelectedIndex(stute);
				break;
			case 2:
				ee.stutecbx.setSelectedIndex(stute);
				break;
			default:
				ee.stutecbx.setSelectedIndex(stute);
			
			}
	}
}