-
大小: 3.98MB文件類型: .zip金幣: 2下載: 1 次發(fā)布日期: 2025-03-21
- 語言: Java
- 標簽: 微博系統(tǒng)??Java??servlet+jsp??
資源簡介
微博系統(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\.myme
?????文件????????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.xm
?????文件??????????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\me
?????文件??????????36??2011-06-28?22:17??CodeCore微博系統(tǒng)\項目代碼\CodecoreMicroblog\WebRoot\me
?????文件????????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個文件信息
評論
共有 條評論