package?com.zhanglihui.dao;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.zhanglihui.data.DataConnect;
import?com.zhanglihui.model.Category;

public?class?CategoryDao?{
	DataConnect?dc?=?new?DataConnect（）;
	Statement?stat=null;
	ResultSet?rs=null;
	PreparedStatement?ps=null;
	
	public?int?getCategoryCount（）{
		return?dc.getRowCount（“category“）;
	}
	
	public?int?delCategory（String?categoryID）{
		String?sql=“delete?from?category?where?categoryID=‘“?+categoryID+“‘“;
		return?dc.update（sql）;
	}
	
	public?boolean?isContainCategory（String?categoryID）{
		stat=dc.getStat（）;
		String?sql=“select?count（*）?from?category?where?categoryid=‘“?+categoryID+“‘“;
		try?{
			rs=stat.executeQuery（sql）;
			while（rs.next（））{
				if（rs.getInt（1）<=0）
					return?false;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			dc.close（）;
		}
		return?true;
	}
	
	public?List?selectCategory（int?pageNow）?{
		stat=dc.getStat（）;
		return?addToList（pageNow）;
	}
	
	public?List?addToList（int?pageNow）{
		List?categories=?new?ArrayList（）;
		String?sql=“select?*?from?category?limit?“+（pageNow-1）*5+“5“;
		try?{
			rs=stat.executeQuery（sql）;
			while（rs.next（））{
				Category?category?=?new?Category（rs.getInt（“categoryid“）rs.getString（“name“）rs.getString（“remark“））;
				categories.add（category）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?categories;
	}

	public?void?update（String?categoryID?String?name?String?remark）?{
		//String?sql=“update?category?set?name=?remark=??where?categoryid=‘“+categoryID+“‘“;
		String?sql=“update?category?set?name=‘“+name+“‘remark=‘“+remark+“‘?where?categoryid=‘“?+categoryID+“‘“;
		stat=dc.getStat（）;
		try?{
			stat.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			dc.close（）;
		}
	}

	public?void?addCategory（String?categoryID?String?name?String?remark）?{
		String?sql=“insert?into?category（categoryidnameremark）?values（???）“;
		ps=dc.getPs（sql）;
		try?{
			ps.setString（1?categoryID）;
			ps.setString（2?name）;
			ps.setString（3?remark）;
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			dc.close（）;
		}
	}
	
}

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

?????文件????????529??2011-09-20?11:15??SCM_BS\.classpath

?????文件????????291??2011-09-24?22:08??SCM_BS\.mymetadata

?????文件???????1749??2011-09-20?11:23??SCM_BS\.project

?????文件????????493??2011-09-20?11:15??SCM_BS\.settings\.jsdtscope

?????文件????????270??2011-09-28?08:50??SCM_BS\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2011-09-20?11:15??SCM_BS\.settings\org.eclipse.jdt.core.prefs

?????文件????????456??2011-09-20?11:15??SCM_BS\.settings\org.eclipse.wst.common.component

?????文件????????252??2011-09-20?11:16??SCM_BS\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-09-20?11:16??SCM_BS\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-09-20?11:16??SCM_BS\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2440??2011-09-22?15:24??SCM_BS\src\com\zhanglihui\dao\CategoryDao.java

?????文件???????1441??2011-09-26?16:05??SCM_BS\src\com\zhanglihui\dao\PoitemDao.java

?????文件???????1869??2011-09-26?11:33??SCM_BS\src\com\zhanglihui\dao\PomainDao.java

?????文件???????5349??2011-09-29?08:54??SCM_BS\src\com\zhanglihui\dao\ProductDao.java

?????文件???????1325??2011-09-21?15:23??SCM_BS\src\com\zhanglihui\dao\SCMUserDao.java

?????文件???????1328??2011-09-26?15:53??SCM_BS\src\com\zhanglihui\dao\SoitemDao.java

?????文件???????1746??2011-09-26?11:36??SCM_BS\src\com\zhanglihui\dao\SomainDao.java

?????文件???????6259??2011-09-27?08:36??SCM_BS\src\com\zhanglihui\dao\StockDao.java

?????文件???????4445??2011-09-28?15:56??SCM_BS\src\com\zhanglihui\dao\StockInInfoDao.java

?????文件???????4435??2011-09-28?16:12??SCM_BS\src\com\zhanglihui\dao\StockOutInfoDao.java

?????文件???????1961??2011-09-26?11:04??SCM_BS\src\com\zhanglihui\dao\StockRecordDao.java

?????文件???????2636??2011-09-22?11:26??SCM_BS\src\com\zhanglihui\data\DataConnect.java

?????文件????????843??2011-09-22?15:31??SCM_BS\src\com\zhanglihui\filter\EncodingFilter.java

?????文件???????1166??2011-09-27?11:00??SCM_BS\src\com\zhanglihui\filter\UserFilter.java

?????文件????????680??2011-09-21?09:55??SCM_BS\src\com\zhanglihui\model\Category.java

?????文件???????1816??2011-09-21?08:21??SCM_BS\src\com\zhanglihui\model\CheckStockInfo.java

?????文件???????1312??2011-09-23?09:49??SCM_BS\src\com\zhanglihui\model\Poitem.java

?????文件???????4073??2011-09-22?20:54??SCM_BS\src\com\zhanglihui\model\Pomain.java

?????文件???????1893??2011-09-27?16:47??SCM_BS\src\com\zhanglihui\model\Product.java

?????文件???????1121??2011-09-21?10:17??SCM_BS\src\com\zhanglihui\model\SCMUser.java

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