package org.zjy.dao;
import java.sql.ResultSet;
import java.util.ArrayList;
import org.zjy.db.DBUtil;
import org.zjy.vo.Article;
public class ArticleDao {
public int update(Article article){
StringBuffer sql=new StringBuffer();
int i=0;
try{
sql.append("update article set title='"+article.getTitle()+"',");
sql.append("content='"+article.getContent()+"',");
sql.append("pubtime='"+article.getPubtime()+"',");
sql.append("blogid="+article.getBlogid()+",");
sql.append("sortid="+article.getSortid()+" ");
sql.append("where id="+article.getId()+";");
i=DBUtil.executeUpdateInsertDelete(sql.toString());
}catch(Exception ex){
ex.printStackTrace();
}
return i;
}
public int delete(Article article){
StringBuffer sql=new StringBuffer();
sql.append("delete from article where id="+article.getId()+";");
return DBUtil.executeUpdateInsertDelete(sql.toString());
}
public int save(Article article){
StringBuffer sql=new StringBuffer();
sql.append("insert into article(id,title,content,pubtime,blogid,sortid)");
int number=DBUtil.getMaxId("article")+1;
sql.append("values("+number);
sql.append(",'"+article.getTitle()+"',");
sql.append("'"+article.getContent()+"',");
sql.append("'"+article.getPubtime()+"',");
sql.append(article.getBlogid()+","+article.getSortid()+");");
return DBUtil.executeUpdateInsertDelete(sql.toString());
}
public Article findById(int id){
Article article=null;
StringBuffer sql=new StringBuffer();
sql.append("select * from article where id="+id+";");
try{
ResultSet set=DBUtil.executeQuery(sql.toString());
while(set.next()){
article=new Article();
article.setId(set.getInt("id"));
article.setTitle(set.getString("title"));
article.setContent(set.getString("content"));
article.setPubtime(set.getString("pubtime"));
article.setBlogid(set.getInt("blogid"));
article.setSortid(set.getInt("sortid"));
break;
}
}catch(Exception ex){
ex.printStackTrace();
}
return article;
}
public ArrayList<Article> getAllArticle(){
ArrayList<Article> list=new ArrayList<Article>();
StringBuffer sql=new StringBuffer();
sql.append("select * from article order by pubtime desc");
try{
ResultSet set=DBUtil.executeQuery(sql.toString());
while(set.next()){
Article article=new Article();
article.setId(set.getInt("id"));
article.setTitle(set.getString("title"));
article.setContent(set.getString("content"));
article.setPubtime(set.getString("pubtime"));
article.setBlogid(set.getInt("blogid"));
article.setSortid(set.getInt("sortid"));
list.add(article);
}
}catch(Exception ex){
ex.printStackTrace();
}
return list;
}
public ArrayList<Article> findByBlogIdSortId(int blogid,int sortid){
ArrayList<Article> list=new ArrayList<Article>();
StringBuffer sql=new StringBuffer();
sql.append("select * from article ");
sql.append(" where blogid="+blogid);
if(sortid==0){
sql.append(" order by pubtime desc;");
}else{
sql.append(" and sortid="+sortid+" order by pubtime desc;");
}
try{
ResultSet set=DBUtil.executeQuery(sql.toString());
while(set.next()){
Article article=new Article();
article.setId(set.getInt("id"));
article.setTitle(set.getString("title"));
article.setContent(set.getString("content"));
article.setPubtime(set.getString("pubtime"));
article.setBlogid(set.getInt("blogid"));
article.setSortid(set.getInt("sortid"));
list.add(article);
}
}catch(Exception ex){
ex.printStackTrace();
}
return list;
}
public ArrayList<Article> findMatchArticle(String key){
ArrayList<Article> list=new ArrayList<Article>();
StringBuffer sql=new StringBuffer();
sql.append("select * from article where title like '%"+key+"%';");
try{
ResultSet set=DBUtil.executeQuery(sql.toString());
while(set.next()){
Article article=new Article();
article.setId(set.getInt("id"));
article.setTitle(set.getString("title"));
article.setContent(set.getString("content"));
article.setPubtime(set.getString("pubtime"));
article.setBlogid(set.getInt("blogid"));
article.setSortid(set.getInt("sortid"));
list.add(article);
}
}catch(Exception ex){
ex.printStackTrace();
}
return list;
}
public int getFeedBackTotal(int articleId){
int i=0;
FeedBackDao feedBackDao=new FeedBackDao();
return i;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
博客应用系统开发,与mysql的链接
共231个文件
class:76个
java:76个
jar:31个
需积分: 3 7 下载量 36 浏览量
2011-06-25
16:50:23
上传
评论
收藏 9.86MB ZIP 举报
温馨提示
该博客首页采用框架结构,上部分为广告区,中间为文本区,具有吸引力!其中包括信息评论页面,个人资料管理等等
资源推荐
资源详情
资源评论
收起资源包目录
博客应用系统开发,与mysql的链接 (231个子文件)
ArticleDao.class 5KB
DaoFacade.class 5KB
BlogDao.class 5KB
BlogOperateAction.class 4KB
AdminArticleAction.class 4KB
AdminLinksAction.class 4KB
ShowFeedbackAction.class 4KB
FeedBackDao.class 4KB
AdminSortAction.class 3KB
OpenArticleAction.class 3KB
LinksDao.class 3KB
OpenBlogAction.class 3KB
SortDao.class 3KB
LoginAction.class 3KB
SaveLogoServlet.class 3KB
FirstAction.class 2KB
BlogListener.class 2KB
DBUtil.class 2KB
ArticleSaveAction.class 2KB
ArticleSortAction.class 2KB
RequestFilter.class 2KB
ImageTool.class 2KB
BlogOperateForm.class 2KB
WriteFeedbackServlet.class 2KB
WriteFeedBackAction.class 2KB
UserFilter.class 2KB
Blog.class 2KB
OpenArticleResult.class 2KB
RegisteAction.class 2KB
OpenBlogResult.class 2KB
AdminLinksServlet.class 2KB
AdminArticleServlet.class 2KB
AdminSortServlet.class 2KB
SaveSelfInfoAction.class 2KB
ArticleSortServlet.class 2KB
Article.class 2KB
FirstServlet.class 2KB
CheckUnameServlet.class 2KB
ExternalContext.class 2KB
LoginServlet.class 2KB
FeedBack.class 2KB
AdminLinksForm.class 1KB
ArticleSaveServlet.class 1KB
ShowFeedbackForm.class 1KB
SearchAction.class 1KB
CheckUnameAction.class 1KB
SaveSelfInfoServlet.class 1KB
RegistServlet.class 1KB
SearchServlet.class 1KB
BlogOperateResult.class 1KB
ArticleSaveForm.class 1KB
LoginForm.class 1KB
AdminArticleForm.class 1KB
RegisteForm.class 1KB
AdminSortForm.class 1KB
ShowFeedbackServlet.class 1KB
OpenArticleServlet.class 1KB
BlogOperateServlet.class 1KB
OpenBlogServlet.class 1KB
WriteFeedbackForm.class 1KB
BlogDaoTest.class 1KB
ShowFeedbackResult.class 1KB
Constants.class 1KB
Links.class 1KB
ArticleService.class 1KB
LoginCheckResult.class 1020B
BlogService.class 1011B
Sort.class 918B
FacesContext.class 858B
CheckUnameForm.class 587B
SaveSelfInfoForm.class 587B
SearchForm.class 569B
ArticleSortForm.class 542B
OpenArticleForm.class 541B
OpenBlogForm.class 523B
FirstActionForm.class 308B
.classpath 3KB
mystyle.css 2KB
logo.gif 2KB
bk_button01.gif 448B
hibernate3.jar 1.94MB
jgroups-2.2.8.jar 1.58MB
xerces-2.6.2.jar 1023KB
mysql-connector-java-5.1.3-rc-bin.jar 631KB
jboss-common.jar 605KB
jboss-jmx.jar 602KB
c3p0-0.9.0.jar 498KB
proxool-0.8.3.jar 479KB
antlr-2.7.6rc1.jar 442KB
jboss-cache.jar 379KB
log4j-1.2.11.jar 360KB
dom4j-1.6.1.jar 316KB
cglib-2.1.3.jar 291KB
jaxen-1.1-beta-7.jar 238KB
jboss-system.jar 226KB
commons-collections-2.1.1.jar 182KB
concurrent-1.3.2.jar 177KB
xml-apis.jar 135KB
oscache-2.1.jar 118KB
junit-3.8.1.jar 116KB
共 231 条
- 1
- 2
- 3
资源评论
ban11ban
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功