新闻发布项目——数据实现类（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;
	}

}