newsbean.java

来自「学生信息管理系统 jsp + sql + javabean 实现」· Java 代码 · 共 147 行

package sms.bean;

import java.io.Serializable;
import java.util.ArrayList;
import sms.db.*;
import java.sql.ResultSet;
import java.sql.*;

public class NewsBean implements Serializable {
    private String addTime;
    private String author;
    private String content;
    private String id;
    private String quarry;
    private String title;
    private String typeId;
    public String getAddTime() {
        return addTime;
    }

    public void setAddTime(String addTime) {
        this.addTime = addTime;
    }

    public void setTypeId(String typeId) {
        this.typeId = typeId;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public void setQuarry(String quarry) {
        this.quarry = quarry;
    }

    public void setId(String id) {
        this.id = id;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getAuthor() {
        return author;
    }

    public String getContent() {
        return content;
    }

    public String getId() {
        return id;
    }

    public String getQuarry() {
        return quarry;
    }

    public String getTitle() {
        return title;
    }

    public String getTypeId() {
        return typeId;
    }

    /**
     * 按类型查询新闻标题内容
     * @param typeId 新闻类型，rowLimit 查询行数限制
     * @return 成功返回NewsBean组成的ArrayList，失败返回null
     */
    public ArrayList queryTitle(String typeId, int rowLimit) {
        String sql = "select * from news_info where 1=1";
        if(typeId != null && !typeId.equals("")){
          sql += " and type='" + typeId + "'";
        }
        sql += " order by add_time desc";
        if (rowLimit > 0) {
            sql += " limit " + String.valueOf(rowLimit);
        }
        DBAccess dba = new DBAccess();
        ArrayList aList = new ArrayList();
        try {
            dba.getConnection();
            ResultSet rs = null;
            rs = dba.query(sql);
            if (rs != null) {
                while (rs.next()) {
                    NewsBean newsBean = new NewsBean();
                    newsBean.setId(rs.getString("id"));
                    newsBean.setTitle(rs.getString("title"));
                    newsBean.setAddTime(rs.getString("add_time"));
                    newsBean.setAuthor(rs.getString("author"));
                    //newsBean.setContent(rs.getString("content"));
                    newsBean.setQuarry(rs.getString("quarry"));
                    aList.add(newsBean);
                }
            }
            return aList;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        } finally {
            dba.closeConnection();
        }
    }

    /**
     * 按新闻编号查询新闻详细内容
     * @param newsId 新闻类型
     * @return 成功返回NewsBean，失败返回null
     */
    public NewsBean queryDetail(String newsId) {
        String sql = "select * from news_info where 1=1";
        sql += " and id='" + newsId + "' order by id desc";
        DBAccess dba = new DBAccess();
        try {
            dba.getConnection();
            ResultSet rs = null;
            rs = dba.query(sql);
            NewsBean newsBean = null;
            if (rs != null && rs.next()) {
                newsBean = new NewsBean();
                newsBean.setId(rs.getString("id"));
                newsBean.setTitle(rs.getString("title"));
                newsBean.setAddTime(rs.getString("add_time"));
                newsBean.setAuthor(rs.getString("author"));
                newsBean.setContent(rs.getString("content"));
                newsBean.setQuarry(rs.getString("quarry"));
                newsBean.setTypeId(rs.getString("type"));
            }
            return newsBean;
        } catch (SQLException ex) {
            return null;
        } finally {
            dba.closeConnection();
        }
    }

}