package?com.accp.myShopping.llg.car.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?com.accp.myShopping.llg.car.entity.GoodsBean;
import?com.accp.myShopping.util.DatabaseUtil;
public?class?GoodsDao?{

	private?DatabaseUtil?db=?new?DatabaseUtil（）;
	
	//??搜索產品?返回商品ID
	public?int?findGoodsBeanByName（String?strString?name）{
		String?sql=“select?*?from?goods?where?G_typeid?in（“+str+“）?and?keywords?like?‘%“+name+“%‘“;
			List?list=?this.getGoodsBeans（sql）;
			if（list!=null&&list.size（）>0）{
				GoodsBean?g?=list.get（0）;
				return?Integer.parseInt（g.getG_id（））;
			}else{
				return?0;
			}
	}
	

	
	/**
	?*??根據商品類型返回商品列表
	?*?*/
	public?List?findGood

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

?????文件???????1286??2010-01-23?19:17??myShopping\.classpath

?????文件????????303??2010-02-04?20:53??myShopping\.mymetadata

?????文件???????1228??2010-03-31?09:05??myShopping\.project

?????文件????????291??2010-01-23?23:02??myShopping\.settings\org.eclipse.core.resources.prefs

?????文件?????????83??2010-01-23?11:57??myShopping\.settings\org.eclipse.core.runtime.prefs

?????文件???????3602??2010-01-23?23:08??myShopping\src\com\accp\myShopping\llg\car\dao\GoodsDao.java

?????文件???????6810??2010-01-23?10:27??myShopping\src\com\accp\myShopping\llg\car\dao\OrderDao.java

?????文件???????1945??2010-01-10?23:31??myShopping\src\com\accp\myShopping\llg\car\dao\PageDao.java

?????文件???????1520??2010-01-18?10:13??myShopping\src\com\accp\myShopping\llg\car\dao\ShoppingCarDao.java

?????文件???????2756??2010-03-31?10:44??myShopping\src\com\accp\myShopping\llg\car\entity\GoodsBean.java

?????文件???????1494??2010-01-13?14:24??myShopping\src\com\accp\myShopping\llg\car\entity\OrderBean.java

?????文件????????829??2010-01-18?21:50??myShopping\src\com\accp\myShopping\llg\car\entity\OrderTempBean.java

?????文件????????610??2010-03-31?12:11??myShopping\src\com\accp\myShopping\llg\car\entity\ShoppingBean.java

?????文件???????1624??2010-01-14?03:00??myShopping\src\com\accp\myShopping\llg\comment\dao\GoodsAssessDao.java

?????文件???????1487??2010-01-14?01:34??myShopping\src\com\accp\myShopping\llg\comment\entity\GoodsAssessBean.java

?????文件???????4314??2010-01-20?23:07??myShopping\src\com\accp\myShopping\llg\goods\dao\GoodsDao.java

?????文件???????2758??2010-01-19?00:17??myShopping\src\com\accp\myShopping\llg\goods\entity\GoodsBean.java

?????文件????????486??2010-01-19?00:16??myShopping\src\com\accp\myShopping\llg\goods\entity\GoodsType.java

?????文件????????446??2010-01-19?00:55??myShopping\src\com\accp\myShopping\llg\goods\entity\SuppBean.java

?????文件???????1985??2010-01-17?22:30??myShopping\src\com\accp\myShopping\llg\user\dao\JavaMailDao.java

?????文件???????2339??2010-01-12?22:41??myShopping\src\com\accp\myShopping\llg\user\dao\UserAddressDao.java

?????文件???????2354??2010-01-20?23:39??myShopping\src\com\accp\myShopping\llg\user\dao\UserDao.java

?????文件???????1998??2010-01-11?23:30??myShopping\src\com\accp\myShopping\llg\user\entity\UserAddressBean.java

?????文件???????2164??2010-01-11?02:14??myShopping\src\com\accp\myShopping\llg\user\entity\UserBean.java

?????文件???????2657??2010-01-18?22:57??myShopping\src\com\accp\myShopping\util\DatabaseUtil.java

?????文件???????5118??2010-01-23?11:13??myShopping\src\com\accp\myShopping\wjj\dao\admindao.java

?????文件???????2110??2010-01-23?11:13??myShopping\src\com\accp\myShopping\wjj\dao\GoodsAssessdao.java

?????文件???????3462??2010-01-23?11:13??myShopping\src\com\accp\myShopping\wjj\dao\goodsDao.java

?????文件???????5695??2010-01-23?11:13??myShopping\src\com\accp\myShopping\wjj\dao\order_processingdao.java

?????文件???????1243??2010-01-23?11:13??myShopping\src\com\accp\myShopping\wjj\dao\pageBean.java

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