indexdao.java

有发布

package DB;

import bean.newsBean;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.sql.PreparedStatement;
import bean.ConnectionBean;
import java.sql.Connection;

public class indexDAO {
    public indexDAO(){}

    //获取政治新闻的前五条数据
    public ArrayList Selectzhengzhi() {
        ArrayList list = new ArrayList();
        ConnectionBean conbean = new ConnectionBean();
        Connection conn = null;
        ResultSet ret = null;
        PreparedStatement stmt = null;
        try {

            conn = conbean.getConnection();
            stmt = conn.prepareStatement(
                    "select top 5 * from newsall where kindID = 'zhengzhi'");
            ret = stmt.executeQuery();

            while (ret.next()) {
                newsBean bean = new newsBean();
                bean.setID(ret.getString("ID"));
                bean.setNewsname(ret.getString("Newsname"));
                bean.setNewspath(ret.getString("Newspath"));
                bean.setNewstime(ret.getString("Newstime"));
                bean.setNewsouter(ret.getString("Newsouter"));

                list.add(bean);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                ret.close();
                stmt.close();
                conn.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
        return list;
    }


    //获取教育新闻的前五条数据
    public ArrayList Selectjiaoyu() {
        ArrayList list = new ArrayList();
        ConnectionBean conbean = new ConnectionBean();
        Connection conn = null;
        ResultSet ret = null;
        PreparedStatement stmt = null;
        try {

            conn = conbean.getConnection();
            stmt = conn.prepareStatement(
                    "select top 5 * from newsall where kindID = 'jiaoyu'");
            ret = stmt.executeQuery();

            while (ret.next()) {
                newsBean bean = new newsBean();
                bean.setID(ret.getString("ID"));
                bean.setNewsname(ret.getString("Newsname"));
                bean.setNewspath(ret.getString("Newspath"));
                bean.setNewstime(ret.getString("Newstime"));
                bean.setNewsouter(ret.getString("Newsouter"));

                list.add(bean);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                ret.close();
                stmt.close();
                conn.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
        return list;
    }

    //获取台湾新闻的前五条数据
    public ArrayList Selecttaiwan() {
        ArrayList list = new ArrayList();
        ConnectionBean conbean = new ConnectionBean();
        Connection conn = null;
        ResultSet ret = null;
        PreparedStatement stmt = null;
        try {

            conn = conbean.getConnection();
            stmt = conn.prepareStatement(
                    "select top 5 * from newsall where kindID = 'taiwan'");
            ret = stmt.executeQuery();

            while (ret.next()) {
                newsBean bean = new newsBean();
                bean.setID(ret.getString("ID"));
                bean.setNewsname(ret.getString("Newsname"));
                bean.setNewspath(ret.getString("Newspath"));
                bean.setNewstime(ret.getString("Newstime"));
                bean.setNewsouter(ret.getString("Newsouter"));

                list.add(bean);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                ret.close();
                stmt.close();
                conn.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
        return list;
    }



}