/**
*  Title  財務管理系統
*  @author: trowa
*  Company: http://www.upol.cn
*  Copyright: Copyright (c) 2004
*  @version 1.0
*  登陸信息表中的一些查詢操作
*/

//顯示登陸信息
package caiwu;

import java.sql.*;
import java.util.*;

public class DispLog extends Log{
    public ResultSet rs;
    public DispLog() {}
/*
* 獲得所有用戶的登陸信息
*/
    public Vector allLog() {
        DBConnect dbc = null;
        Vector allLogVector = new Vector();

        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("SELECT * FROM userlog order by id desc");
                rs = dbc.executeQuery();
                        while(rs.next()){
                        Log log = new Log();
                        log.setId(rs.getInt("id"));
                        log.setUser(rs.getString("user"));
                        log.setLogindate(rs.getString("logindate"));
                        log.setLogoutdate(rs.getString("logoutdate"));
                        log.setIp(rs.getString("ip"));
                        allLogVector.add(log);
                }
        }catch(Exception e){
                System.err.println("error:"+e);
        }finally{
                try{
                        dbc.close();
                }catch(Exception e){
                        e.printStackTrace();
                }
        }
        return allLogVector;
}

/*
* 獲得登陸信息的id號
*/
public int getlogid() {
            int logid=0;
            DBConnect dbc = null;
            try{
                    dbc  = new DBConnect();
                    dbc.prepareStatement("SELECT * FROM userlog where user=?");
                    dbc.setString(1,user);
                    rs = dbc.executeQuery();
                            while(rs.next()){
                            logid=rs.getInt("id");

                    }
            }catch(Exception e){
                    System.err.println("error:"+e);
            }finally{
                    try{
                            dbc.close();
                    }catch(Exception e){
                            e.printStackTrace();
                    }
            }
            return logid;
}
/*
* 獲得登陸信息的總記錄數
*/
public int lognum() {
                DBConnect dbc = null;
                int logcount = 0;
                try{
                        dbc  = new DBConnect();
                        dbc.prepareStatement("SELECT count(*) FROM userlog");
                        rs = dbc.executeQuery();
                        if(rs.next())	logcount = rs.getInt(1);
                }catch(Exception e){
                        System.err.println(e);
                }finally{
                        try{
                                dbc.close();
                        }catch(Exception e){
                                e.printStackTrace();
                        }
                }
                return logcount;
        }

}