newsmanager.java

jsp制作的一个信息管理系统源码,完整实用版

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

package news;

import common.DBManager;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Time;
import java.util.Date;
import java.util.HashMap;

// Referenced classes of package news:
//            NewsTypeManager

public class NewsManager
{

    public NewsManager()
    {
    }

    public ResultSet getNewsSet(int i)
    {
        return (new DBManager()).execQuery("select * FROM News WHERE tid=" + i + "ORDER BY updatetime desc");
    }

    public ResultSet getTitleNews()
    {
        return (new DBManager()).execQuery("select * FROM News WHERE valid=1 and tid=3 or tid=4 or tid=5 or tid=6 or tid=9 ORDER BY updatetime desc");
    }

    public ResultSet getCheckedNewsSet(int i)
    {
        return (new DBManager()).execQuery("select * FROM News WHERE valid=1 and tid=" + i + " ORDER BY updatetime desc");
    }

    public int getMaxID()
    {
        DBManager dbmanager = new DBManager();
        String s = "select max(nid) FROM News";
        ResultSet resultset = dbmanager.execQuery(s);
        int i = -1;
        try
        {
            if(resultset != null && resultset.next())
                i = resultset.getInt(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getMaxID : " + sqlexception.getMessage());
        }
        return i;
    }

    public String getTitle(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "select * FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        String s1 = null;
        try
        {
            if(resultset != null && resultset.next())
                s1 = resultset.getString("title");
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getMaxID : " + sqlexception.getMessage());
        }
        return s1;
    }

    public void setTitle(int i, String s)
    {
        DBManager dbmanager = new DBManager();
        String s1 = "UPDATE News SET title='" + s + "' WHERE nid=" + i;
        dbmanager.execUpdate(s1);
        dbmanager.closeManager();
    }

    public String getContent(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "select * FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        String s1 = null;
        try
        {
            if(resultset != null && resultset.next())
                s1 = resultset.getString("content");
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getMaxID : " + sqlexception.getMessage());
        }
        return s1;
    }

    public void setContent(int i, String s)
    {
        DBManager dbmanager = new DBManager();
        String s1 = "UPDATE News SET content='" + s + "' WHERE nid=" + i;
        dbmanager.execUpdate(s1);
        dbmanager.closeManager();
    }

    public void setUpdateTime(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "UPDATE News SET updatetime='" + (new Date()).toLocaleString() + "' WHERE nid=" + i;
        dbmanager.execUpdate(s);
        dbmanager.closeManager();
    }

    public String getSource(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "select source FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        String s1 = null;
        try
        {
            if(resultset != null && resultset.next())
                s1 = resultset.getString(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getMaxID : " + sqlexception.getMessage());
        }
        return s1;
    }

    public String getAuthor(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "select author FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        String s1 = null;
        try
        {
            if(resultset != null && resultset.next())
                s1 = resultset.getString(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getMaxID : " + sqlexception.getMessage());
        }
        return s1;
    }

    public int getTypeID(int i)
    {
        DBManager dbmanager = new DBManager();
        ResultSet resultset = dbmanager.execQuery("select tid FROM News WHERE nid=" + i);
        try
        {
            if(resultset != null && resultset.next())
                return resultset.getInt(1);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getNewsTypeID : " + sqlexception.getMessage());
        }
        return 0;
    }

    public String getTypeName(int i)
    {
        return (new NewsTypeManager()).getTypeName(getTypeID(i));
    }

    public String getPostDate(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "SELECT posttime FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next() && resultset.getDate(1) != null)
                return resultset.getDate(1).toString();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getNewsTypeID : " + sqlexception.getMessage());
        }
        return null;
    }

    public String getPostTime(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "SELECT posttime FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next() && resultset.getTime(1) != null)
                return resultset.getTime(1).toString();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getPostTime : " + sqlexception.getMessage());
        }
        return null;
    }

    public String getUpdateDate(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "SELECT updatetime FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next())
                return resultset.getDate(1).toString();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getUpdateDate():" + sqlexception.getMessage());
        }
        return null;
    }

