news.java

基于Struts的学校新闻发布系统

// Decompiled by Jad v1.5.7f. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) 
// Source File Name:   News.java

package StudyNews;

import java.io.PrintStream;
import java.sql.ResultSet;
import java.util.Vector;

// Referenced classes of package StudyNews:
//            DB, Type

public class News
{

    public News()
    {
    }

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

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

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

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

    public void setTime(String time)
    {
        this.time = time;
    }

    public void setKeyword(String keyword)
    {
        this.keyword = keyword;
    }

    public void setType(int type)
    {
        this.type = type;
    }
    
    public void setViewCount(int viewCount)
    {
        this.viewCount = viewCount;
    }

    public int getId()
    {
        return id;
    }

    public String getTitle()
    {
        return title;
    }

    public String getContent()
    {
        return content;
    }

    public String getAuthor()
    {
        return author;
    }

    public String getTime()
    {
        return time;
    }

    public String getKeyword()
    {
        return keyword;
    }

    public int getType()
    {
        return type;
    }
    
    public int getViewCount(){
    	return viewCount;
    }

    public boolean Insert(DB db)
        throws Exception
    {
        String strSql = "Select max(id) From news";
        ResultSet rs = db.OpenSql(strSql);
        int iMaxId;
        if(rs.next())
            iMaxId = rs.getInt(1) + 1;
        else
            iMaxId = 1;
        strSql = "insert into news values(" + iMaxId + ",'" + title + "','" + content + "','" + author + "',getdate(),'" + keyword + "'," + type + ")";
        return db.ExecSql(strSql) != 0;
    }

    public boolean Edit(DB db)
        throws Exception
    {
        String strSql = "update news set title='" + title + "'," + " content='" + content + "'," + " author='" + author + "'," + " keyword='" + keyword + "'," + " type=" + type + " where id=" + id;
        return db.ExecSql(strSql) != 0;
    }

    public static Vector SearchNewsTitle(DB db)
        throws Exception
    {
        Vector newsType = new Vector();
        String strSql = null;
        strSql = "select * from type";
        Vector newsList;
        for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList:        " + newsList.size()))
        {
            Type type = new Type();
            type.setTypeId(typeRs.getInt("typeId"));
            type.setTypeName(typeRs.getString("typeName"));
            newsList = new Vector();
            newsList.add(type);
            strSql = "select top 5* from news where type=" + typeRs.getInt("typeId") + " order by time desc";
            News news;
            for(ResultSet newsRs = db.OpenSql(strSql); newsRs.next(); newsList.add(news))
            {
                news = new News();
                news.setId(newsRs.getInt("id"));
                news.setTitle(newsRs.getString("title"));
                news.setTime(newsRs.getString("time"));
                news.setType(newsRs.getInt("type"));
            }

            newsType.add(newsList);
        }

        System.out.println("\nnewsType:    " + newsType.size());
        return newsType;
    }

