有详细设计,功能包括好友、粉丝、关注、发帖、转发、评论、收藏、搜索等。包含有相关说明文档,新手学习用
代码片段和文件信息
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 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.settingsorg.eclipse.jdt.core.prefs
文件 513 2017-02-10 09:26 CodecoreMicroblog.settingsorg.eclipse.wst.common.component
文件 219 2017-02-10 09:06 CodecoreMicroblog.settingsorg.eclipse.wst.common.project.facet.core.xml
文件 49 2011-06-28 22:17 CodecoreMicroblog.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2011-06-28 22:17 CodecoreMicroblog.settingsorg.eclipse.wst.jsdt.ui.superType.name
文件 10749 2011-07-13 12:59 CodecoreMicroblogsrccomcodecoredaoAttentionDao.java
文件 2959 2011-07-09 11:13 CodecoreMicroblogsrccomcodecoredaoBlogPublish.java
文件 2133 2011-07-09 11:15 CodecoreMicroblogsrccomcodecoredaoCancelFollowingDao.java
文件 3471 2011-07-11 20:21 CodecoreMicroblogsrccomcodecoredaoCollectDao.java
文件 1739 2011-07-09 11:17 CodecoreMicroblogsrccomcodecoredaoCommentDao.java
文件 623 2011-07-09 11:17 CodecoreMicroblogsrccomcodecoredaoCountUser.java
文件 1296 2011-07-13 20:51 CodecoreMicroblogsrccomcodecoredaoFansDao.java
文件 1381 2011-07-09 11:19 CodecoreMicroblogsrccomcodecoredaoFollowingDao.java
文件 1878 2011-07-11 10:40 CodecoreMicroblogsrccomcodecoredaoFriendsDao.java
文件 1242 2011-07-09 11:23 CodecoreMicroblogsrccomcodecoredaoInterestBlogDao.java
文件 1299 2011-07-09 11:24 CodecoreMicroblogsrccomcodecoredaoInterestDao.java
文件 1169 2011-07-09 11:25 CodecoreMicroblogsrccomcodecoredaoMyBlogDao.java
文件 2811 2011-07-15 15:47 CodecoreMicroblogsrccomcodecoredaoRegisterDao.java
文件 7424 2011-07-13 20:22 CodecoreMicroblogsrccomcodecoredaoSearchDao.java
文件 2342 2011-07-12 21:02 CodecoreMicroblogsrccomcodecoredaoUploadFaceDao.java
文件 3805 2011-07-15 20:11 CodecoreMicroblogsrccomcodecoredaoUserDao.java
文件 943 2011-06-28 22:20 CodecoreMicroblogsrccomcodecoredbutilConfig.java
文件 151 2017-02-09 16:47 CodecoreMicroblogsrccomcodecoredbutildbconfig.properties
文件 2870 2011-07-07 20:03 CodecoreMicroblogsrccomcodecoredbutilDBConn.java
文件 1356 2011-07-09 11:35 CodecoreMicroblogsrccomcodecoreentityBlog.java
文件 1111 2011-07-10 15:42 CodecoreMicroblogsrccomcodecoreentityCollect.java
............此处省略267个文件信息
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是否已经加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是否已经关注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;
}
// 统计关注人数
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
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 671 2017-02-10 09:12 CodecoreMicroblog.classpath
文件 324 2011-07-19 12:20 CodecoreMicroblog.myme
文件 1760 2017-02-10 09:26 CodecoreMicroblog.project
文件 500 2011-06-28 22:17 CodecoreMicroblog.settings.jsdtscope
文件 364 2017-02-10 09:05 CodecoreMicroblog.settingsorg.eclipse.jdt.core.prefs
文件 513 2017-02-10 09:26 CodecoreMicroblog.settingsorg.eclipse.wst.common.component
文件 219 2017-02-10 09:06 CodecoreMicroblog.settingsorg.eclipse.wst.common.project.facet.core.xm
文件 49 2011-06-28 22:17 CodecoreMicroblog.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2011-06-28 22:17 CodecoreMicroblog.settingsorg.eclipse.wst.jsdt.ui.superType.name
文件 10749 2011-07-13 12:59 CodecoreMicroblogsrccomcodecoredaoAttentionDao.java
文件 2959 2011-07-09 11:13 CodecoreMicroblogsrccomcodecoredaoBlogPublish.java
文件 2133 2011-07-09 11:15 CodecoreMicroblogsrccomcodecoredaoCancelFollowingDao.java
文件 3471 2011-07-11 20:21 CodecoreMicroblogsrccomcodecoredaoCollectDao.java
文件 1739 2011-07-09 11:17 CodecoreMicroblogsrccomcodecoredaoCommentDao.java
文件 623 2011-07-09 11:17 CodecoreMicroblogsrccomcodecoredaoCountUser.java
文件 1296 2011-07-13 20:51 CodecoreMicroblogsrccomcodecoredaoFansDao.java
文件 1381 2011-07-09 11:19 CodecoreMicroblogsrccomcodecoredaoFollowingDao.java
文件 1878 2011-07-11 10:40 CodecoreMicroblogsrccomcodecoredaoFriendsDao.java
文件 1242 2011-07-09 11:23 CodecoreMicroblogsrccomcodecoredaoInterestBlogDao.java
文件 1299 2011-07-09 11:24 CodecoreMicroblogsrccomcodecoredaoInterestDao.java
文件 1169 2011-07-09 11:25 CodecoreMicroblogsrccomcodecoredaoMyBlogDao.java
文件 2811 2011-07-15 15:47 CodecoreMicroblogsrccomcodecoredaoRegisterDao.java
文件 7424 2011-07-13 20:22 CodecoreMicroblogsrccomcodecoredaoSearchDao.java
文件 2342 2011-07-12 21:02 CodecoreMicroblogsrccomcodecoredaoUploadFaceDao.java
文件 3805 2011-07-15 20:11 CodecoreMicroblogsrccomcodecoredaoUserDao.java
文件 943 2011-06-28 22:20 CodecoreMicroblogsrccomcodecoredbutilConfig.java
文件 151 2017-02-09 16:47 CodecoreMicroblogsrccomcodecoredbutildbconfig.properties
文件 2870 2011-07-07 20:03 CodecoreMicroblogsrccomcodecoredbutilDBConn.java
文件 1356 2011-07-09 11:35 CodecoreMicroblogsrccomcodecoreentityBlog.java
文件 1111 2011-07-10 15:42 CodecoreMicroblogsrccomcodecoreentityCollect.java
............此处省略267个文件信息
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)