newsfilemanager.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:   NewsFileManager.java

package news;

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

public class NewsFileManager
{

    public NewsFileManager()
    {
    }

    public ResultSet getFileSet(int i)
    {
        return (new DBManager()).execQuery("select * from NewsFile where nid=" + i);
    }

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

    public boolean isVirtualTableEmpty()
    {
        ResultSet resultset = (new DBManager()).execQuery("select * from VirtualFileTable");
        try
        {
            if(resultset == null || !resultset.next())
                return true;
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsFileManager.isVirtualTableEmpty() : " + sqlexception.getMessage());
        }
        return false;
    }

    public ResultSet getVirtualFileSet()
    {
        return (new DBManager()).execQuery("select * from VirtualFileTable order by FileID asc");
    }

    public void deleteVirtualTableItem(int i)
    {
        (new DBManager()).execDelete("delete from VirtualFileTable where FileID=" + i);
    }

    public void insertFileSet(int i)
    {
        DBManager dbmanager = new DBManager();
        ResultSet resultset = dbmanager.execQuery("select * from VirtualFileTable");
        try
        {
            while(resultset != null && resultset.next()) 
            {
                String s = "insert into NewsFile values(" + (getMaxID() + 1) + "," + i + ",'" + resultset.getString("FileName").trim() + "','" + resultset.getString("FilePathName").trim() + "')";
                dbmanager.execInsert(s);
            }
            deleteVirtualTable();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsFileManager.insertFileSet() : " + sqlexception.getMessage());
        }
    }

    public void deleteVirtualTable()
    {
        (new DBManager()).execDelete("delete from VirtualFileTable where FileID!=0");
    }

    public int getVirtualTableMaxID()
    {
        int i = 0;
        ResultSet resultset = (new DBManager()).execQuery("select max(FileID) from VirtualFileTable");
        try
        {
            if(resultset != null && resultset.next())
            {
                i = resultset.getInt(1);
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("NewsFileManager.getVirtualTableMaxID() : " + sqlexception.getMessage());
        }
        return i;
    }

    public boolean insertVirtualTable(int i, String s, String s1)
    {
        String s2 = "insert into VirtualFileTable values(" + i + ",'" + s.trim() + "','" + s1.trim() + "')";
        return (new DBManager()).execInsert(s2);
    }

    public static void main(String args[])
    {
        NewsFileManager newsfilemanager = new NewsFileManager();
        System.out.println(newsfilemanager.getMaxID());
        System.out.println(newsfilemanager.isVirtualTableEmpty());
        System.out.println(newsfilemanager.getVirtualTableMaxID());
        newsfilemanager.deleteVirtualTable();
    }
}