基于SSH框架的新闻发布系统

package com.test.dao.impl; import java.util.List; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.test.bean.News; import com.test.bean.User; import com.test.dao.NewsDAO; public class NewsDAOImpl extends HibernateDaoSupport implements NewsDAO { public void deleteNews(News news) { // TODO Auto-generated method stub this.getHibernateTemplate().delete(news); } public List<News> findAll() { // TODO Auto-generated method stub String hql = "from News news order by news.news_id desc"; return (List<News>)this.getHibernateTemplate().find(hql); } public List<News> findByAuthor(String author) { // TODO Auto-generated method stub List<News> n1=getHibernateTemplate().find("from News news where news.news_author =?", author); if(n1!=null && n1.size()>=1) { return n1; } return null; } public List<News> findByForum3(int forum3_id) { // TODO Auto-generated method stub List<News> n1=this.getHibernateTemplate().find("from News news where news.forum3_id =?", forum3_id); if(n1!=null&&n1.size()>=1) { return n1; } return null; } public News findById(Integer id) { // TODO Auto-generated method stub News news = (News) this.getHibernateTemplate().get(News.class, id); return news; } public List<News> findByKeyWords(String keyWords) { // TODO Auto-generated method stub List<News> n1=this.getHibernateTemplate().find("from News news where news.News_keywords =?", keyWords); if(n1!=null&&n1.size()>=1) { return n1; } return null; } public News findBySubTitle(String subTitle) { // TODO Auto-generated method stub List n1=this.getHibernateTemplate().find("from News news where news.News_subTitle =?", subTitle); if(n1!=null&&n1.size()>=1) { return (News)n1.get(0); } return null; } public News findByTitle(String title) { // TODO Auto-generated method stub List n1=this.getHibernateTemplate().find("from News news where news.news_title =?", title); if(n1!=null&&n1.size()>=1) { return (News)n1.get(0); } return null; } public void saveNews(News news) { // TODO Auto-generated method stub this.getHibernateTemplate().save(news); } public void updateNews(News news) { // TODO Auto-generated method stub this.getHibernateTemplate().saveOrUpdate(news); } public void valiadteByEditor(News news, String b) { // TODO Auto-generated method stub news.setNews_check1(b); } public void validateByIsAssociateEditorValid(News news, String b) { // TODO Auto-generated method stub news.setNews_check2(b); } public List<News> getCheck1News() { String judg="TRUE"; List<News> n1=getHibernateTemplate().find("from News news where news.news_check1 =?", judg); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public List<News> getUncheck1News() { String judg="FALSE"; List<News> n1=getHibernateTemplate().find("from News news where news.news_check1 =?", judg); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public List<News> getCheck2News() { String judg="TRUE"; List<News> n1=getHibernateTemplate().find("from News news where news.news_check2 =?", judg); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public List<News> getUncheck2News() { String judg="FALSE"; List<News> n1=getHibernateTemplate().find("from News news where news.news_check2 =?", judg); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public List<News> getAllCheckNews() { String judg="TRUE"; List<News> n1=this.getHibernateTemplate().find("from News news where news.news_check2 =? and news.news_check1 =?", new String[]{judg, judg}); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public List<News> getAllUncheckNews() { String judg="FALSE"; List<News> n1=this.getHibernateTemplate().find("from News news where news.news_check2 =? and news.news_check1 =?", new String[]{judg, judg}); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } public void firstCheck(News news) { String judg="TRUE"; news.setNews_check1(judg); this.getHibernateTemplate().saveOrUpdate(news); } public void secondCheck(News news) { String judg="TRUE"; news.setNews_check2(judg); this.getHibernateTemplate().saveOrUpdate(news); } public List<News> getNationalDayNews() { int nation=18; List<News> n1=getHibernateTemplate().find("from News news where news.menu2_id =?", nation); if(n1!=null&&n1.size()>=1) { return n1; } else return null; } }