newspicmanager.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:   NewsPicManager.java

package news;

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

public class NewsPicManager
{

    public NewsPicManager()
    {
    }

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

    public int getMaxID()
    {
        DBManager dbmanager = new DBManager();
        String s = "select max(pid) from NewsPic";
        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("NewsPicManager.getMaxID() : " + sqlexception.getMessage());
        }
        return i;
    }

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

    public void insertPicSet(int i)
    {
        DBManager dbmanager = new DBManager();
        ResultSet resultset = dbmanager.execQuery("select * from VirtualPicTable");
        try
        {
            while(resultset != null && resultset.next()) 
            {
                String s = "insert into NewsPic values(" + (getMaxID() + 1) + "," + i + ",'" + resultset.getString("PicPathName").trim() + "','" + resultset.getString("PicName").trim() + "','" + resultset.getString("PicOldName").trim() + "')";
                dbmanager.execInsert(s);
            }
            deleteVirtualTable();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("PicManager.insertPicSet() : " + sqlexception.getMessage());
        }
    }

    public ResultSet getVirtualPicSet()
    {
        return (new DBManager()).execQuery("select * from VirtualPicTable order by PicID asc");
    }

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

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

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

    public boolean insertVirtualTable(int i, String s, String s1, String s2)
    {
        String s3 = "insert into VirtualPicTable values(" + i + ",'" + s1 + "','" + s + "','" + s2 + "')";
        System.out.println("now is :" + s3);
        return (new DBManager()).execInsert(s3);
    }

    public boolean isNewsHavePic(int i)
    {
        boolean flag = false;
        ResultSet resultset = (new DBManager()).execQuery("select * from NewsPic where nid=" + i);
        try
        {
            if(resultset != null && resultset.next())
            {
                flag = true;
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("PicManager.isNewsHavePic() : " + sqlexception.getMessage());
        }
        return flag;
    }

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