package?com.codecore.dao;

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

import?com.codecore.dbutil.DBConn;
import?com.codecore.entity.Blog;
import?com.codecore.entity.UserInfo;

/**
?*?@version1.0
?*?@author?Vincent
?*?和關(guān)注頁相關(guān)的DAO類
?*/
public?class?AttentionDao?{
	?
	//添加關(guān)注
	public?boolean?addAttention（final?int?uid?final?int?fid）?{
		DBConn?dbConn?=?new?DBConn（）;
		String?sqlInsert?=?“insert?into?friends?（f_uid?f_gid?f_state）?values?（?????）“;
		String?sqlUpdate?=?“update?friends?set?f_state=2?where?f_uid=??and?f_gid=?“;
		int?affected?=?0;
		if?（isAttention2（uid?fid）==true）?{
			if?（isAttention（uid?fid）==true）?{
				affected?=?dbConn.execOther（sqlInsert?new?object[]?{
						uid?fid?1}）;
			}?else
				affected?=?dbConn.execOther（sqlUpdate?new?object[]?{
						fid?uid?}）;
		}
		return?affected?>?0???true?:?false;
	}

	//?判斷uid是否可以加fid為關(guān)注只需判斷fid是否已經(jīng)加uid關(guān)注
	private?static?boolean?isAttention（final?int?uid?final?int?fid）?{
		DBConn?dbConn?=?new?DBConn（）;
		String?sql?=?“select?*?from?friends?where?f_uid=??and?f_gid=?“;
		ResultSet?rs?=?dbConn.execQuery（sql?new?object[]?{?fid?uid?}）;
		boolean?flag?=?false;
		try?{
			if?（rs.next（））?{
				flag?=?false;
			}?else
				flag?=?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			dbConn.closeConn（）;
		}
		return?flag;
	}

	/////------------判斷uid是否已經(jīng)關(guān)注fid--------/////////////
	private?static?boolean?isAttention2（final?int?uid?final?int?fid）?{
		DBConn?dbConn?=?new?DBConn（）;
		String?sql?=?“select?*?from?friends?where?f_uid=??and?f_gid=?“;
		ResultSet?rs?=?dbConn.execQuery（sql?new?object[]?{?uid?fid}）;
		boolean?flag?=?false;
		try?{
			if?（rs.next（））?{
				flag?=?false;//已關(guān)注
			}?else
				flag?=?true;//未關(guān)注
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			dbConn.closeConn（）;
		}
		return?flag;
	}

	//?統(tǒng)計關(guān)注人數(shù)
	public?long?accountAttention（final?int?id）?{
		DBConn?dbConn?=?new?DBConn（）;
		String?sql?=?“select?count（*）?from?friends?where?（f_uid=?）?or?（f_gid=??and?f_state=2）“;
		//select?count（*）?from?friends?where?（f_uid=（select?u_id?from?userinfo?where?u_id=??）?and?f_state=1）?or?（f_uid=（select?u_id?from?userinfo?where?u_id=??）?and?f_state=2）
		
		ResultSet?rs?=?dbConn.execQuery（sql?new?object[]?{?id?id?}）;
		try?{
			rs.next（）;
			long?num?=?Long.parseLong（rs.getString（“count（*）“））;
			return?num;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			return?0;
		}?finally?{
			dbConn.closeConn（）;
		}
	}

	//?獲取當(dāng)前用戶u_id?關(guān)注人信息
	public?List?getAttention（final?int?id）?{
		List?lstInfos?=?new?ArrayList（）;
		String?sql?=?“SELECT?*?from?userinfo?where?u_id=?“?+
				“any?（select?f_gid?from?friends?where?（f_uid=（select?u_id?from?userinfo?where?u_id=?）?and?“?+
				“f_state=1）?o

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

?????文件????????671??2017-02-10?09:12??CodecoreMicroblog\.classpath

?????文件????????324??2011-07-19?12:20??CodecoreMicroblog\.mymetadata

?????文件???????1760??2017-02-10?09:26??CodecoreMicroblog\.project

?????文件????????500??2011-06-28?22:17??CodecoreMicroblog\.settings\.jsdtscope

?????文件????????364??2017-02-10?09:05??CodecoreMicroblog\.settings\org.eclipse.jdt.core.prefs

?????文件????????513??2017-02-10?09:26??CodecoreMicroblog\.settings\org.eclipse.wst.common.component

?????文件????????219??2017-02-10?09:06??CodecoreMicroblog\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-06-28?22:17??CodecoreMicroblog\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-06-28?22:17??CodecoreMicroblog\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????10749??2011-07-13?12:59??CodecoreMicroblog\src\com\codecore\dao\AttentionDao.java

?????文件???????2959??2011-07-09?11:13??CodecoreMicroblog\src\com\codecore\dao\BlogPublish.java

?????文件???????2133??2011-07-09?11:15??CodecoreMicroblog\src\com\codecore\dao\CancelFollowingDao.java

?????文件???????3471??2011-07-11?20:21??CodecoreMicroblog\src\com\codecore\dao\CollectDao.java

?????文件???????1739??2011-07-09?11:17??CodecoreMicroblog\src\com\codecore\dao\CommentDao.java

?????文件????????623??2011-07-09?11:17??CodecoreMicroblog\src\com\codecore\dao\CountUser.java

?????文件???????1296??2011-07-13?20:51??CodecoreMicroblog\src\com\codecore\dao\FansDao.java

?????文件???????1381??2011-07-09?11:19??CodecoreMicroblog\src\com\codecore\dao\FollowingDao.java

?????文件???????1878??2011-07-11?10:40??CodecoreMicroblog\src\com\codecore\dao\FriendsDao.java

?????文件???????1242??2011-07-09?11:23??CodecoreMicroblog\src\com\codecore\dao\InterestBlogDao.java

?????文件???????1299??2011-07-09?11:24??CodecoreMicroblog\src\com\codecore\dao\InterestDao.java

?????文件???????1169??2011-07-09?11:25??CodecoreMicroblog\src\com\codecore\dao\MyBlogDao.java

?????文件???????2811??2011-07-15?15:47??CodecoreMicroblog\src\com\codecore\dao\RegisterDao.java

?????文件???????7424??2011-07-13?20:22??CodecoreMicroblog\src\com\codecore\dao\SearchDao.java

?????文件???????2342??2011-07-12?21:02??CodecoreMicroblog\src\com\codecore\dao\UploadFaceDao.java

?????文件???????3805??2011-07-15?20:11??CodecoreMicroblog\src\com\codecore\dao\UserDao.java

?????文件????????943??2011-06-28?22:20??CodecoreMicroblog\src\com\codecore\dbutil\Config.java

?????文件????????151??2017-02-09?16:47??CodecoreMicroblog\src\com\codecore\dbutil\dbconfig.properties

?????文件???????2870??2011-07-07?20:03??CodecoreMicroblog\src\com\codecore\dbutil\DBConn.java

?????文件???????1356??2011-07-09?11:35??CodecoreMicroblog\src\com\codecore\entity\Blog.java

?????文件???????1111??2011-07-10?15:42??CodecoreMicroblog\src\com\codecore\entity\Collect.java

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