    public String getUpdateTime(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "SELECT updatetime FROM News WHERE nid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next())
                return resultset.getTime(1).toString();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getUpdateTime():" + sqlexception.getMessage());
        }
        return null;
    }

    public boolean isValid(int i)
    {
        ResultSet resultset = (new DBManager()).execQuery("SELECT valid FROM News WHERE nid=" + i);
        try
        {
            if(resultset != null && resultset.next() && resultset.getInt("valid") == 1)
                return true;
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.isValid() : " + sqlexception.getMessage());
        }
        return false;
    }

    public boolean insert(String s)
    {
        return (new DBManager()).execInsert(s);
    }

    public void delete(int i)
    {
        DBManager dbmanager = new DBManager();
        dbmanager.execDelete("delete FROM News WHERE nid=" + i);
        dbmanager.closeManager();
    }

    public void deleteAtType(int i)
    {
        DBManager dbmanager = new DBManager();
        dbmanager.execDelete("delete FROM News WHERE tid=" + i);
        dbmanager.closeManager();
    }

    public void check(int i)
    {
        DBManager dbmanager = new DBManager();
        dbmanager.execUpdate("UPDATE News SET valid=1 WHERE nid=" + i);
        dbmanager.closeManager();
    }

    public void uncheck(int i)
    {
        DBManager dbmanager = new DBManager();
        dbmanager.execUpdate("UPDATE News SET valid=0 WHERE nid=" + i);
        dbmanager.closeManager();
    }

    public int getReadCount(int i)
    {
        int j = 0;
        ResultSet resultset = (new DBManager()).execQuery("SELECT readcount FROM News WHERE nid=" + i);
        try
        {
            if(resultset != null && resultset.next())
            {
                j = resultset.getInt(1);
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.isValid() : " + sqlexception.getMessage());
        }
        return j;
    }

    public boolean setReadCount(int i)
    {
        return (new DBManager()).execUpdate("UPDATE News SET readcount=" + (getReadCount(i) + 1) + " WHERE nid=" + i);
    }

    public HashMap getNewestPicNews()
    {
        HashMap hashmap = new HashMap();
        ResultSet resultset = (new DBManager()).execQuery("SELECT * FROM News ORDER BY updatetime desc");
        try
        {
            if(resultset != null && resultset.next())
            {
                int i = resultset.getInt("nid");
                ResultSet resultset1 = (new DBManager()).execQuery("SELECT * FROM NewsPic WHERE nid=" + i);
                hashmap.put("nid", new Integer(i));
                if(resultset1 != null && resultset1.next())
                    hashmap.put("path", new String(resultset1.getString("picpathname").trim()));
                hashmap.put("brief", new String(resultset.getString("content").substring(0, 90) + " ... " + "请看详细报道 " + getPostDate(i)));
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsManager.getNewestPicNews() : " + sqlexception.getMessage());
        }
        return hashmap;
    }

    public String htmEncode(String s)
    {
        StringBuffer stringbuffer = new StringBuffer();
        int i = s.length();
        for(int j = 0; j < i; j++)
        {
            char c = s.charAt(j);
            switch(c)
            {
            case 60: // '<'
                stringbuffer.append("&lt;");
                break;

            case 62: // '>'
                stringbuffer.append("&gt;");
                break;

            case 38: // '&'
                stringbuffer.append("&amp;");
                break;

            case 34: // '"'
                stringbuffer.append("&quot;");
                break;

            case 169: 
                stringbuffer.append("&copy;");
                break;

            case 174: 
                stringbuffer.append("&reg;");
                break;

            case 165: 
                stringbuffer.append("&yen;");
                break;

            case 8364: 
                stringbuffer.append("&euro;");
                break;

            case 8482: 
                stringbuffer.append("&#153;");
                break;

            case 13: // '\r'
                if(j < i - 1 && s.charAt(j + 1) == '\n')
                {
                    stringbuffer.append("<br>\n&nbsp;&nbsp;");
                    j++;
                }
                break;

            case 32: // ' '
                if(j < i - 1 && s.charAt(j + 1) == ' ')
                {
                    stringbuffer.append("&nbsp;");
                    j++;
                }
                break;

            default:
                stringbuffer.append(c);
                break;
            }
        }

        return new String(stringbuffer.toString());
    }

    public static void main(String args[])
    {
        NewsManager newsmanager = new NewsManager();
        System.out.println(newsmanager.getPostDate(1) + " " + newsmanager.getPostTime(1));
        HashMap hashmap = newsmanager.getNewestPicNews();
        System.out.println(hashmap.containsKey("nid"));
        System.out.println(hashmap.get("nid"));
        System.out.println(hashmap.containsKey("path"));
        System.out.println(hashmap.get("path"));
        System.out.println(hashmap.containsKey("brief"));
        System.out.println(hashmap.get("brief"));
    }
}