package dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import entity.Article; /** * 文章的数据库处理类 * 对应数据库ARTICLE表 * @author Administrator * */ public class ArticleDao { DBconn conn = new DBconn(); //在数据库中添加一篇文章 public boolean add(Article art){ return conn.update("insert into ARTICLE(ARTICLENAME,ARTICLETITLE,ARTICLEPUBLISHTIME,ARTICLEPUBLISHER,ARTICLECONTENT) values(?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'),?,?)", new String[]{ art.getArticleName(), art.getArticleTitle(), art.getArticlePublishtime(), art.getArticlePublisher(), art.getArticleContent() })>0; } //根据文章id来删除文章 public boolean deleteById(int articleId){ return conn.update("delete from ARTICLE where ARTICLEID=?", new String[]{String.valueOf(articleId)})>0; } //根据文章对象来跟新文章 public boolean updateByArticle(Article art){ return conn.update("update ARTICLE set ARTICLENAME=?,ARTICLETITLE=?,ARTICLEPUBLISHTIME=to_date(?,'yyyy-mm-dd hh24:mi:ss'),ARTICLEPUBLISHER=?,ARTICLECONTENT=? where ARTICLEID=?", new String[]{ art.getArticleName(), art.getArticleTitle(), art.getArticlePublishtime(), art.getArticlePublisher(), art.getArticleContent(), String.valueOf(art.getArticleId()) })>0; } //根据文章的id来在查找出这个文章对象 public Article queryByArticleId(int articleId){ Article art = new Article(); ResultSet rs=conn.query("select * from ARTICLE where ARTICLEID=?", new String[]{String.valueOf(articleId)}); try { while(rs.next()){ art.setArticleId(rs.getInt("ARTICLEID")); art.setArticleName(rs.getString("ARTICLENAME")); art.setArticleTitle(rs.getString("ARTICLETITLE")); art.setArticlePublishtime(rs.getString("ARTICLEPUBLISHTIME").substring(0,19)); art.setArticlePublisher(rs.getString("ARTICLEPUBLISHER")); art.setArticleContent(rs.getString("ARTICLECONTENT")); art.setArticleClickrate(rs.getInt("ARTICLECLICKRATE")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return art; } //根据文章的类型来查找文章 public ArrayList<Article> queryByArticleName(String articleName){ ArrayList<Article> list=new ArrayList<Article>(); ResultSet rs=conn.query("select * from ARTICLE where ARTICLENAME=?", new String[]{String.valueOf(articleName)}); try { while(rs.next()){ Article art = new Article(); art.setArticleId(rs.getInt("ARTICLEID")); art.setArticleName(rs.getString("ARTICLENAME")); art.setArticleTitle(rs.getString("ARTICLETITLE")); art.setArticlePublishtime(rs.getString("ARTICLEPUBLISHTIME").substring(0,19)); art.setArticlePublisher(rs.getString("ARTICLEPUBLISHER")); art.setArticleContent(rs.getString("ARTICLECONTENT")); art.setArticleClickrate(rs.getInt("ARTICLECLICKRATE")); list.add(art); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return list; } public ArrayList<Article> queryByArticleName1(String articleName){ ArrayList<Article> list=new ArrayList<Article>(); ResultSet rs=conn.query("select * from ARTICLE where ARTICLENAME=?", new String[]{articleName}); try { while(rs.next()){ Article art = new Article(); art.setArticleId(rs.getInt("ARTICLEID")); art.setArticleName(rs.getString("ARTICLENAME")); art.setArticleTitle(rs.getString("ARTICLETITLE")); art.setArticlePublishtime(rs.getString("ARTICLEPUBLISHTIME").substring(0,19)); art.setArticlePublisher(rs.getString("ARTICLEPUBLISHER")); art.setArticleContent(rs.getString("ARTICLECONTENT")); art.setArticleClickrate(rs.getInt("ARTICLECLICKRATE")); list.add(art); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return list; } /** * @param page页数 * @param size显示记录数 * @return根据分页获取数据记录 */ public ArrayList<Article> queryByPage(int page,int size) { ArrayList<Article> list = new ArrayList<Article>(); String sql=String.format("select top %s ARTICLEID,ARTICLETITLE,ARTICLEPUBLISHER,ARTICLENAME,ARTICLEPUBLISHTIME from ARTICLE where ARTICLEID not in (select top %s ARTICLEID from ARTICLEID order by ARTICLEID desc) order by ARTICLEID desc", size,(page-1)*size); ResultSet rs = conn.query(sql,null); try { while (rs.next()) { Article art = new Article(); art.setArticleId(rs.getInt("ARTICLEID")); art.setArticleTitle(rs.getString("ARTICLETITLE")); art.setArticlePublisher(rs.getString("ARTICLEPUBLISHER")); art.setArticleName(rs.getString("ARTICLENAME")); art.setArticlePublishtime(rs.getString("ARTICLEPUBLISHTIME").substring(0,19)); list.add(art); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { conn.closeAll(); } return list; } //获取总的数据记录个数 public int getRecordCount(){ int count=0; ResultSet rs=conn.query("select count(*) as rcount from article",null); try { while(rs.next()){ count=rs.getInt("rcount"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return count; } //查询全部的文章 public ArrayList<Article> queryAllArticle() { ArrayList<Article> list=new ArrayList<Article>(); ResultSet rs=conn.query("select * from ARTICLE order by ARTICLEID desc", null); try { while(rs.next()){ Article art=new Article(rs.getInt("ARTICLEID"),rs.getString("ARTICLENAME"),rs.getString("ARTICLETITLE"),rs.getString("ARTICLEPUBLISHTIME").substring(0,19),rs.getString("ARTICLEPUBLISHER"),rs.getString("ARTICLECONTENT"),rs.getInt("ARTICLECLICKRATE"),rs.getString("ARTICLEIMAGE")); list.add(art); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return list; } /**根据点击量查询所有文章 * @return */ public ArrayList<Article> queryArticleClickrate() { ArrayList<Article> list=new ArrayList<Article>(); ResultSet rs=conn.query("select * from ARTICLE order by articleClickrate desc", null); try { while(rs.next()){ Article art=new Article(rs.getInt("ARTICLEID"),rs.getString("ARTICLENAME"),rs.getString("ARTICLETITLE"),rs.getString("ARTICLEPUBLISHTIME").substring(0,19),rs.getString("ARTICLEPUBLISHER"),rs.getString("ARTICLECONTENT"),rs.getInt("ARTICLECLICKRATE"),rs.getString("ARTICLEIMAGE")); list.add(art); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ conn.closeAll(); } return list; } }
最近下载更多
202105013142 LV1
1月29日
komorebi123987 LV5
2023年12月9日
2816681380 LV2
2023年1月30日
wanglinddad LV53
2022年4月15日
微信网友_5870618216976384 LV6
2022年3月14日
lishangchen LV3
2022年1月27日
sovy030201 LV5
2022年1月11日
765105637 LV9
2022年1月11日
八七 LV8
2022年1月3日
北有深秋 LV3
2021年12月21日
最近浏览更多
人间蒸发 LV23
3月4日
刘自盛 LV2
3月1日
eagerwujin LV4
2月22日
202105013142 LV1
1月22日
微笑刺客 LV15
1月3日
落叶乌龟
1月3日
暂无贡献等级
wttttts LV2
1月1日
微信网友_6797846869299200 LV7
1月1日
微信网友_6796920618979328 LV1
2023年12月27日
pangzhihui LV11
2023年12月27日