91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

微博系統(tǒng)(Java源碼,servlet+jsp),適用于初學者,比較簡陋,但一看就明白,對于初學者了解serlet,jsp具有教學作用

資源截圖

代碼片段和文件信息

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
?*?和關注頁相關的DAO類
?*/
public?class?AttentionDao?{
?
//添加關注
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為關注只需判斷fid是否已經(jīng)加uid關注
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)關注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;//已關注
}?else
flag?=?true;//未關注
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}?finally?{
dbConn.closeConn();
}
return?flag;
}

//?統(tǒng)計關注人數(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();
}
}

//?獲取當前用戶u_id?關注人信息
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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-14?14:52??CodeCore微博系統(tǒng)\
?????文件???????42558??2014-01-17?16:33??CodeCore微博系統(tǒng)\CodecoreMicroblog詳細設計說明書.docx
?????文件???????19584??2011-07-19?13:48??CodeCore微博系統(tǒng)\codecore.sql
?????目錄???????????0??2012-06-08?10:22??CodeCore微博系統(tǒng)\項目代碼\
?????目錄???????????0??2017-03-14?14:44??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\
?????文件????????3285??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.classpath
?????目錄???????????0??2017-03-14?14:52??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.myeclipse\
?????文件?????????324??2011-07-19?12:20??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.mymetadata
?????文件????????1760??2017-03-14?11:41??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.project
?????目錄???????????0??2017-03-14?11:44??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\
?????文件?????????500??2011-06-28?22:17??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\.jsdtscope
?????文件?????????187??2011-07-06?16:14??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.core.resources.prefs
?????文件?????????670??2017-03-14?11:40??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.jdt.core.prefs
?????文件?????????117??2017-03-14?11:44??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.jst.j2ee.ejb.annotations.xdoclet.prefs
?????文件?????????488??2017-03-14?14:46??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.wst.common.component
?????文件?????????292??2017-03-14?11:44??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2011-06-28?22:17??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-06-28?22:17??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????86??2017-03-14?11:44??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\.settings\org.eclipse.wst.ws.service.policy.prefs
?????目錄???????????0??2017-03-14?11:36??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\
?????目錄???????????0??2012-06-08?10:22??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\meta-INF\
?????文件??????????36??2011-06-28?22:17??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\meta-INF\MANIFEST.MF
?????文件????????3628??2011-07-15?19:48??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\MyJsp.jsp
?????目錄???????????0??2017-03-14?11:36??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\
?????目錄???????????0??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\codecore\
?????目錄???????????0??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\codecore\dao\
?????文件????????9840??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\codecore\dao\AttentionDao.class
?????文件????????3695??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\codecore\dao\BlogPublish.class
?????文件????????2334??2017-03-14?14:31??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\WEB-INF\classes\com\codecore\dao\CancelFollowingDao.class
............此處省略268個文件信息

評論

共有 條評論