package?gem.corporation.dao;

import?gem.corporation.entity.Activity;
import?gem.corporation.service.UserService;
import?gem.corporation.util.Application;
import?gem.corporation.util.DBConnection;

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

public?class?ActivityDao?{
	//?獲取審核成功的活動(dòng)集合
	public?List?getPagedActivities（）?{
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;
		ResultSet?rs?=?null;
		List?activities?=?new?ArrayList（）;
		try?{
			//?1、聯(lián)數(shù)據(jù)庫(kù)
			conn?=?DBConnection.getConnection（）;
			//?2、SQL語(yǔ)句
			String?sql?=?“select?*?from?activity?where?aStatus=1?or?aStatus=2?order?by?aId?desc“;
			//?3、獲得PreparedStatement對(duì)象
			prep?=?conn.prepareStatement（sql）;
			//?5、執(zhí)行SQL語(yǔ)句
			rs?=?prep.executeQuery（）;
			//?6、處理查詢結(jié)果，
			while?（rs.next（））?{
				//?對(duì)每一條記錄，==》轉(zhuǎn)換為一個(gè)新的活動(dòng)對(duì)象
				Activity?activity?=?new?Activity（）;
				activity.setaId（rs.getInt（“aId“））;
				activity.setatitle（rs.getString（“atitle“））;
				activity.setaPicture（Application.server_ip
						+?rs.getString（“aPicture“））;
				activity.setaBrief（rs.getString（“aBrief“））;
				activity.setaAddress（rs.getString（“aAddress“））;
				activity.setStartTime（rs.getString（“startTime“））;
				activity.setEndTime（rs.getString（“endTime“））;
				activity.setaNumber（rs.getInt（“aNumber“））;
				activity.setUser（new?UserService（）.getUserById（rs
						.getInt（“userId“）））;
				activity.setTribe（new?TribeDao（）.getTribeByID（rs.getInt（“tid“）））;
				activity.setaStatus（rs.getInt（“aStatus“））;
				activities.add（activity）;
			}
		}?catch?（Exception?e）?{
			//?一定要處理異常，異常的信息要存在日志文件
			//?轉(zhuǎn)化為你應(yīng)用程序的異常，再拋出
			throw?new?RuntimeException（e）;
		}?finally?{
			//?6、關(guān)閉資源
			try?{
				if?（rs?!=?null）
					rs.close（）;
				if?（prep?!=?null）
					prep.close（）;
				if?（conn?!=?null）
					conn.close（）;
			}?catch?（Exception?e）?{
				throw?new?RuntimeException（e）;
			}
		}
		return?activities;
	}

	//?分頁(yè)獲取活動(dòng)集合
	public?List?getPageActivities（int?page）?{
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;
		ResultSet?rs?=?null;
		List?activities?=?new?ArrayList（）;
		try?{
			//?1、聯(lián)數(shù)據(jù)庫(kù)
			conn?=?DBConnection.getConnection（）;
			//?2、SQL語(yǔ)句
			String?sql?=?“select?*?from?activity?where?aStatus=1?or?aStatus=2?order?by?aId?desc?limit???“;
			//?3、獲得PreparedStatement對(duì)象
			prep?=?conn.prepareStatement（sql）;
			prep.setInt（1?Application.activities_pagecount?*?page）;
			prep.setInt（2?Application.activities_pagecount）;
			//?5、執(zhí)行SQL語(yǔ)句
			rs?=?prep.executeQuery（）;
			//?6、處理查詢結(jié)果，
			while?（rs.next（））?{
				//?對(duì)每一條記錄，==》轉(zhuǎn)換為一個(gè)新的活動(dòng)對(duì)象
				Activity?activity?=?new?Activity（）;
				activity.setaId（rs.getInt（“aId“））;
				activity.setatitle（rs.getString（“atitle“））;
				activity.setaPicture（Application.server_ip
						+?rs.getString（“aPicture“））;
				activity.setaBrief（rs.ge

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\
?????文件???????29874??2016-05-26?09:36??基于Android平臺(tái)的校園App源碼\corporation.sql
?????文件?????????883??2016-04-09?23:45??基于Android平臺(tái)的校園App源碼\Corporation\.classpath
?????文件????????1044??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.project
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\.settings\
?????文件?????????503??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\.jsdtscope
?????文件?????????364??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\org.eclipse.jdt.core.prefs
?????文件?????????485??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\org.eclipse.wst.common.component
?????文件?????????345??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-03-15?17:56??基于Android平臺(tái)的校園App源碼\Corporation\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\
?????文件???????17691??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\ActivityDao.class
?????文件????????6475??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\Activity_ApplicationDao.class
?????文件????????5005??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\Activity_FavorDao.class
?????文件????????5813??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\ConcernDao.class
?????文件????????9034??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\School_InformationDao.class
?????文件???????13232??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\TribeDao.class
?????文件????????8137??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\Tribe_ApplicationDao.class
?????文件????????4032??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\Tribe_FavorDao.class
?????文件????????8578??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\dao\UserDao.class
?????目錄???????????0??2016-06-08?09:32??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\entity\
?????文件????????3758??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\entity\Activity.class
?????文件????????2045??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\entity\Activity_Application.class
?????文件????????1965??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\entity\Activity_Comment.class
?????文件????????2021??2016-05-26?09:19??基于Android平臺(tái)的校園App源碼\Corporation\build\classes\gem\corporation\entity\Activity_Favor.class
............此處省略1590個(gè)文件信息