picmanager.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:   PicManager.java

package news;

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

public class PicManager
{

    public PicManager()
    {
    }

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

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

    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 picture values(" + (getMaxID() + 1) + "," + i + ",'" + resultset.getString("FilePathName") + "','" + resultset.getString("FileName") + "')";
                dbmanager.execInsert(s);
            }
            dbmanager.execDelete("delete from VirtualPicTable where FileID!=0");
        }
        catch(SQLException sqlexception)
        {
            System.err.println("PicManager.insertPicSet() : " + sqlexception.getMessage());
        }
    }

    public static void main(String args[])
    {
        PicManager picmanager = new PicManager();
        System.out.println(picmanager.getMaxID());
        System.out.println(picmanager.isVirtualTableEmpty());
        picmanager.insertPicSet(1);
    }
}