package?dao;

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

import?db.DBService;
import?model.Flower;
import?model.Manager;

public?class?FlowerDao?{
	public?void?save（Flower?f）{
		String?sql=“insert?into?flowers?values?（default‘“+f.getFno（）+“‘‘“+f.getFname（）+“‘“
				+?“‘“+f.getFkind（）+“‘‘“+f.getPrice（）+“‘‘“+f.getNum（）+“‘‘“+f.getPath（）+“‘‘“+f.getDescription（）+“‘）“;
		DBService.exxcuteUpdate（sql）;
	}
	
	public?void?deleteById（int?id）{
		String?sql=“delete?from?flowers?where?id=“+id+““;
		DBService.exxcuteUpdate（sql）;
	}
	
	public?void?delete（Flower?f）{
		String?sql=“delete?from?flowers?where?id=“+f.getId（）+““;

		DBService.exxcuteUpdate（sql）;
		
	}
	
	public?void?update（Flower?f）{
		String?sql=“update?flowers?set?fno=‘“+f.getFno（）+“‘fname=‘“+f.getFname（）+“‘fkind=‘“+f.getFkind（）+“‘“
				+?“price=‘“+f.getPrice（）+“‘num=‘“+f.getNum（）+“‘path=‘“+f.getPath（）+“‘description=‘“+f.getDescription（）+“‘?where?id=“+f.getId（）+““;

		System.out.println（sql）;
		DBService.exxcuteUpdate（sql）;
		
	}
	
	public?Flower?findByNo（String?no）{
			
			String?sql=“select?*?from?flowers?where?fno=‘“+no+“‘“;
			List?list=findBySQL（sql）;
			if（list.size（）>0）
				return?list.get（0）;//返回集合中的第一個(gè)元素，總共就一個(gè)元素
			else
				return?null;
		}
	public?Flower?findByName（String?name）{
		
		String?sql=“select?*?from?flowers?where?fname=‘“+name+“‘“;
		List?list=findBySQL（sql）;
		if（list.size（）>0）
			return?list.get（0）;//返回集合中的第一個(gè)元素，總共就一個(gè)元素
		else
			return?null;
	}
	
public?Flower?findById（int?id）{
		
		String?sql=“select?*?from?flowers?where?id=‘“+id+“‘“;
		List?list=findBySQL（sql）;
		if（list.size（）>0）
			return?list.get（0）;//返回集合中的第一個(gè)元素，總共就一個(gè)元素
		else
			return?null;
	}
	
	public?List?finaAll（）{
		String?sql=“select?*?from?flowers“;
		
		return?this.findBySQL（sql）;
		
	}
	
	public?List?findBySQL（String?sql）{
		Connection?conn?=?null;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		List?list?=?new?ArrayList（）;;
		try?{
			conn?=?DBService.getConn（）;
			stmt?=?DBService.openStmt（）;
			rs?=?stmt.executeQuery（sql）;//執(zhí)行查詢
			while?（rs.next（））?{//遍歷結(jié)果集
				Flower?f=new?Flower（）;
				f.setId（rs.getInt（1））;
				f.setFno（rs.getString（2））;
				f.setFname（rs.getString（3））;
				f.setFkind（rs.getString（4））;
				f.setPrice（rs.getDouble（5））;
				f.setNum（rs.getInt（6））;
				f.setPath（rs.getString（7））;
				f.setDescription（rs.getString（8））;
				list.add（f）;
			}
			//Listyer>?players?
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBService.close（rs?stmt?conn）;
			
		}
		return?list;
		
	}
	public?static?void?main（String[]?args）?{
	FlowerDao?dao=new?FlowerDao（）;
	
		
		
		System.out.println（dao.finaAll（）.get（0）.getDescription（））;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????4203??2014-01-11?19:18??041140217田貴成\flowers.sql

????..A..H.???????162??2014-01-11?19:18??041140217田貴成\~$銷售管理系統(tǒng).doc

????.....H.?????45568??2014-01-09?21:49??041140217田貴成\~WRL0001.tmp

?????文件????????398??2014-01-06?16:49??041140217田貴成\源代碼\flowers\.classpath

?????文件????????383??2014-01-06?16:36??041140217田貴成\源代碼\flowers\.project

?????文件????????598??2014-01-06?16:36??041140217田貴成\源代碼\flowers\.settings\org.eclipse.jdt.core.prefs

?????文件???????4795??2014-01-08?09:10??041140217田貴成\源代碼\flowers\bin\dao\FlowerDao.class

?????文件???????4276??2014-01-08?10:56??041140217田貴成\源代碼\flowers\bin\dao\ManagerDao.class

?????文件???????4710??2014-01-08?10:05??041140217田貴成\源代碼\flowers\bin\dao\OListDao.class

?????文件?????????90??2014-01-06?16:50??041140217田貴成\源代碼\flowers\bin\db\db.properties

?????文件???????2955??2014-01-06?16:49??041140217田貴成\源代碼\flowers\bin\db\DBService.class

?????文件???????2135??2014-01-07?17:56??041140217田貴成\源代碼\flowers\bin\model\Flower.class

?????文件???????1069??2014-01-06?16:49??041140217田貴成\源代碼\flowers\bin\model\Manager.class

?????文件???????2108??2014-01-08?10:04??041140217田貴成\源代碼\flowers\bin\model\OList.class

?????文件???????1468??2014-01-06?17:19??041140217田貴成\源代碼\flowers\bin\utils\DateUtils.class

?????文件????????484??2014-01-07?13:53??041140217田貴成\源代碼\flowers\bin\utils\FontUtil.class

?????文件????????897??2014-01-07?13:37??041140217田貴成\源代碼\flowers\bin\view\BackImage.class

?????文件???????8022??2014-01-08?09:24??041140217田貴成\源代碼\flowers\bin\view\FlowerManager.class

?????文件????????273??2014-01-06?17:51??041140217田貴成\源代碼\flowers\bin\view\KucunManager.class

?????文件???????5132??2014-01-07?14:38??041140217田貴成\源代碼\flowers\bin\view\LoginManager.class

?????文件???????2130??2014-01-08?10:45??041140217田貴成\源代碼\flowers\bin\view\MainMenu$1.class

?????文件????????693??2014-01-08?10:45??041140217田貴成\源代碼\flowers\bin\view\MainMenu$MyNode.class

?????文件???????4136??2014-01-08?10:45??041140217田貴成\源代碼\flowers\bin\view\MainMenu.class

?????文件???????4706??2014-01-08?23:03??041140217田貴成\源代碼\flowers\bin\view\OrderManager.class

?????文件???????2743??2014-01-08?10:36??041140217田貴成\源代碼\flowers\bin\view\OrderTableModel.class

?????文件???????1768??2014-01-07?20:36??041140217田貴成\源代碼\flowers\bin\view\Test.class

?????文件???????4316??2014-01-07?13:37??041140217田貴成\源代碼\flowers\bin\view\UserLogin.class

?????文件???????4950??2014-01-08?10:58??041140217田貴成\源代碼\flowers\bin\view\UserManager.class

?????文件???????2534??2014-01-07?15:18??041140217田貴成\源代碼\flowers\bin\view\UserTableModel.class

?????文件???????1813??2014-01-06?22:15??041140217田貴成\源代碼\flowers\bin\view\Welcome.class

............此處省略48個(gè)文件信息