淘特JspCms内容管理系统tot-jsp-cms

/* * ArticleDaoImplJDBC.java * * Created on 2006年9月21日, 下午10:01 * * To change this template, choose Tools | Template Manager * and open the template in the editor. */ package tot.dao.jdbc; import tot.dao.AbstractDao; import tot.dao.DaoFactory; import tot.global.Sysconfig; import tot.db.DBUtils; import tot.bean.*; import tot.util.StringUtils; import tot.util.FileUtil; import tot.util.DateUtil; import tot.exception.ObjectNotFoundException; import tot.exception.DatabaseException; import tot.search.SearchQueryNoSql; import java.sql.*; import java.util.*; import java.io.*; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; /** * * @author totcms */ public class ArticleDaoImplJDBC extends AbstractDao { private static Log log = LogFactory.getLog(ArticleDaoImplJDBC.class); /** Creates a new instance of ArticleDaoImplJDBC */ public ArticleDaoImplJDBC() { } public int getLastId(){ int returnValue=0; String sql=null; DataField df=null; if (DBUtils.getDatabaseType() == DBUtils.DATABASE_SQLSERVER) { sql="select top 1 id from t_article order by id desc"; }else if(DBUtils.getDatabaseType() == DBUtils.DATABASE_MYSQL){ sql="select id from t_article order by id desc limit 0,1"; }else if(DBUtils.getDatabaseType()==DBUtils.DATABASE_DB2){ sql="select id from t_article order by id desc fetch first 1 rows only"; }else if(DBUtils.getDatabaseType()==DBUtils.DATABASE_ORACLE){ sql="select id from t_article where rownum=1 order by id desc"; }else{ } df=getFirstData(sql,"id"); if(df!=null){ returnValue=Integer.parseInt(df.getFieldValue("id"))+1; } else{ returnValue=1; } return returnValue; } public int getLastId2() { int returnValue = 0; String sql = null; DataField df = null; sql = "select id from t_article order by id desc"; Collection lists = this.getDataList_Limit_Normal(sql, "id", 1, 0); Iterator iter = lists.iterator(); if (iter.hasNext()) { df = (DataField) iter.next(); } if (df != null) { returnValue = Integer.parseInt(df.getFieldValue("id")) + 1; } else { returnValue = 1; } return returnValue; } public int getHits(int id) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; int returnValue = 0; String sql = null; sql = "select Hits from t_article where id=?"; try { conn = DBUtils.getConnection(); ps = conn.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); if (rs.next()) { returnValue = rs.getInt(1); } else { returnValue = 0; } } catch (SQLException e) { log.error("get hits error", e); } finally { DBUtils.closeResultSet(rs); DBUtils.closePrepareStatement(ps); DBUtils.closeConnection(conn); } return returnValue; } /** add new article */ public boolean addArticle(String title, String subHeading, String titleColor, String keyWords, String relateKey, int relateNum, String content, int isOutLink, String outLinkUrl, int parentId, int categoryId, int templateId, int specialId, int top1, int toTop, int toHot, int recommend, int images, int checked, String author, String sourceFrom, String editor, String userName, String photo, int hits, String savePath, Timestamp moditime, int isslide, String summary) { Connection conn = null; PreparedStatement ps = null; boolean returnValue = true; String sql = "insert into t_article(Title,SubHeading,TitleColor,KeyWords,RelateKey,RelateNum,Content,IsOutLink,OutLinkUrl,ParentId," + "CategoryId,TemplateId,SpecialId,Top1,ToTop,ToHot,Recommend,Images,Checked,Author,SourceFrom,Editor,UserName,Photo,Hits,SavePath,ModiTime,IsSlide,Summary,SortId,ModDate)" + " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; try { conn = DBUtils.getConnection(); conn.setAutoCommit(false); ps = conn.prepareStatement(sql); ps.setString(1, title); ps.setString(2, subHeading); ps.setString(3, titleColor); ps.setString(4, keyWords); ps.setString(5, relateKey); ps.setInt(6, relateNum); if (DBUtils.getDatabaseType() == DBUtils.DATABASE_ORACLE) { ps.setCharacterStream(7, new StringReader(content), content.length()); } else { ps.setString(7, content); } ps.setInt(8, isOutLink); ps.setString(9, outLinkUrl); ps.setInt(10, parentId); ps.setInt(11, categoryId); ps.setInt(12, templateId); ps.setInt(13, specialId); ps.setInt(14, top1); ps.setInt(15, toTop); ps.setInt(16, toHot); ps.setInt(17, recommend); ps.setInt(18, images); ps.setInt(19, checked); ps.setString(20, author); ps.setString(21, sourceFrom); ps.setString(22, editor); ps.setString(23, userName); ps.setString(24, photo); ps.setInt(25, hits); ps.setString(26, savePath); ps.setTimestamp(27, moditime); ps.setInt(28, isslide); ps.setString(29, summary); ps.setInt(30,getLastId()); ps.setString(31,DateUtil.getStringDate()); if (ps.executeUpdate() != 1) { returnValue = false; } conn.commit(); conn.setAutoCommit(true); } catch (SQLException e) { if(conn!=null){ try { conn.rollback(); conn.setAutoCommit(true); log.error("add Article error", e); } catch (SQLException e1) { e1.printStackTrace(); } } } finally { DBUtils.closePrepareStatement(ps); DBUtils.closeConnection(conn); } return returnValue; } /* * mod Article */ public boolean modArticle(int id, String title, String subHeading, String titleColor, String keyWords, String relateKey, int relateNum, String content, int isOutLink, String outLinkUrl, int parentId, int categoryId, int templateId, int specialId, int top1, int toTop, int toHot, int recommend, int images, int checked, String author, String sourceFrom, String editor, String userName, String photo, int hits, String savePath, Timestamp moditime, int isslide, String summary,int sortid,String moddate) { Connection conn = null; PreparedStatement ps = null; boolean returnValue = true; String sql = "update t_article set Title=?,SubHeading=?,TitleColor=?,KeyWords=?,RelateKey=?,RelateNum=?,Content=?,IsOutLink=?," + "OutLinkUrl=?,ParentId=?,CategoryId=?,TemplateId=?,SpecialId=?,Top1=?,ToTop=?,ToHot=?,Recommend=?,Images=?," + "Checked=?,Author=?,SourceFrom=?,Editor=?,UserName=?,Photo=?,Hits=?,SavePath=?,IsSlide=?,Summary=?,SortId=?,ModDate=? where id=?"; try { conn = DBUtils.getConnection(); conn.setAutoCommit(false); ps = conn.prepareStatement(sql)