本文共 5310 字，大约阅读时间需要 17 分钟。

package bdqn.newsManage.Dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import bdqn.newsManage.Dao.BaseDao;
import bdqn.newsManage.Dao.newsTbDao;
import bdqn.newsManage.entity.newsTb;
/**
 * ���������������������������
 */
public class newsTbDaoImpl extends BaseDao implements newsTbDao {
    // ������������������
    public List
   
     getNewsTbAll() {
        List
    
      newsList = new ArrayList
     
      ();
        String sql = "SELECT * FROM newsTb";
        try {
            ResultSet rs = executeQuery(sql, null);
            while (rs.next()) {
                newsTb 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"));
                newsList.add(news);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeAll();
        }
        return newsList;
    }
    // ������������
    public int addNewsTb(newsTb news) {
        int result = 0;
        List