package net.y2t70.blog.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import javax.servlet.jsp.jstl.sql.Result;
import net.y2t70.blog.dao.ArticlesDao;
import net.y2t70.blog.entity.Articles;
import net.y2t70.blog.tools.StringUtil;
public class ArticlesDaoImpl extends BaseDao implements ArticlesDao {
/**
* 1.发表博文
*/
public int addArticle(Articles art) {
try {
String sql = "insert into Articles values(articles_seq.nextval,'"
+ art.getTitle() + "'," + art.getUserID() + ",'"
+ art.getContent() + "',current_date," + art.getArtTypeID()
+ "," + art.getState() + "," + art.getIsComment() + ","
+ art.getIsreship() + "," + art.getIsOpen()
+ ",default,default,default,default)";
return this.executeUpdate(sql, null);
} catch (Exception e) {
System.out.println("1.发表博文出错：" + e.getMessage());
return 0;
}
}
/**
* 2.修改博文
*/
public int updateArticle(Articles art) {
try {
String sql = "update Articles set title='" + art.getTitle()
+ "',content='" + art.getContent() + "',arttypeid="
+ art.getArtTypeID() + ",state=" + art.getState()
+ ",iscomment=" + art.getIsComment() + ",isreship="
+ art.getIsreship() + ",isopen=" + art.getIsOpen()
+ " where artid=" + art.getArtID() + " and userid="
+ art.getUserID() + "";
return this.executeUpdate(sql, null);
} catch (Exception e) {
System.out.println("2.修改博文出错：" + e.getMessage());
return 0;
}
}
/**
* 3.删除博文(不是真正意义上的删除，是将其状态改为2进入回收站)
*/
public int deleteArticle(int state, int artID, int userID) {
try {
String sql = "update Articles set state=" + state
+ " where artid=" + artID + " and userid=" + userID + "";
return this.executeUpdate(sql, null);
} catch (Exception e) {
System.out.println("3.删除博文出错：" + e.getMessage());
return 0;
}
}
/**
* 4.根据博文分类名称和用户ID查询博文
*/
public List<Articles> showArtByArtType(String typename, int userID) {
try {
String sql = "select artid,title,content,sendtime,zhuanzaiCount,shoucangCount,pingCount,dianjiCount from Articles inner join ArticleType on Articles.arttypeid=ArticleType.arttypeid where typename='"
+ typename
+ "' and Articles.userid="
+ userID
+ " and state=0 and isopen=0";
Result result = this.executeQuery(sql, null);
List<Articles> list = new ArrayList<Articles>();
int size = result.getRowCount();
for (int i = 0; i < size; i++) {
Map map = result.getRows()[i];
Articles art = new Articles();
art.setArtID(StringUtil.toInt(StringUtil.parseString(map
.get("artid"))));
art.setTitle(StringUtil.parseString(map.get("title")));
art.setContent(StringUtil.parseString(map.get("content")));
art.setSendTime(StringUtil.parseString(map.get("sendtime")));
art.setZhuanzaiCount(StringUtil.toInt(StringUtil
.parseString(map.get("zhuanzaicount"))));
art.setShoucangCount(StringUtil.toInt(StringUtil
.parseString(map.get("shoucangcount"))));
art.setPingCount(StringUtil.toInt(StringUtil.parseString(map
.get("pingcount"))));
art.setDianjiCount(StringUtil.toInt(StringUtil.parseString(map
.get("dianjicount"))));
list.add(art);
}
return list;
} catch (Exception e) {
System.out.println("4.根据博文分类名称和用户ID查询博文出错：" + e.getMessage());
return null;
}
}
/**
* 5.根据博文的id显示其详细信息
*/
public Articles LookOneArt(int artID) {
try {
String sql = "select artid,title,Articles.userid,content,sendtime,Articles.arttypeid,state,iscomment,isreship,isopen,typename,zhuanzaiCount,shoucangCount,pingCount,dianjiCount from Articles inner join ArticleType on Articles.arttypeid=ArticleType.arttypeid where artid="
+ artID + " and state=0";
Result result = this.executeQuery(sql, null);
int size = result.getRowCount();
if (result.getRowCount() > 0) {
Map map = result.getRows()[0];
Articles art = new Articles();
art.setArtID(StringUtil.toInt(StringUtil.parseString(map
.get("artid"))));
art.setTitle(StringUtil.parseString(map.get("title")));
art.setUserID(StringUtil.toInt(StringUtil.parseString(map
.get("userid"))));
art.setContent(StringUtil.parseString(map.get("content")));
art.setSendTime(StringUtil.parseString(map.get("sendtime")));
art.setArtTypeID(StringUtil.toInt(StringUtil.parseString(map
.get("arttypeid"))));
art.setState(StringUtil.toInt(StringUtil.parseString(map
.get("state"))));
art.setIsComment(StringUtil.toInt(StringUtil.parseString(map
.get("iscomment"))));
art.setIsreship(StringUtil.toInt(StringUtil.parseString(map
.get("isreship"))));
art.setIsOpen(StringUtil.toInt(StringUtil.parseString(map
.get("isopen"))));
art.setTypename(StringUtil.parseString(map.get("typename")));
art.setZhuanzaiCount(StringUtil.toInt(StringUtil
.parseString(map.get("zhuanzaicount"))));
art.setShoucangCount(StringUtil.toInt(StringUtil
.parseString(map.get("shoucangcount"))));
art.setPingCount(StringUtil.toInt(StringUtil.parseString(map
.get("pingcount"))));
art.setDianjiCount(StringUtil.toInt(StringUtil.parseString(map
.get("dianjicount"))));
return art;
}
return null;
} catch (Exception e) {
System.out.println("5.根据博文的id显示其详细信息出错：" + e.getMessage());
return null;
}
}
/**
* 6.显示草稿箱信息
*/
public List<Articles> showCaoGao() {
try {
String sql = "select artid,title,content,sendtime,typename from Articles inner join ArticleType on Articles.arttypeid=ArticleType.arttypeid where state=1";
Result result = this.executeQuery(sql, null);
List<Articles> list = new ArrayList<Articles>();
int size = result.getRowCount();
for (int i = 0; i < size; i++) {
Map map = result.getRows()[i];
Articles art = new Articles();
art.setArtID(StringUtil.toInt(StringUtil.parseString(map
.get("artid"))));
art.setTitle(StringUtil.parseString(map.get("title")));
art.setContent(StringUtil.parseString(map.get("content")));
art.setSendTime(StringUtil.parseString(map.get("sendtime")));
art.setTypename(StringUtil.parseString(map.get("typename")));
list.add(art);
}
return list;
} catch (Exception e) {
System.out.println(" 6.显示草稿箱信息出错：" + e.getMessage());
return null;
}
}
/**
* 7.显示回收站的博文列表
*/
public List<Articles> showHuiShou() {
try {
String sql = "select artid,title,content,sendtime,typename from Articles inner join ArticleType on Articles.arttypeid=ArticleType.arttypeid where state=2";
Result result = this.executeQuery(sql, null);
List<Articles> list = new ArrayList<Articles>();
int size = result.getRowCount();
for (int i = 0; i < size; i++) {
Map map = result.getRows()[i];
Articles art = new Articles();
art.setArtID(StringUtil.toInt(StringUtil.parseString(map
.get("artid"))));
art.setTitle(StringUtil.parseString(map.get("title")));
art.setContent(StringUtil.parseString(map.get("content")));
art.setSendTime(StringUtil.parseString(map.get("sendtime")));
art.setTypename(StringUtil.parseString(map.get("typename")));
list.add(art);
}
return list;
} catch (Exception e) {
System.out.println("7.显示回收站的博文列表出错：" + e.getMessage());
return null;
}
}
/**
* 8.将回收站的博文恢复
*/
public int HuiFuArt(int artID) {
try {
String sql = "update Articles set state=0 where artid=" + artID
+ " and state=2";
return this.executeUpdate(sql, null);
} catch (Exception e) {
System.out.println("8.将回收站的博文恢复出错：" + e.getMessage());
return 0;
}
}
/**
* 9.将在回收站中的博文删除，改变其s
ajax+jquery+jsp+oracle做的博客系统 （366个子文件） 
style.css.bak 9KB ArticlesDaoImpl.class 11KB UserDaoImpl.class 6KB BaseDao.class 5KB DoUpload.class 5KB FriendDaoImpl.class 4KB FriendTypeDaoImpl.class 4KB ValidateCode.class 4KB ArticleTypeDaoImpl.class 4KB UpdateHeadServlet.class 4KB SystemDaoImpl.class 4KB Articles.class 3KB PhotoesDaoImpl.class 3KB UpdateServlet.class 3KB addArtTypeServlet1.class 3KB User.class 3KB GallryDaoImpl.class 3KB CallerDaoImpl.class 3KB SearchFriends.class 3KB showArtTypeServlet.class 3KB addArtTypeServlet.class 3KB CreateArtServlet.class 3KB ArticlesBizImpl.class 3KB Zhuanzai.class 3KB LoginServlet.class 3KB RegServlet.class 3KB SaveCaoGaoServlet.class 2KB PhotoesServlet.class 2KB SystemMessages.class 2KB GallrySerlvet.class 2KB UserBizImpl.class 2KB showTimeServlet.class 2KB Comments.class 2KB Reply.class 2KB MyFilter.class 2KB SelectPhotoServlet.class 2KB FileEncoding.class 2KB FavoritesDaoImpl.class 2KB showArtServlet.class 2KB LeaveMessages.class 2KB Friends.class 2KB UpdateGallryServlet.class 2KB DeleteGallryServlet.class 2KB CodeSerlvet.class 2KB ZhuanzaiDaoImpl.class 1KB Callers.class 1KB Photoes.class 1KB Favorites.class 1KB FriendTypeBizImpl.class 1KB ArticleTypeBizImpl.class 1KB Encoding.class 1KB UserServlet.class 1KB PhotoesBizImpl.class 1KB GallryBizImpl.class 1KB StringUtil.class 1KB Gallry.class 1KB FriendsBizImpl.class 1KB ArticleType.class 1KB FriendType.class 1KB MyProperty.class 1KB ArticlesBiz.class 959B ArticlesDao.class 959B FavoritesBizImpl.class 842B ZhuanzaiBizImpl.class 695B TypeUtil.class 693B ArticleTypeBiz.class 436B ArticleTypeDao.class 436B PhotoesBiz.class 417B UserBiz.class 417B PhotoesDao.class 417B FriendTypeBiz.class 411B FriendTypeDao.class 411B UserDao.class 410B GallryBiz.class 407B GallryDao.class 407B FriendsBiz.class 405B FriendDao.class 403B SystemDao.class 334B CellDao.class 257B FavoritesBiz.class 207B FavoritesDao.class 207B ZhuanzaiBiz.class 179B ZhuanzaiDao.class 179B .classpath 737B .classpath 494B .classpath 383B .classpath 232B style.css 35KB style.css 35KB register.css 11KB style1.css 9KB style2.css 8KB miao_style.css 2KB cardtips.css 971B
chen.gif 35KB btn.gif 16KB bghead_top.gif 8KB sg_btn.gif 7KB bghead_bottom.gif 6KB 180-35.gif 5KB共 366 条
- 1
- 2
- 3
- 4
评论4
最新资源