/**
*?@（C）Copyright?奇科計算機信息有限公司.?2010
*?@作者:?代成華
*?@創(chuàng)建時間：2015-2-10?18:05:36
?*?@文件名：Category.java
*?@描述：?用戶信息的實體類?***********************************
?*/
package?com.Action;
import?com.sql.connection.*;


import?java.sql.ResultSet;
import?java.util.ArrayList;
import??com.InfoBean.*;
	public?class?CategoryAction	{
private?int?countRow;
private?int?countPage;
private?int?currentPage;
public?int?getCountPage（）?{
return?countPage;
}
public?int?getCountRow（）?{
	return?countRow;
}
public?int?getCurrentPage（）?{
return?currentPage;
}
//描述：?根據(jù)兩個參數(shù)，判斷兩個參數(shù)是否一致，返回selected
public?String?isSelected（String?seed?String?value）?{
if?（seed.trim（）.equals（value））?{
	return?“selected“;
}?else?{
		return?““;
}
}

		//?增加一條數(shù)據(jù)
		public?void?AddCategory（CategoryInfo?model）
		{
			String?sql?=?““;
			SqlserverDBConnection?dbc?=?null;
			try?{
			dbc?=?new?SqlserverDBConnection（）;
			sql+=“insert?into?tb_category（“;
			sql+=“CategoryGUIDCategoryNameCategoryOrderCategoryDemoCategoryDescCategoryPicCategorySign“;
			sql+=“）?values?（“;
			sql+=“‘“+model.getCategoryGUID（）+“‘‘“+model.getCategoryName（）+“‘‘“+model.getCategoryOrder（）+“‘‘“+model.getCategoryDemo（）+“‘‘“+model.getCategoryDesc（）+“‘‘“+model.getCategoryPic（）+“‘‘“+model.getCategorySign（）+“‘“;
			sql+=“）“;
			dbc.executeUpdate（sql）;
			dbc.close（）;
			dbc?=?null;
			}?catch?（Exception?e）?{
			e.printStackTrace（）;
			}?finally?{
				if?（dbc?!=?null）?{
				dbc.close（）;
				dbc=null;
			}
			}
			}


		//?修改一條數(shù)據(jù)
		public?void?EditCategory（CategoryInfo?model）
		{
			String?sql?=?““;
			SqlserverDBConnection?dbc?=?null;
			try?{
			dbc?=?new?SqlserverDBConnection（）;
			sql+=“?update?tb_category?set?“;
			sql+=“CategoryName=‘“+model.getCategoryName（）+“‘CategoryOrder=‘“+model.getCategoryOrder（）+“‘CategoryDemo=‘“+model.getCategoryDemo（）+“‘CategoryDesc=‘“+model.getCategoryDesc（）+“‘CategoryPic=‘“+model.getCategoryPic（）+“‘“?;?
			sql+=“?where?CategoryGUID=‘“+model.getCategoryGUID（）+“‘“;
			dbc.executeUpdate（sql）;
			dbc.close（）;
			dbc?=?null;
			}?catch?（Exception?e）?{
			e.printStackTrace（）;
			}?finally?{
				if?（dbc?!=?null）?{
				dbc.close（）;
				dbc=null;
			}
			}
			}

		public?boolean?isInfoExist（CategoryInfo?form?String?id）
		throws?Exception?{
	boolean?flag?=?false;
	String?sql?=?““;
	ResultSet?rs?=?null;
	SqlserverDBConnection?dbc?=?null;
	try?{
		dbc?=?new?SqlserverDBConnection（ResultSet.TYPE_SCROLL_INSENSITIVE
				ResultSet.CONCUR_READ_ONLY）;
		sql?=?“select?*?from?tb_category?where?categoryName=‘“
				+?form.getCategoryName（）?+?“‘?and?CategorySign=‘“+form.getCategorySign（）+“‘“;
		if?（id?!=?null）?{
			sql?=?“select?*?from?tb_category?where?categoryName=‘“
					+?form.getCategoryName（）?+?“‘?and?CategorySign=‘“+form.getCategorySign（）+“‘?and?categoryGUID<>‘“?+?id?+?“‘“;
		}
		rs?=?dbc.executeQuery（sql）;
		while?（rs.next（））?{
			flag?=?true;
		}
		rs.close（）;
		rs?=?null;
		dbc.close（）;
		dbc?=?null;

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

?????文件????1919488??2015-03-02?17:24??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\DB\Zillion20150302.bak

?????文件?????105102??2015-02-10?21:17??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\數(shù)據(jù)庫設(shè)計\企業(yè)網(wǎng)站系統(tǒng)數(shù)據(jù)庫設(shè)計.cdb

?????文件?????105102??2015-02-10?22:24??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\數(shù)據(jù)庫設(shè)計\企業(yè)網(wǎng)站系統(tǒng)數(shù)據(jù)庫設(shè)計.CDM

?????文件???????1162??2015-02-10?21:55??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\.classpath

?????文件????????294??2015-02-10?17:34??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\.mymetadata

?????文件???????1225??2015-02-10?17:39??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\.project

?????文件???????8305??2015-03-02?16:38??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\Action\CategoryAction.java

?????文件??????12320??2015-03-02?16:38??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\Action\InformationAction.java

?????文件???????1508??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\filterUser\filterUser.java

?????文件???????4429??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\filterUser\Functions.java

?????文件????????129??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\filterUser\vssver2.scc

?????文件???????2752??2015-02-10?21:08??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\InfoBean\CategoryInfo.java

?????文件???????5662??2015-02-10?21:18??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\InfoBean\InformationInfo.java

?????文件???????6276??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\DocAfficAction.java

?????文件???????3063??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\DocAffix.java

?????文件???????7037??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\LogAction.java

?????文件???????2309??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\LogForm.java

?????文件??????22238??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\MenuAction.java

?????文件???????2763??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\MenuForm.java

?????文件???????7823??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\RoleAction.java

?????文件???????1493??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\RoleForm.java

?????文件??????11051??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\UserAction.java

?????文件???????5840??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\UserForm.java

?????文件????????371??2015-02-10?17:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\com\sys\vssver2.scc

?????文件????????287??2015-02-10?18:23??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\db.properties

?????文件???????1567??2015-03-02?16:37??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\src\log4j.properties

?????文件???????4077??2015-02-10?21:21??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\WebRoot\Guanli\category\add.jsp

?????文件???????2006??2015-02-10?21:08??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\WebRoot\Guanli\category\addcheck.jsp

?????文件????????795??2015-02-10?22:19??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\WebRoot\Guanli\category\delete.jsp

?????文件???????9899??2015-02-26?13:44??JAVA醫(yī)療科技行業(yè)企業(yè)網(wǎng)站源碼\源代碼\Zillion\WebRoot\Guanli\category\index.jsp

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