edcontrol.java

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

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

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JOptionPane;

import model.DBManager;

import view.DelEquipmentPane;

/**
 * @author 21660313010
 * 
 * TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class EDControl implements ActionListener {
	private DelEquipmentPane ed;
	private DBManager db=new DBManager();
	private ResultSet rs;
	int eid=0;

	/**
	 * @param pane
	 */
	
	public EDControl(DelEquipmentPane pane) {
		ed=pane;
		
		// TODO 自动生成构造函数存根
	}
	


	/*
	 * （非 Javadoc）
	 * 
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent e) {
		// TODO 自动生成方法存根
		Object button=e.getSource();
		String seid=ed.idtex.getText().trim();
		String sql="select * from equipment where eid=";
		boolean success=false;
		if(seid.equals(""))
		{
			JOptionPane.showMessageDialog(null,"请输入资产编号");
			return;
		}
		else
		{
			eid=Integer.parseInt(seid);
			if(button==ed.finebtn)
			{
				dofine(sql);
			}
			if(button==ed.editbtn)
			{
				dofine(sql);
				int confirm=JOptionPane.showConfirmDialog(null,"是否删除?","删除确认",JOptionPane.YES_NO_OPTION);
				if(confirm==JOptionPane.YES_OPTION)
				{
					
					sql="update equipment set edel=1 where eid="+eid;
					System.out.println(sql);
					success=db.executeSql(sql);
					if(!success)
					{
						JOptionPane.showMessageDialog(null,"修改不成功，请重试");
					}
					else
					{
						JOptionPane.showMessageDialog(null,"修改成功");
						ed.idtex.setText("");
						ed.bigtex.setText("");
						ed.smalltex.setText("");
						ed.nametex.setText("");
						ed.stutetex.setText("");
						ed.valuetex.setText("");
						ed.datetex.setText("");
						ed.modeltex.setText("");
						ed.nametex.setText("");
						return;
					}
				}
			}
			if(button==ed.cancelbtn)
			{
				ed.idtex.setText("");
				ed.bigtex.setText("");
				ed.smalltex.setText("");
				ed.nametex.setText("");
				ed.stutetex.setText("");
				ed.valuetex.setText("");
				ed.datetex.setText("");
				ed.modeltex.setText("");
				ed.nametex.setText("");
				return;
				
			}
		}
	}
				
	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,"没有该资产或者已经被删除");
				ed.idtex.setText("");
				ed.bigtex.setText("");
				ed.smalltex.setText("");
				ed.nametex.setText("");
				ed.stutetex.setText("");
				ed.valuetex.setText("");
				ed.datetex.setText("");
				ed.modeltex.setText("");
				ed.nametex.setText("");
				return;
			}
			else
			{
				rs.beforeFirst();
				while(rs.next())
				{
					big=rs.getInt(2);
					small=rs.getInt(3);
					ed.valuetex.setText(rs.getString(4));
					ed.datetex.setText((rs.getString(5)).substring(0,11));
					stute=rs.getInt(6);
					ed.modeltex.setText(rs.getString(10));
					ed.nametex.setText(rs.getString(11));
				}
			}
		}catch(SQLException sqle)
		{
			JOptionPane.showMessageDialog(null,"没有该资产或者已经被删除");
			ed.idtex.setText("");
			ed.bigtex.setText("");
			ed.smalltex.setText("");
			ed.nametex.setText("");
			ed.stutetex.setText("");
			ed.valuetex.setText("");
			ed.datetex.setText("");
			ed.modeltex.setText("");
			ed.nametex.setText("");
					System.out.println(sqle);
					return;
		}
		if(big==0)
			{
				ed.bigtex.setText("办公室外设");
				switch(small)
					{
						case 0:
							ed.smalltex.setText("传真机");
							break;
						case 1:
							ed.smalltex.setText("复印机");
							break;
						case 2:
							ed.smalltex.setText("打印机");
							break;
						case 3:
							ed.smalltex.setText("其他");
							break;
					}
				}
			if(big==1)
				{
					ed.bigtex.setText("数码产品");
					switch(small)
					{
						case 0:
						ed.smalltex.setText("数码相机");
						break;
						case 1:
						ed.smalltex.setText("投影仪");
						break;
						case 2:
						ed.smalltex.setText("其他");
						break;
					}
						
				}
			if(big==2)
				{
					ed.bigtex.setText("计算机");
					switch(small)
					{
						case 0:
						ed.smalltex.setText("笔记本电脑");
						break;
						case 1:
						ed.smalltex.setText("台式机");
						break;
						case 2:
						ed.smalltex.setText("服务器");
						break;
						case 3:
						ed.smalltex.setText("其他");
						break;
					}
				}
			switch(stute)
			{
			case 0:
				ed.stutetex.setText("正常");
				break;
			case 1:
				ed.stutetex.setText("维修");
				break;
			case 2:
				ed.stutetex.setText("报废");
				break;
			default:
				ed.stutetex.setText("被占用");
			
			}
	}
}