newstypedao.java

有发布

package DB;

import java.sql.*;
import java.util.*;
import bean.ConnectionBean;
import bean.newstypeBean;
import bean.newsBean;


public class newstypeDAO {
    public newstypeDAO() {
    }

    //向数据库中插入数据数据
    public boolean insterfirst(newstypeBean bean) {

        Connection con = null;
        PreparedStatement stmt = null;

        try {
            ConnectionBean dbcon = new ConnectionBean();
            con = dbcon.getConnection();
            stmt = con.prepareStatement(
                    "insert into newskind(kindname,name) values(?,?)");
            stmt.setString(1, bean.getKindname());
            stmt.setString(2, bean.getName());
            stmt.executeUpdate();
            return true;
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        } finally {
            try {
                stmt.close();
                con.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
    }

    //删除新闻信息
    public boolean delectnewstype(newstypeBean bean) {
        //boolean flat = false;
        ConnectionBean dbcon = new ConnectionBean();

        Connection con = null;
        PreparedStatement pre = null;

        try {
            con = dbcon.getConnection();

            //删除新闻表中本条新闻的记录
            pre = con.prepareStatement(
                    "delete from newskind where ID = '" + bean.getID() + "'");
            pre.executeUpdate();

            return true;

        } catch (Exception e) {
            e.printStackTrace();
            return false;
        } finally {
            try {
                //关闭所有连接
                pre.close();
                con.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }

    }

    //获取所有新闻类型的信息
    public ArrayList getnewstype() {
        ArrayList list = new ArrayList();
        Connection con = null;
        ResultSet ret = null;

        try {
            ConnectionBean dbcon = new ConnectionBean();
            con = dbcon.getConnection();
            PreparedStatement pre = con.prepareStatement(
                    "select * from newskind order by ID desc");
            ret = pre.executeQuery();

            while (ret.next()) {
                newstypeBean fTitle = new newstypeBean();
                fTitle.setID(ret.getString("Id"));
                fTitle.setKindname(ret.getString("kindname"));
                fTitle.setName(ret.getString(3));
                list.add(fTitle);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                ret.close();
                con.close();
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
        return list;
    }


}