    public static Vector SearchNewsTitle(DB db, int typeId, int pageId)
        throws Exception
    {
        Vector newsType = new Vector();
        String strSql = null;
        strSql = "select * from type where typeid=" + typeId;
        Vector newsList;
        for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList:        " + newsList.size()))
        {
            Type type = new Type();
            type.setTypeId(typeRs.getInt("typeId"));
            type.setTypeName(typeRs.getString("typeName"));
            newsList = new Vector();
            newsList.add(type);
            strSql = "select * from news where type=" + typeId + " order by time desc";
            ResultSet newsRs = db.OpenSql(strSql);
            int iCount = 0;
            int iCurRecord = pageId * 10 + 1;
            if(newsRs.absolute(iCurRecord)){
            do
            {
                News news = new News();
                news.setId(newsRs.getInt("id"));
                news.setTitle(newsRs.getString("title"));
                news.setTime(newsRs.getString("time"));
                news.setType(newsRs.getInt("type"));
                newsList.add(news);
            } while(++iCount < 10 && newsRs.next());
            }
            newsType.add(newsList);
        }

        System.out.println("\nnewsType:    " + newsType.size());
        strSql = "select * from type where typeid<>" + typeId;
        Type type;
        for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); newsType.add(type))
        {
            type = new Type();
            type.setTypeId(typeRs.getInt("typeId"));
            type.setTypeName(typeRs.getString("typeName"));
        }

        System.out.println("\nnewsType:    " + newsType.size());
        return newsType;
    }

    public static Vector SearchNewsTitle(DB db, int typeId, int pageId,String keyword)
    throws Exception
{
    Vector newsType = new Vector();
    String strSql = null;
    strSql = "select * from type where typeid=" + typeId;
    Vector newsList;
    for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList:        " + newsList.size()))
    {
        Type type = new Type();
        type.setTypeId(typeRs.getInt("typeId"));
        type.setTypeName(typeRs.getString("typeName"));
        newsList = new Vector();
        newsList.add(type);
        strSql = "select * from news where type=" + typeId  +" and( title like '%"+keyword+"%' )"+" order by time desc";
        ResultSet newsRs = db.OpenSql(strSql);
        int iCount = 0;
        int iCurRecord = pageId * 10 + 1;
        if(newsRs.absolute(iCurRecord)){
        do
        {
            News news = new News();
            news.setId(newsRs.getInt("id"));
            news.setTitle(newsRs.getString("title"));
            news.setTime(newsRs.getString("time"));
            news.setType(newsRs.getInt("type"));
            newsList.add(news);
            System.out.println("------------"+newsRs.getString("title"));
        } while(++iCount < 10 && newsRs.next());
        }
        newsType.add(newsList);
    }

    System.out.println("\nnewsType:    " + newsType.size());
    strSql = "select * from type where typeid<>" + typeId;
    Type type;
    for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); newsType.add(type))
    {
        type = new Type();
        type.setTypeId(typeRs.getInt("typeId"));
        type.setTypeName(typeRs.getString("typeName"));
    }

    System.out.println("\nnewsType:    " + newsType.size());
    return newsType;
}
    
    public static Vector SearchRelativeNews(DB db, int newsId, String keyword)
        throws Exception
    {
        Vector newsList = new Vector();
        String strSql = null;
        strSql = "select * from news where id<>" + newsId + " and keyword like '%" + keyword + "%' order by time desc";
        News news;
        for(ResultSet rs = db.OpenSql(strSql); rs.next(); newsList.add(news))
        {
            news = new News();
            news.setId(rs.getInt("id"));
            news.setTitle(rs.getString("title"));
            news.setTime(rs.getString("time"));
        }

        System.out.println("newsList:        " + newsList.size());
        return newsList;
    }

    public static News GetDetail(DB db, int newsId, boolean bEdit)
        throws Exception
    {
        Vector newsList = new Vector();
        String strSql = null;
        String rplContent = null;
        strSql = "select * from news where id = " + newsId;
        ResultSet rs = db.OpenSql(strSql);
        News news = new News();
        if(rs.next())
        {
            news.setId(newsId);
            news.setTitle(rs.getString("title"));
            news.setAuthor(rs.getString("author"));
            rplContent = rs.getString("content");
            if(!bEdit)
                rplContent = rplContent.replaceAll("\n", "<br>");
            news.setContent(rplContent);
            news.setTime(rs.getString("time"));
            news.setKeyword(rs.getString("keyword"));
            news.setType(rs.getInt("type"));
            news.setViewCount(rs.getInt("viewcount")+1);
            
            strSql="update news set viewcount='"+(rs.getInt("viewcount")+1)+"' where id='"+newsId+"'";
            db.ExecSql(strSql);
        }
        return news;
    }

    public static boolean Delete(DB db, int newsId)
        throws Exception
    {
        String strSql = "delete from news where id='" + newsId + "'";
        return db.ExecSql(strSql) != 0;
    }

    public static int GetNewsCount(DB db, int typeId)
        throws Exception
    {
        int newsCount = 0;
        String strSql = "select count(*) from news where type=" + typeId;
        ResultSet rs = db.OpenSql(strSql);
        if(rs.next())
            newsCount = rs.getInt(1);
        return newsCount;
    }

    protected int id;
    protected String title;
    protected String content;
    protected String author;
    protected String time;
    protected String keyword;
    protected int type;
    protected int viewCount;
}