新闻发布项目——数据实现类（newsTbDaoImpl）

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;
  }
}