資源簡介
純java，jsp，servlet，mysql搭建微博源碼，帶有數(shù)據(jù)庫腳本，下載即可運(yùn)行。
代碼片段和文件信息
package?org.microblog.dao;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?org.microblog.po.Comment;
import?org.microblog.po.User;
import?org.microblog.util.DBConn;
public?class?CommentDao?{
public?int?addComment（final?Comment?comment）{
try?{
int?u_id?=?comment.getU_id（）;
int?m_id?=?comment.getM_id（）;
int?u_id2?=?comment.getU_id2（）;
String?c_content?=?comment.getC_content（）;
String?c_comtime?=?comment.getC_comtime（）;
String?strSQL?=“insert?into?comment?（c_idu_idu_id2m_idc_contentc_comtime）?values（null?????）“;
????object[]?params?=?new?object[]{u_idu_id2m_idc_contentc_comtime};
//調(diào)用DBConn，傳送到數(shù)據(jù)庫
????DBConn?dbConn=?new?DBConn（）;
????int?AffectedRows?=?dbConn.execOther（strSQL?params）;
????dbConn.closeConn（）;
????return?AffectedRows;
}?catch?（Exception?e）?{
return?0;
}
}
public?List?getCommentListByBlogId（final?int?m_id）{
List?commentList?=?new?ArrayList（）;
?String?strSQL=“select?*?from?comment?where?m_id?=?“;
//調(diào)用DBConn，傳送到數(shù)據(jù)庫
?DBConn?dbConn=?new?DBConn（）;
?ResultSet?rs=dbConn.execQuery（strSQL?new?object[]{m_id}）;
try?{
while（rs.next（））?{
Comment?comm?=?new?Comment（）;
comm.setU_id2（rs.getInt（“u_id2“））;//
comm.setC_content（rs.getString（“c_content“））;
comm.setU_id（rs.getInt（“u_id“））;
comm.setM_id（rs.getInt（“m_id“））;
comm.setC_comtime（rs.getString（“c_comtime“））;
comm.setC_id（rs.getInt（“c_id“））;
commentList.add（comm）;
}
return?commentList;
?
}?catch?（Exception?e）?{
return?null;
}finally{
try?{
//關(guān)閉數(shù)據(jù)庫
rs.close（）;
dbConn.closeConn（）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
}
}
public?User?getCommentUserByCommentId（final?int?u_id）{
try?{
String?strSQL=“select?*?from?users?where?u_id=“+u_id;
//調(diào)用DBConn，傳送到數(shù)據(jù)庫
?DBConn?dbConn=?new?DBConn（）;
?ResultSet?rs=dbConn.execQuery（strSQL?new?object[]{}）;
?User?user?=?new?User（）;
?if（rs.next（））?{
user.setU_avatar（rs.getString（“u_avatar“））;
user.setU_nickname（rs.getString（“u_nickname“））;
user.setU_email（null）;
user.setU_birthday（null）;
user.setU_gender（null）;
user.setU_info（null）;
user.setU_locate（null）;
user.setU_msn（null）;
user.setU_password（null）;
user.setU_qq（null）;
user.setU_realname（null）;
user.setU_regdate（null）;
user.setU_remark（null）;
}
?dbConn.closeConn（）;
?return?user;
}?catch?（Exception?e）?{
return?null;
}
}
public?long?getCommentAmountByBlogId（final?int?m_id?）{
String?sql_getCommentAmountByBlogId=“SELECT?count（*）?FROM?‘microblog‘.‘comment‘?where?m_id?=??“;
DBConn?dbConn?=?new?DBConn（）;
ResultSet?rs?=?dbConn.execQuery（sql_getCommentAmountByBlogId?new?object[]{m_id}）;
long?amount?=?0;
try?{
while（rs.next ?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????529??2011-07-10?16:23??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.classpath
?????文件????????300??2013-05-27?09:52??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.myme
?????文件???????1752??2011-06-30?16:24??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.project
?????文件????????493??2011-06-29?17:27??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\.jsdtscope
?????文件?????????88??2013-05-27?09:54??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.core.resources.prefs
?????文件????????629??2011-07-10?15:04??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.jdt.core.prefs
?????文件????????465??2011-06-29?17:27??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.wst.common.component
?????文件????????252??2011-06-29?17:27??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2011-06-29?17:27??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2011-06-29?17:27??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????3359??2011-07-04?15:03??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\CommentDao.java
?????文件???????3134??2011-07-07?20:25??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\FavoriteDao.java
?????文件??????12101??2011-07-08?20:25??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\FriendDao.java
?????文件???????9038??2011-07-14?18:16??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\MicroBlogDao.java
?????文件???????2872??2011-07-10?18:44??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\NotifyDao.java
?????文件??????15939??2011-07-15?14:59??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\dao\UserDao.java
?????文件????????906??2011-06-30?20:04??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\Comment.java
?????文件????????755??2011-07-07?19:13??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\Favorite.java
?????文件????????600??2011-06-30?19:36??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\Friend.java
?????文件???????1207??2011-07-14?18:24??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\MicroBlog.java
?????文件???????1016??2011-07-10?18:43??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\Notify.java
?????文件???????2281??2011-07-04?09:09??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\po\User.java
?????文件???????3175??2011-07-09?00:07??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\BlogTimeUtil.java
?????文件????????462??2011-07-03?22:34??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\ComparatorMicroBlog.java
?????文件????????437??2011-07-10?18:52??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\ComparatorNotify.java
?????文件????????974??2011-06-29?17:30??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\Config.java
?????文件???????3023??2011-07-12?12:11??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\CookieLoginFilter.java
?????文件???????3672??2011-06-30?10:30??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\DaoSupport.java
?????文件????????157??2011-06-30?15:32??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\dbconfig.properties
?????文件???????2323??2011-06-29?17:30??項(xiàng)目源碼與數(shù)據(jù)庫\MicroBlog\src\org\microblog\util\DBConn.java
............此處省略304個(gè)文件信息
評論
共有 條評論
川公網(wǎng)安備 51152502000135號