package?com.RainBow.dao;

import?java.sql.ResultSet;

import?javax.servlet.jsp.tagext.TryCatchFinally;

import?com.RainBow.dbutil.DBConn;
//添加好友
public?class?AddFriendsDao?{
	public?int?addFriendsDao（int?u_idint?f_user_id）
	{
		
	???int?affectedRows=0;
	???//連接數據庫
	???DBConn?dbconn=new?DBConn（）;
	???try?{
		??//首先判斷是不是已經是好友了
		???String?isAlreadyFriend=“select?*?from?friends?where?u_id=??and?f_user_id=?“;
		???//執行查詢并將查詢結果返回給結果集
		???ResultSet?rs=dbconn.execQuery（isAlreadyFriendnew?object[]{u_idf_user_id}）;
		???if（rs.next（）==false）
		???{
			???//非好友，添加為好友
			???String?strSQL=“insert?into?friends?values（null??）“;
			???affectedRows=dbconn.execOther（strSQL?new?object[]{u_idf_user_id}）;
		???}else
		???{
			???//已是好友，affectedRows為-1
			???affectedRows=-1;

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

?????文件????????529??2011-07-04?16:01??RainBow\.classpath

?????文件????????294??2011-07-20?16:03??RainBow\.mymetadata

?????文件???????1750??2011-07-04?16:05??RainBow\.project

?????文件????????493??2011-07-04?16:01??RainBow\.settings\.jsdtscope

?????文件????????460??2011-07-13?14:19??RainBow\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2011-07-04?16:01??RainBow\.settings\org.eclipse.jdt.core.prefs

?????文件????????459??2011-07-04?16:01??RainBow\.settings\org.eclipse.wst.common.component

?????文件????????252??2011-07-04?16:01??RainBow\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-07-04?16:01??RainBow\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-07-04?16:01??RainBow\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????16956??2011-07-20?11:59??RainBow\New?Project?20110720?1159.sql

?????文件???????1025??2011-07-21?08:40??RainBow\src\com\RainBow\dao\AddFriendsDao.java

?????文件???????1087??2011-07-21?08:42??RainBow\src\com\RainBow\dao\CollectMoodDao.java

?????文件????????990??2011-07-21?08:44??RainBow\src\com\RainBow\dao\commentDao.java

?????文件???????2783??2011-07-21?08:47??RainBow\src\com\RainBow\dao\FaceDao.java

?????文件????????340??2011-07-21?08:48??RainBow\src\com\RainBow\dao\getCommentDao.java

?????文件???????1841??2011-07-21?08:52??RainBow\src\com\RainBow\dao\LoginDao.java

?????文件????????778??2011-07-21?08:54??RainBow\src\com\RainBow\dao\PublishDao.java

?????文件????????995??2011-07-21?08:58??RainBow\src\com\RainBow\dao\PwdDao.java

?????文件???????1714??2011-07-21?08:56??RainBow\src\com\RainBow\dao\RandomShowFavUser.java

?????文件???????1283??2011-07-21?08:58??RainBow\src\com\RainBow\dao\RegisterDao.java

?????文件????????563??2011-07-21?08:59??RainBow\src\com\RainBow\dao\RemoveMoodDao.java

?????文件???????1230??2011-07-21?09:01??RainBow\src\com\RainBow\dao\SearchDao.java

?????文件????????554??2011-07-21?09:02??RainBow\src\com\RainBow\dao\SearchFocusDao.java

?????文件????????528??2011-07-05?15:20??RainBow\src\com\RainBow\dao\SearchFunNumberDao.java

?????文件????????538??2011-07-11?11:29??RainBow\src\com\RainBow\dao\SearchMicroblogNumberDao.java

?????文件????????583??2011-07-21?09:05??RainBow\src\com\RainBow\dao\SearchNumberDao.java

?????文件???????5025??2011-07-21?09:11??RainBow\src\com\RainBow\dao\ShowMoodDao.java

?????文件???????1344??2011-07-08?20:29??RainBow\src\com\RainBow\dao\TransmitDao.java

?????文件????????986??2011-07-21?09:13??RainBow\src\com\RainBow\dao\UpdateDao.java

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