package?packClass;

import?java.io.Serializable;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;

public?class?EquipInfo?implements?Serializable?{

	/**
	?*?@param?args
	?*/
	public?ResultSet?rs;

	public?String?equipNa;

	public?String?type;

	public?String?branch;

	public?String?price;

	public?String?repairInfo;

	/**
	?*?
	?*/
	public?EquipInfo（）?{

	}

	/**
	?*?
	?*?@param?amdStr
	?*?@return
	?*/
	public?boolean?executeAmend（EquipInfo?equip）?{
		Statement?stmt?=?OdbConnect.getStatment（）;
		String?amendStr?=?““;
		int?flag?=?0;
		try?{

			amendStr?+=?“update?fEquip?“;
			amendStr?+=?“?set?equipNa=‘“?+?equip.getEquipNa（）?+?“‘“;
			amendStr?+=?“?type=‘“?+?equip.getType（）?+?“‘“;
			amendStr?+=?“?branch=‘“?+?equip.getBranch（）?+?“‘“;
			amendStr?+=?“?price=‘“?+?equip.getPrice（）?+?“‘“;
			amendStr?+=?“?repairInfo=‘“?+?equip.getRepairInfo（）?+?“‘?“;
			amendStr?+=?“?where?equipNa=‘“?+?equip.getEquipNa（）?+?“‘“;
			flag?=?stmt.executeUpdate（amendStr）;
			stmt.close（）;
			OdbConnect.close（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?false;
		}
		if?（flag?==?1）
			return?true;
		else
			return?false;
	}

	/**
	?*?
	?*?@param?str
	?*?@return
	?*/
	public?boolean?equipUpdate（String?str）?{
		Statement?stmt?=?OdbConnect.getStatment（）;
		int?flag?=?0;

		try?{
			flag?=?stmt.executeUpdate（str）;
			stmt.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}
		OdbConnect.close（）;
		if?（flag?==?1）
			return?true;
		else
			return?false;
	}

	public?boolean?insertEquip（EquipInfo?equip）?{
		Statement?stmt?=?OdbConnect.getStatment（）;
		try?{

			String?insertStr?=?“insert?into?fEquip?values（‘“
					+?equip.getEquipNa（）?+?“‘‘“?+?equip.getType（）?+?“‘‘“
					+?equip.getBranch（）?+?“‘‘“?+?equip.price?+?“‘‘“
					+?equip.getRepairInfo（）?+?“‘）“;

			stmt.executeUpdate（insertStr）;
			stmt.close（）;
			OdbConnect.close（）;
			return?true;

		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			try?{
				stmt.close（）;
				OdbConnect.close（）;
			}?catch?（SQLException?e1）?{
				//?TODO?Auto-generated?catch?block
				e1.printStackTrace（）;
			}

			return?false;
		}

	}

	/**
	?*?
	?*?@param?strQ
	?*?@return
	?*/
	public?ArrayList?equipQuery（String?strQ）?{
		Statement?stmt?=?OdbConnect.getStatment（）;
		ArrayList?list?=?new?ArrayList（）;
		try?{
			EquipInfo?temp?=?new?EquipInfo（）;
			rs?=?stmt.executeQuery（strQ）;
			while?（rs.next（））?{
				temp?=?new?EquipInfo（）;

				temp.setEquipNa（rs.getString（“equipNa“））;
				temp.setType（rs.getString（“type“））;

				temp.setBranch（rs.getString（“branch“））;
				temp.setPrice（rs.getString（“price“））;

				temp.setRepairInfo（rs.getString（“repairInfo“））;
				list.add（temp）;

			}
			rs.close（）;
			OdbConnect.close（）;
		

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????618??2008-05-08?14:38??Detect\.classpath

?????文件????????851??2008-05-08?14:38??Detect\.project

?????文件????????330??2008-05-08?14:38??Detect\.settings\org.eclipse.jdt.core.prefs

?????文件????????364??2008-05-08?14:38??Detect\.settings\org.eclipse.jst.common.project.facet.core.prefs

?????文件????????400??2008-05-08?14:38??Detect\.settings\org.eclipse.wst.common.component

?????文件????????269??2008-05-08?14:38??Detect\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件???????4039??2008-05-08?21:13??Detect\build\classes\packClass\EquipInfo.class

?????文件???????1495??2008-05-08?21:13??Detect\build\classes\packClass\OdbConnect.class

?????文件???????2394??2008-05-08?21:13??Detect\build\classes\packClass\User.class

?????文件???????2758??2008-05-09?23:51??Detect\build\classes\packServlet\ServletLogin.class

?????文件???????1755??2008-05-09?23:50??Detect\build\classes\packServlet\TFilter.class

?????文件???????4318??2008-05-08?14:41??Detect\src\packClass\EquipInfo.java

?????文件????????849??2008-05-08?14:41??Detect\src\packClass\OdbConnect.java

?????文件???????1654??2008-05-08?14:41??Detect\src\packClass\User.java

?????文件???????2148??2008-05-09?23:51??Detect\src\packServlet\ServletLogin.java

?????文件???????2007??2008-05-09?23:50??Detect\src\packServlet\TFilter.java

?????文件???????5215??2008-05-08?14:42??Detect\WebContent\css\fireEquip.css

?????文件???????1480??2008-05-08?14:42??Detect\WebContent\css\shared.css

?????文件?????225280??2008-05-08?14:39??Detect\WebContent\dbase\test.mdb

?????文件???????1574??2008-05-08?14:42??Detect\WebContent\images\arrow.gif

?????文件????????176??2008-05-08?14:42??Detect\WebContent\images\coner2.gif

?????文件????????178??2008-05-08?14:42??Detect\WebContent\images\corner1.gif

?????文件????????176??2008-05-08?14:42??Detect\WebContent\images\corner3.gif

?????文件????????178??2008-05-08?14:42??Detect\WebContent\images\corner4.gif

?????文件????????108??2008-05-08?14:42??Detect\WebContent\images\line.gif

?????文件????????286??2008-05-08?14:42??Detect\WebContent\images\linec400.gif

?????文件????????145??2008-05-08?14:42??Detect\WebContent\images\linec400d.gif

?????文件????????145??2008-05-08?14:42??Detect\WebContent\images\liner400.gif

?????文件????????286??2008-05-08?14:42??Detect\WebContent\images\liner400d.gif

?????文件?????206510??2008-05-08?14:42??Detect\WebContent\images\main.bmp

............此處省略41個文件信息