usermanager.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:   UserManager.java

package news;

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

public class UserManager
{

    public UserManager()
    {
    }

    public ResultSet getUserSet()
    {
        return (new DBManager()).execQuery("select * from UserInfo group by tid order by uid asc");
    }

    public String getUserLoginName(int i)
    {
        ResultSet resultset = (new DBManager()).execQuery("select loginname from UserInfo where uid=" + i);
        String s = null;
        try
        {
            if(resultset != null && resultset.next())
            {
                s = resultset.getString(1);
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("UserManager.getUserLoginName():" + sqlexception.getMessage());
        }
        return s;
    }

    public String getUserTrueName(int i)
    {
        ResultSet resultset = (new DBManager()).execQuery("select turename from UserInfo where uid=" + i);
        String s = null;
        try
        {
            if(resultset != null && resultset.next())
            {
                s = resultset.getString(1);
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.println("UserManager.getUserLoginName():" + sqlexception.getMessage());
        }
        return s;
    }

    public int getUserType(String s, String s1)
    {
        int i = 0;
        String s2 = "select * from UserInfo where (loginname='" + s + "')" + " And (password='" + s1 + "')";
        DBManager dbmanager = new DBManager();
        ResultSet resultset = dbmanager.execQuery(s2);
        try
        {
            if(resultset != null && resultset.next())
            {
                i = resultset.getInt("tid");
                resultset.close();
            }
        }
        catch(SQLException sqlexception)
        {
            System.err.print("UserManager.getUserType(): " + sqlexception.getMessage());
        }
        dbmanager.closeManager();
        return i;
    }

    public int getUserID(String s, String s1)
    {
        int i = 0;
        String s2 = "select * from UserInfo where (loginname='" + s + "')" + " And (password='" + s1 + "')";
        DBManager dbmanager = new DBManager();
        ResultSet resultset = dbmanager.execQuery(s2);
        if(resultset != null)
            try
            {
                if(resultset.next())
                    i = resultset.getInt("uid");
                resultset.close();
            }
            catch(SQLException sqlexception)
            {
                System.err.print("UserManager.getUserType(): " + sqlexception.getMessage());
            }
        dbmanager.closeManager();
        return i;
    }

    public int getUserNum()
    {
        int i = 0;
        DBManager dbmanager = new DBManager();
        String s = "select count(*) from UserInfo";
        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("UserManger:getUserNum():" + sqlexception.getMessage());
        }
        return i;
    }

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

    public void insertNewUser(String s, String s1, int i, String s2)
    {
        DBManager dbmanager = new DBManager();
        int j = getMaxUserID() + 1;
        String s3 = "insert into UserInfo values(" + j + ",'" + s + "','" + s1 + "'," + i + ",'" + s2 + "','" + "')";
        dbmanager.execInsert(s3);
        dbmanager.closeManager();
    }

    public void deleteUser(int i)
    {
        DBManager dbmanager = new DBManager();
        String s = "delete from UserInfo where uid=" + i;
        dbmanager.execDelete(s);
        dbmanager.closeManager();
    }

    public boolean isUserExisted(String s)
    {
        DBManager dbmanager = new DBManager();
        String s1 = "select * from UserInfo where loginname='" + s + "'";
        ResultSet resultset = dbmanager.execQuery(s1);
        boolean flag = false;
        try
        {
            if(resultset != null && resultset.next())
            {
                flag = true;
                resultset.close();
            }
            dbmanager.closeManager();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("UserManger:getUserNum():" + sqlexception.getMessage());
        }
        return flag;
    }

    public static void main(String args[])
    {
        UserManager usermanager = new UserManager();
        System.out.println(usermanager.getUserType("check", "check"));
        System.out.println(usermanager.isUserExisted("pwbell"));
    }
}