/**
*  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 DispMaster extends Master{

public boolean ismaster;

public ResultSet rs;

public DispMaster(){};

/*login*/
public boolean chkLogin() throws Exception {
	DBConnect dbc = null;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master WHERE name = ? and pass = ?");
		dbc.setBytes(1,userName.getBytes("GB2312"));
		dbc.setBytes(2,userPassword.getBytes("GB2312"));
		rs = dbc.executeQuery();
		if(!rs.next()){
			ismaster = false;
		}else{
			ismaster = true;
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return ismaster;
}

/*
* 查詢所有的管理員,檢查是否重復
*/
public boolean reLogin() throws Exception {
	DBConnect dbc = null;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master WHERE name = ?");
		dbc.setBytes(1,userName.getBytes("GB2312"));
		rs = dbc.executeQuery();
		if(!rs.next()){
			ismaster = false;
		}else{
			ismaster = true;
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return ismaster;
}

/*
* 查詢所有的管理員(按id排序)
*/
public Vector allMaster() {
	DBConnect dbc = null;
	Vector allMasterVector = new Vector();

	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master order by id desc");
		rs = dbc.executeQuery();
			while(rs.next()){
			Master master = new Master();
			master.setID(rs.getInt("id"));
			master.setUserName(rs.getString("name"));
			master.setUserPassword(rs.getString("pass"));
			master.setJoindate(rs.getString("joindate"));
			master.setClassid(rs.getInt("classid"));
			master.setLoginnum(rs.getInt("loginnum"));
			allMasterVector.add(master);
		}
	}catch(Exception e){
		System.err.println("error:"+e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return allMasterVector;
}

/*
* 查詢所有的管理員(按id排序)
*/
public Vector masterOrderID() {
	DBConnect dbc = null;
	Vector allMasterVector = new Vector();

	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master order by id");
		rs = dbc.executeQuery();
			while(rs.next()){
			Master master = new Master();
			master.setID(rs.getInt("id"));
			master.setUserName(rs.getString("name"));
			master.setUserPassword(rs.getString("pass"));
			master.setJoindate(rs.getString("joindate"));
			master.setClassid(rs.getInt("classid"));
			master.setLoginnum(rs.getInt("loginnum"));
                        master.setUserTruename(rs.getString("truename"));
                        master.setUserIpaddress(rs.getString("ipaddress"));
			allMasterVector.add(master);
		}
	}catch(Exception e){
		System.err.println("error:"+e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return allMasterVector;
}

/*
* 計算管理員的總數
*/
public int masterNum() {
	DBConnect dbc = null;
	int masterCount = 0;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT count(*) FROM master");
		rs = dbc.executeQuery();
		if(rs.next())	masterCount = rs.getInt(1);
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return masterCount;
}

/*
* 根據ID得到管理員
*/
public Master idToMaster() {
	DBConnect dbc = null;
	Master master = new Master();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master WHERE id = ?");
		dbc.setInt(1,ID);
		rs = dbc.executeQuery();
			if(rs.next()){
			master.setID(rs.getInt("id"));
			master.setUserName(rs.getString("name"));
			master.setUserPassword(rs.getString("pass"));
			master.setJoindate(rs.getString("joindate"));
			master.setClassid(rs.getInt("classid"));
			master.setLoginnum(rs.getInt("loginnum"));
                        master.setUserTruename(rs.getString("truename"));
                        master.setUserIpaddress(rs.getString("ipaddress"));
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return master;
}

/*
* 根據用戶名稱得到管理員
*/
public Master nameToMaster() {
	DBConnect dbc = null;
	Master master = new Master();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM master WHERE name = ?");
		dbc.setBytes(1,userName.getBytes("GB2312"));
		rs = dbc.executeQuery();
			if(rs.next()){
			master.setID(rs.getInt("id"));
			master.setUserName(rs.getString("name"));
			master.setUserPassword(rs.getString("pass"));
			master.setJoindate(rs.getString("joindate"));
			master.setClassid(rs.getInt("classid"));
			master.setLoginnum(rs.getInt("loginnum"));
                        master.setUserTruename(rs.getString("truename"));
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return master;
}

}