uecontrol.java

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

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

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

import javax.swing.JOptionPane;

import model.DBManager;

import view.UseEquipmentPane;

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

	private UseEquipmentPane pane;
	private DBManager db=new DBManager();
	private ResultSet rs;
	private int eid=-1;
	private String mid;
	private String uid;
	private String note;
	private Timestamp timestamp;
	private String sql;
	private int stute;
	private String seid;
	private String usefor;
	private int iuid;


	/**
	 * @param pane
	 */
	public UEControl(UseEquipmentPane pane) {
		this.pane=pane;
		
		// TODO 自动生成构造函数存根
	}

	/* （非 Javadoc）
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
		public void actionPerformed(ActionEvent e)
		{
			// TODO 自动生成方法存根
			Object button=e.getSource();
			boolean success=false;	
			if(button==pane.confirmbtn)
				{
					pane.surebtn.setEnabled(true);
					pane.cancelbtn.setEnabled(true);
					seid=pane.numbertex.getText().trim();
					mid=pane.manageridtex.getText().trim();
					uid=pane.idtex.getText().trim();
					note=pane.notetex.getText().trim();
					usefor=pane.usetex.getText().trim();
					try{
						timestamp=Timestamp.valueOf(pane.datetex.getText().trim()+" 00:00:00.000");
					}
					catch(IllegalArgumentException ie)
					{
						JOptionPane.showMessageDialog(null,"输入的时间格式有误,请参考:yyyy-mm-dd");
						pane.datetex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
					}
					eid=Integer.parseInt(seid);
					if(eid==-1||mid.equals("")||uid.equals(""))
					{
						JOptionPane.showMessageDialog(null,"请输入完整");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
					}
					dofine();
					
					
				}
				if(button==pane.surebtn)
				{
					dofine();
					int confirm=JOptionPane.showConfirmDialog(null,"以上信息是否正确?","确认",JOptionPane.YES_NO_OPTION);
					if(confirm==JOptionPane.YES_OPTION)
					{
						if(stute!=0)
						{
							JOptionPane.showMessageDialog(null,"资产状态不正常。不能领用");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.usetex.setText("");
							pane.notetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						
						sql="insert into out(oeid,omid,ouid,odate,ousefor) values( "+eid+","+mid+","+uid+",'"+timestamp+"','"+usefor+"')";					
						System.out.println(sql);
						success=db.executeSql(sql);
						if(!success)
						{
							JOptionPane.showMessageDialog(null,"不成功，请重试");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.usetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							
						}
						iuid=Integer.parseInt(uid);
						sql="update equipment set estute=4,eUID="+iuid+" where eid="+eid;
						System.out.println(sql);
						success=db.executeSql(sql);
						if(!success)
						{
							JOptionPane.showMessageDialog(null,"不成功，请重试");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.usetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						else
						{
							JOptionPane.showMessageDialog(null,"成功");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.usetex.setText("");
							pane.notetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
					}
				}
			
				if(button==pane.cancelbtn)
				{
					pane.numberlbl.setText("资产编号");
					pane.idlbl.setText("用户编号");
					pane.mangeridlbl.setText("管理员编号");
					pane.idtex.setText("");
					pane.numbertex.setText("");
					pane.usetex.setText("");
					pane.notetex.setText("");
					pane.datetex.setText("");
					pane.manageridtex.setText("");
					pane.surebtn.setEnabled(false);
					pane.cancelbtn.setEnabled(false);
					return;
					
				}
			}
		
				private void dofine()
				{
					sql="select * from equipment where eid="+eid;
					rs=db.getResult(sql);
					try
					{
						if(!rs.first()||rs.getInt(8)==1)
						{
							JOptionPane.showMessageDialog(null,"找不到资产的相关信息");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.usetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						else{
							pane.numberlbl.setText("资产名称");
							pane.numbertex.setText(rs.getString(11));
							stute=rs.getInt(6);
						
						}
						sql="select uname,udel from users where uid="+uid;
						rs=db.getResult(sql);
						if(!rs.first()||rs.getInt(2)==1)
						{
							JOptionPane.showMessageDialog(null,"找不到用户的相关信息");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.usetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						else{
							pane.idlbl.setText("用户名");
							pane.idtex.setText(rs.getString(1));
						
						}
			
						sql="select mname,mdel from manager where mid="+mid;
						rs=db.getResult(sql);
						if(!rs.first()||rs.getInt(2)==1)
						{
							JOptionPane.showMessageDialog(null,"找不到管理员的相关信息");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.usetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						else{
							pane.mangeridlbl.setText("管理员");
							pane.manageridtex.setText(rs.getString(1));
						
						}
					}catch(SQLException sqle)
					{
								System.out.println(sqle);
					}
					switch(stute)
					{
					case 0:
						pane.notetex.setText("正常");
						break;
					case 1:
						pane.notetex.setText("维修");
						break;
					case 2:
						pane.notetex.setText("报废");
						break;
					default:
						pane.notetex.setText("被占用");
					
					}
					
		}
	}