package?com.lechenggu.abgame.dao;

import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;
import?java.util.Map;

import?com.lechenggu.abgame.pojo.Game;
import?com.lechenggu.abgame.util.DBUtil;

public?class?GameDao?{
	/**
	?*?新增游戲記錄
	?*?@return?int
	?*/
	public?int?addGame（Game?g）?{
		DBUtil?db?=?new?DBUtil（）;
		String?sql?=?“insert?into?game?values（null???）“;
		Listject>?li?=?new?ArrayListject>（）;
		li.add（g.getPid（））;
		li.add（g.getPlaytime（））;
		li.add（g.getScore（））;
		return?db.update（sql?li）;
	}

	/**
	?*?玩家查詢游戲
	?*?@return?List
	?*/
	public?List?queryGame（Game?g）?{
		List?resList?=?new?ArrayList（）;
		DBUtil?db?=?new?DBUtil（）;
		String?sql?=?“select?*?from?game?where?pid=?“;
		Listject>?li?=?new?ArrayListject>（）;
		li.add（g.getPid（））;
		Listject>>?select?=?db.select（sql?li）;
		for?（int?i?=?0;?i?			Mapject>?map?=?select.get（i）;
			Game?game?=?new?Game（）;
			game.setId（（int）?map.get（“id“））;
			game.setPid（（int）?map.get（“pid“））;
			game.setScore（（int）?map.get（“score“））;
			game.setPlaytime（（Date）?map.get（“playtime“））;
			resList.add（game）;
		}
		return?resList;
	}

	/**
	?*?管理員查詢游戲記錄
	?*?@return?Listject>>
	?*/
	public?Listject>>?queryGame2（）?{
		DBUtil?db?=?new?DBUtil（）;
		String?sql?=?“select?g.playtimep.usernameg.score?from?game?g?join?player?p?on?p.id=g.pid“;
		Listject>?li?=?new?ArrayListject>（）;
		return?db.select（sql?li）;
	}

	/**
	?*?管理員查詢游戲統計
	?*?@return?Listject>>
	?*/
	public?Listject>>?queryGameStat（）?{
		DBUtil?db?=?new?DBUtil（）;
		String?sql?=?“select?p.usernamesum（g.score）?as?sumcount（*）?as?count?avg（g.score）?as?avg?from?game?g?join?player?p?on?p.id=g.pid?group?by?g.pid“;
		Listject>?li?=?new?ArrayListject>（）;
		return?db.select（sql?li）;
	}
}

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

?????文件????????566??2017-09-01?16:56??20170829_AngryBird\.classpath

?????文件????????394??2017-09-01?16:56??20170829_AngryBird\.project

?????文件?????????57??2017-09-01?16:56??20170829_AngryBird\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2017-09-01?16:56??20170829_AngryBird\.settings\org.eclipse.jdt.core.prefs

?????文件????????106??2017-09-01?16:56??20170829_AngryBird\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件????????232??2017-09-01?16:56??20170829_AngryBird\.settings\org.eclipse.wst.xsl.core.prefs

?????文件???????3179??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\dao\GameDao.class

?????文件???????4225??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\dao\PlayerDao.class

?????文件???????9530??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\main\AdminManager.class

?????文件???????3511??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\main\DataInit.class

?????文件???????3226??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\main\GameMain.class

?????文件???????4713??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\main\PlayerManager.class

?????文件???????5120??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\main\SysManager.class

?????文件???????1084??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\Admin.class

?????文件???????1350??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\Bird.class

?????文件???????2086??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\BlackBird.class

?????文件???????2075??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\BlueBird.class

?????文件???????1565??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\Game.class

?????文件???????1855??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\Pig.class

?????文件???????1912??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\Player.class

?????文件???????2072??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\pojo\RedBird.class

?????文件???????2054??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\shuru\InputHelper.class

?????文件???????3497??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\ui\Menus.class

?????文件???????1500??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\DateUtil.class

?????文件???????4881??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\DBUtil.class

?????文件???????3481??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\FileRW.class

?????文件????????944??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\StringUtil.class

?????文件???????1100??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\TestEnum.class

?????文件???????2050??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\ValidationUtil.class

?????文件???????1200??2017-09-01?16:56??20170829_AngryBird\bin\com\lechenggu\abgame\util\ValidEnum.class

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