ArticleService.java
4.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
/******************************************************************
*
* Java Lib For JavaWeb, Powered By Shenzhen WEI YI KE JI .
*
* Copyright (c) 2017-2027 Digital Telemedia Co.,Ltd
* http://www.d-telemedia.com/
*
* Package: com.w1hd.zzhnc.service.impl
*
* Filename: ArticlesServiceImpl.java
*
* Description: TODO(用一句话描述该文件做什么)
*
* Copyright: Copyright (c) 2017-2027
*
* Company: Theyeasy Telemedia Co.,Ltd
*
* @author: hm
*
* @version: 1.0.0
*
* Create at: 2017年11月22日 上午10:13:53
*
* Revision:
*
* 2017年11月22日 上午10:13:53
* - first revision
*
*****************************************************************/
package com.w1hd.zzhnc.service;
import java.util.List;
import org.apache.ibatis.session.RowBounds;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.google.common.base.Strings;
import com.w1hd.zzhnc.dao.ArticlesDao;
import com.w1hd.zzhnc.model.Articles;
import com.w1hd.zzhnc.util.CommonUtil;
import com.w1hd.zzhnc.util.PageResults;
import com.w1hd.zzhnc.util.StringUtil;
import tk.mybatis.mapper.entity.Example;
/**
* @ClassName ArticlesServiceImpl
* @Description TODO(这里用一句话描述这个类的作用)
* @author hm
* @Date 2017年11月22日 上午10:13:53
* @version 1.0.0
*/
@Service
public class ArticleService{
@Autowired
ArticlesDao articleDao;
public PageResults<Articles> getArticlesList(Integer page, Integer pagesize, String keyword) {
if(StringUtil.isZearoOrNull(pagesize))pagesize=10;
Example example = new Example(Articles.class);
example.createCriteria().andEqualTo("deleted", false);
RowBounds row = new RowBounds((page - 1) * pagesize, pagesize);
if(!Strings.isNullOrEmpty(keyword)){
example.createCriteria().andLike("title", "%"+keyword+"%");
}
example.setOrderByClause(" id desc ");
List<Articles> list = articleDao.selectByExampleAndRowBounds(example, row);
int total = articleDao.selectCountByExample(example);
PageResults<Articles> pageresult = new PageResults<>();
pageresult.setPage(page);
pageresult.setTotal(total);
pageresult.setRows(list);
pageresult.setPageSize(pagesize);
return pageresult;
}
public String addArticle(String title, String content, String imgurl) {
// TODO Auto-generated method stub
Articles article=new Articles();
article.setTitle(title);
article.setContent(content);
article.setImgurl(imgurl);
article.setCreatedtime(CommonUtil.getTime());
article.setDeleted(false);
article.setViewcount(0);
int row = articleDao.insertSelective(article);
return row > 0 ? "ok" : "添加失败，数据异常";
}
/* (非 Javadoc)
* Description:
* @see com.w1hd.zzhnc.service.ArticleService#updateArticle(java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)
*/
public String updateArticle(Integer id, String title, String content, String imgurl) {
// TODO Auto-generated method stub
Articles article=articleDao.selectByPrimaryKey(id);
if(article==null)return "修改失败，数据不存在";
article.setTitle(title);
article.setContent(content);
article.setImgurl(imgurl);
int row = articleDao.updateByPrimaryKeySelective(article);
return row > 0 ? "ok" : "修改失败，数据异常";
}
public String deleteArticle(Integer id) {
Articles article=articleDao.selectByPrimaryKey(id);
if(article==null)return "删除失败，数据不存在";
article.setDeleted(true);
int row = articleDao.updateByPrimaryKeySelective(article);
return row > 0 ? "ok" : "删除失败，数据异常";
}
public Articles getArticle(Integer id) {
return articleDao.selectByPrimaryKey(id);
}
public void addArticleViewCount(Integer id) {
Articles article=articleDao.selectByPrimaryKey(id);
if(article!=null){
int viewcount=article.getViewcount();
article.setViewcount(viewcount+1);
articleDao.updateByPrimaryKeySelective(article);
}
}
public List<Articles> getHomeData() {
Example example = new Example(Articles.class);
example.createCriteria().andEqualTo("deleted", false);
RowBounds row = new RowBounds(0 , 5);
example.setOrderByClause(" id desc ");
List<Articles> list = articleDao.selectByExampleAndRowBounds(example, row);
return list;
}
}