新闻发布项目——数据实现类(newsTbDaoImpl)
2023-09-14 08:57:41 时间
package bdqn.newsMange.Dao.Impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import bdqn.newsMange.Dao.BaseDao; import bdqn.newsMange.Dao.newsTbDao; import bdqn.newsMange.entity.newsTb; /** * 新闻的实现类 * @author Administrator * */ public class newsTbDaoImpl extends BaseDao implements newsTbDao { //查询 public List<newsTb> getnewsTbAll() { List<newsTb> newsList=new ArrayList<newsTb>(); String sql="select * from newsTb"; try { ResultSet rs=executeQurey(sql, null); while(rs.next()){ newsTb ne=new newsTb(); ne.setNewsID(rs.getInt("newsid")); ne.setTitle(rs.getString("title")); ne.setAuthor(rs.getString("author")); ne.setCreateDate(rs.getDate("CreateDate")); ne.setCategoryID(rs.getInt("CategoryID")); ne.setContent(rs.getString("Content")); ne.setModifyDate(rs.getDate("ModifyDate")); ne.setPicPath(rs.getString("PicPath")); ne.setSummary(rs.getString("Summary")); newsList.add(ne); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(); } return newsList; } //添加 public int addNewsTb(newsTb news) { int rel = 0; List<Object> prams = new ArrayList<Object>(); String sql = "insert newsTb(categoryID,summary,title," + "content,picPath,author,createDate,modifyDate) values(?,?,?,?,?,?,?,?)"; prams.add(news.getCategoryID()); prams.add(news.getSummary()); prams.add(news.getTitle()); prams.add(news.getContent()); prams.add(news.getPicPath()); prams.add(news.getAuthor()); prams.add(news.getCreateDate()); prams.add(news.getModifyDate()); try { rel=executeUpdate(sql, prams); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(); } return rel; } //修改 public int updateNewsTb(newsTb news) { int rel=0; String sql="update newsTb set categoryID=?,summary=?,title=?," + "content=?,picPath=?,author=?,createDate=?,modifyDate=? where newsID=?"; List<Object>prams=new ArrayList<Object>(); prams.add(news.getCategoryID()); prams.add(news.getSummary()); prams.add(news.getTitle()); prams.add(news.getContent()); prams.add(news.getPicPath()); prams.add(news.getAuthor()); prams.add(news.getCreateDate()); prams.add(news.getModifyDate()); prams.add(news.getNewsID()); try { rel=executeUpdate(sql, prams); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(); } return rel; } //删除 public int addNewsTb(int id) { int rel=0; String sql="delete from newsTb where newsID=?"; List<Object>prams=new ArrayList<Object>(); prams.add(id); try { rel=executeUpdate(sql, prams); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rel; } //根据新闻的id查询新闻的信息 public newsTb getAllNewsById(int id) { String sql="select * from newsTb where newsID=?"; List<Object>prams=new ArrayList<Object>(); prams.add(id); newsTb news=null; try { ResultSet rs=executeQurey(sql, prams); if(rs.next()){ news=new newsTb(); news.setNewsID(rs.getInt("newsid")); news.setTitle(rs.getString("title")); news.setAuthor(rs.getString("author")); news.setCreateDate(rs.getDate("CreateDate")); news.setCategoryID(rs.getInt("CategoryID")); news.setContent(rs.getString("Content")); news.setModifyDate(rs.getDate("ModifyDate")); news.setPicPath(rs.getString("PicPath")); news.setSummary(rs.getString("Summary")); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(); } return news; } //根据类别id查询新闻的信息 public List<newsTb> getnewsAllById(int id) { List<newsTb> nlist=new ArrayList<newsTb>(); String sql="select * from newsTb where categoryID=?"; List<Object>prams=new ArrayList<Object>(); prams.add(id); try { ResultSet rs=executeQurey(sql, prams); newsTb news=null; while(rs.next()){ news=new newsTb(); news.setNewsID(rs.getInt("newsid")); news.setTitle(rs.getString("title")); news.setAuthor(rs.getString("author")); news.setCreateDate(rs.getDate("CreateDate")); news.setCategoryID(rs.getInt("CategoryID")); news.setContent(rs.getString("Content")); news.setModifyDate(rs.getDate("ModifyDate")); news.setPicPath(rs.getString("PicPath")); news.setSummary(rs.getString("Summary")); nlist.add(news); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(); } return nlist; } }
相关文章
- 这个大数据开源项目多半要黄,但我希望它能成。。。
- springboot更改项目名_java 文件重命名
- python django 数据库_Apache+Mysql+PHP/Python简单项目
- 2023年春季学期“大数据能力提升项目”证书办理及领取通知
- ASP.NET WEB项目中GridView与Repeater数据绑定控件的用法
- PGL图学习项目合集&数据集分享&技术归纳业务落地技巧[系列十]
- 客快物流大数据项目(九十八):ClickHouse的SQL函数
- vue.js客服系统实时聊天项目开发(二十二)vue项目中router.js路由介绍
- Python 小型项目大全 36~40
- Spark项目之电商用户行为分析大数据平台之(三)大数据集群的搭建详解大数据
- Spark项目之电商用户行为分析大数据平台之(一)项目介绍详解大数据
- Hadoop项目实战-用户行为分析之应用概述(三)详解大数据
- Hadoop项目实战-用户行为分析之应用概述(一)详解大数据
- Mozilla 开始为开源项目提供 50 万美元的安全审计基金
- MySQL实现两表统计项目,让数据更加清晰明了(mysql两表统计项目)