newsdaobean.java

基于Spring2.5的精品课程网站

package org.adam.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.adam.DataSource.DBControl;
import org.adam.bean.NewsBean;
import org.adam.dao.NewsDAO;

public class NewsDAOBean implements NewsDAO {

	private DBControl db;
	
	public void delete(int news_id) {
		String sql="delete from news where news_id="+news_id;
		db.setDataInfo(sql);
	}

	public List<NewsBean> getAllNews() {
		String sql="select * from news";
		ResultSet rs=db.getDataInfo(sql);
		NewsBean news;
		List<NewsBean> list=new ArrayList<NewsBean>();
		try {
			while(rs.next()){
				news=new NewsBean();
				news.setNews_id(rs.getInt("news_id"));
				news.setNewstitle(rs.getString("newstitle"));
				news.setNews(rs.getString("news"));
				news.setNewstime(rs.getString("newstime"));
				list.add(news);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return null;
		}finally{
			db.closeConnection();
		}		
	}

	public NewsBean getNews(int news_id) {
		String sql="select * from news where news_id="+news_id;
		ResultSet rs=db.getDataInfo(sql);
		NewsBean news=new NewsBean();
		try {
			while(rs.next()){
				news.setNews_id(rs.getInt("news_id"));
				news.setNewstitle(rs.getString("newstitle"));
				news.setNews(rs.getString("news"));
				news.setNewstime(rs.getString("newstime"));
			}
			return news;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}	
	}

	public void insert(NewsBean news) {
		String sql="insert into news(newstitle,news,newstime) values('"+news.getNewstitle()+"','"+news.getNews()+"','"+news.getNewstime()+"')";
		db.setDataInfo(sql);
	}

	public DBControl getDb() {
		return db;
	}

	public void setDb(DBControl db) {
		this.db = db;
	}

	public List<NewsBean> getAllNews(int nowpage, int pagecount) {
		String sql="select * from news limit "+(nowpage-1)*pagecount+","+pagecount;
		ResultSet rs=db.getDataInfo(sql);
		NewsBean news;
		List<NewsBean> list=new ArrayList<NewsBean>();
		try {
			while(rs.next()){
				news=new NewsBean();
				news.setNews_id(rs.getInt("news_id"));
				news.setNewstitle(rs.getString("newstitle"));
				news.setNews(rs.getString("news"));
				news.setNewstime(rs.getString("newstime"));
				list.add(news);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return null;
		}finally{
			db.closeConnection();
		}		
	}

}