newstypemanager.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:   NewsTypeManager.java

package news;

import common.DBManager;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;

public class NewsTypeManager
{

    public NewsTypeManager()
    {
    }

    public int getMaxTypeID()
    {
        DBManager dbmanager = new DBManager();
        String s = "select max(tid) from NewsType";
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next())
                return resultset.getInt(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsTypeManager.getMaxTypeID : " + sqlexception.getMessage());
        }
        return -1;
    }

    public ResultSet getNewsTypeSet()
    {
        return (new DBManager()).execQuery("select * from NewsType");
    }

    public String getTypeName(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "select * from NewsType where tid=" + i;
        ResultSet resultset = dbmanager.execQuery(s);
        String s1 = null;
        try
        {
            if(resultset != null && resultset.next())
            {
                s1 = resultset.getString("typename");
                resultset.close();
                dbmanager.closeManager();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsTypeManager.getTypeName : " + sqlexception.getMessage());
        }
        return s1;
    }

    public void setTypeName(int i, String s)
    {
        DBManager dbmanager = new DBManager();
        String s1 = "update NewsType set typename='" + s + "' where tid=" + i;
        dbmanager.execUpdate(s1);
        dbmanager.closeManager();
    }

    public int getTypeNum()
    {
        int i = 0;
        DBManager dbmanager = new DBManager();
        String s = "select count(*) from NewsType";
        ResultSet resultset = dbmanager.execQuery(s);
        try
        {
            if(resultset != null && resultset.next())
                i = resultset.getInt(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsTypeManger:getTypeNum():" + sqlexception.getMessage());
        }
        return i;
    }

    public int[] getTypeIDArray()
    {
        int ai[] = new int[getTypeNum()];
        DBManager dbmanager = new DBManager();
        String s = "select * from NewsType";
        ResultSet resultset = dbmanager.execQuery(s);
        int i = 0;
        try
        {
            while(resultset != null && resultset.next()) 
                ai[i++] = resultset.getInt(1);
            resultset.close();
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsTypeManger:getTypeNum():" + sqlexception.getMessage());
        }
        return ai;
    }

    public boolean insertNewsType(String s)
    {
        return (new DBManager()).execInsert("insert into NewsType values(" + (getMaxTypeID() + 1) + ",'" + s + "')");
    }

    public void deleteNewsType(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "delete from NewsType where tid=" + i;
        dbmanager.execDelete(s);
        dbmanager.closeManager();
    }

    public static void main(String args[])
    {
        NewsTypeManager newstypemanager = new NewsTypeManager();
        System.out.println(newstypemanager.getMaxTypeID());
        System.out.println(newstypemanager.getTypeName(7));
        System.out.println(newstypemanager.getTypeNum());
        newstypemanager.insertNewsType("mmm");
    }
}