蓝息新闻发布系统JSP源码下载

package com.linesee.proc; import java.sql.ResultSet; import java.sql.SQLException; import java.util.LinkedList; import java.util.List; import org.apache.log4j.Logger; import com.linesee.data.IntParam; import com.linesee.data.LongParam; import com.linesee.data.Param; import com.linesee.data.ParamUtils; import com.linesee.data.StringParam; import com.linesee.dto.ContentInfo; import com.linesee.dto.SysConst; import com.linesee.dto.SysVar; import com.linesee.utils.DbBase; import com.linesee.utils.PStr; import com.linesee.utils.Pagination; /** * 文章相关操作 * @author 火星 * */ public class ContentProc { private static final Logger log = Logger.getLogger(ContentProc.class); /** * 添加文章 * @param ci * @return 返回添加的管理员ID */ public long addContent(ContentInfo ci){ final String sql="insert into content (colId,title,shorttitle,content,summary,imgUrl,keyword,userId,src,adddate) values (?,?,?,?,?,?,?,?,?,now())"; log.info("ContentProc.addContent begintrans at :" + System.currentTimeMillis()); boolean result = false; DbBase db=new DbBase(); long id=0; try { db.beginTrans(); result = db.update(sql,new LongParam(ci.getColId()),new StringParam(ci.getTitle()),new StringParam(ci.getShortTitle()),new StringParam(ci.getContent()),new StringParam(ci.getSummary()),new StringParam(ci.getImgUrl()),new StringParam(ci.getKeyword()),new IntParam(ci.getUserId()),new StringParam(ci.getSrc())); id=(int)db.getLastInsertId(); //如果添加内容的栏目是单篇文章 的，则设置栏目的转向页地址 if (SysVar.ColumnMaps.get(String.valueOf(ci.getColId())).getColType()==1){ String url="content_"+id+".html"; db.update("update columninfo set outUrl=? where colId=?",new StringParam(url),new IntParam(ci.getColId())); } db.commit(); } catch (SQLException e) { e.printStackTrace(); db.rollBack(); log.error("ContentProc.addContent error : " + e.getMessage()); } finally { db.release(); log.info("ContentProc.addContent end trans at :" + System.currentTimeMillis()); } return id; } /** * 修改文章，传入对象ID不能为空 * @param ci * @return */ public boolean editContent(ContentInfo ci){ final String sql="update content set colId=?,title=?,shorttitle=?,content=?,summary=?,imgUrl=?,src=?,keyword=? where contentId=?"; log.info("ContentProc.editContent begintrans at :" + System.currentTimeMillis()); boolean b=true; DbBase db=new DbBase(); try{ db.beginTrans(); b=db.update(sql,new IntParam(ci.getColId()),new StringParam(ci.getTitle()),new StringParam(ci.getShortTitle()),new StringParam(ci.getContent()),new StringParam(ci.getSummary()),new StringParam(ci.getImgUrl()),new StringParam(ci.getSrc()),new StringParam(ci.getKeyword()),new LongParam(ci.getContentId())); db.commit(); } catch(SQLException e){ db.rollBack(); log.error("ContentProc.editContent error : "+e.getMessage()); } finally{ db.release(); log.info("ContentProc.editContent end trans at :" + System.currentTimeMillis()); } return b; } /** * 屏蔽或恢复文章 * @param ids * @return */ public boolean setContentStat(long[] ids,short v){ final String sql="update content set isdel=? where contentId in ("+ParamUtils.qMark(ids)+")"; log.info("ContentProc.setContentStat begintrans at :" + System.currentTimeMillis()); boolean b=true; DbBase db=new DbBase(); try{ db.beginTrans(); Param p=new Param(); p.add(new IntParam(v)); p.add(ParamUtils.toLongParam(ids)); b=db.update(sql,p.getParam()); db.commit(); } catch(SQLException e){ db.rollBack(); log.error("ContentProc.setContentStat error : "+e.getMessage()); } finally{ db.release(); log.info("ContentProc.setContentStat end trans at :" + System.currentTimeMillis()); } return b; } /** * 增加点击数 * @param id * @return */ public boolean addHits(long id){ final String sql = "update content set hits=hits+1 where contentId=?"; log.info("ContentProc.addHits begintrans at :" + System.currentTimeMillis()); boolean result = true; DbBase db=new DbBase(); try { db.beginTrans(); result = db.update(sql,new LongParam(id)); db.commit(); } catch (SQLException e) { db.rollBack(); log.error("ContentProc.addHits error : " + e.getMessage()); } finally { db.release(); log.info("ContentProc.addHits end trans at :" + System.currentTimeMillis()); } return result; } /** * 增加评论数 * @param id * @return */ public boolean addCmtCount(long id){ final String sql = "update content set cmtcount=cmtcount+1 where contentId=?"; log.info("ContentProc.addCmtCount begintrans at :" + System.currentTimeMillis()); boolean result = true; DbBase db=new DbBase(); try { db.beginTrans(); result = db.update(sql,new LongParam(id)); db.commit(); } catch (SQLException e) { db.rollBack(); log.error("ContentProc.addCmtCount error : " + e.getMessage()); } finally { db.release(); log.info("ContentProc.addCmtCount end trans at :" + System.currentTimeMillis()); } return result; } /** * 读取指定文章信息 * @param id * @return */ public ContentInfo getContent(long id){ final String sql="select colId,title,shorttitle,content,summary,imgUrl,userId,src,adddate,keyword from content where isdel=0 and contentId=?"; if (log.isDebugEnabled()){ log.info("ContentProc.getContent begintrans at :"+System.currentTimeMillis()); } DbBase db=new DbBase(); ContentInfo item=new ContentInfo(); ResultSet rs=null; try{ rs=db.query(sql,new LongParam(id)); if (rs.next()){ int i=1; item.setContentId(id); item.setColId(rs.getInt(i++)); item.setTitle(rs.getString(i++)); item.setShortTitle(rs.getString(i++)); item.setContent(rs.getString(i++)); item.setSummary(rs.getString(i++)); item.setImgUrl(rs.getString(i++)); item.setUserId(rs.getInt(i++)); item.setSrc(rs.getString(i++)); item.setAdddate(PStr.toTimestamp(rs.getDate(i++))); item.setKeyword(rs.getString(i++)); } rs.close(); } catch(SQLException e){ log.error("ContentProc.getContent error:"+e.getMessage()+" at :"+System.currentTimeMillis()); } finally{ rs=null; db.release(); } if (log.isDebugEnabled()){ log.info("ContentProc.getContent end at :"+System.currentTimeMillis()); } return item; } //挨着的上下两篇文章 public ContentInfo getContentNearly(long id,int order,boolean isNext){ String sql; StringBuffer sqlb=new StringBuffer(); if (isNext){ sqlb.append("select contentId,colId,title,shorttitle,content,summary,imgUrl,userId,src,adddate from content where isdel=0 and contentId>? order by "); switch(order){ case SysConst.ORDERBY_DATE: sqlb.append(" adddate asc "); break; case SysConst.ORDERBY_HITS: sqlb.append(" hits asc "); break; case SysConst.ORDERBY_CMTCOUNT: sqlb.append(" cmtcount asc "); break; } sqlb.append(" limit 1"); } else { sqlb.append("select contentId,colId,title,shorttitle,content,summary,imgUrl,userId,src,adddate from content where isdel=0 and contentId<? order by "); switch(order){ case SysConst.ORDERBY_DATE: sqlb.append(" adddate desc "); break; case SysConst.ORDERBY_HITS: sqlb.append(" hits desc "); break; case SysConst.ORDERBY_CMTCOUNT: sqlb.append(" cmtcount desc "); break; } sqlb.append(" limit 1"); } sql=sqlb.toString(); sqlb.delete(0,sqlb.capacity()); if (log.isDebugEnabled()){ log.info("ContentProc.getContentNearly begintrans at :"+System.currentTimeMillis()); } //List<ContentInfo> items=new LinkedList<ContentInfo>(); ContentInfo item=new ContentInfo(); ResultSet rs=null; DbBase