www.pudn.com > 2_15692.zip > DispMaster.java

/** 
*  Title  新闻管理系统 
*  @author: 陈钢 
*  Company: http://www.pcccp.com 
*  Copyright: Copyright (c) 2003 
*  @version 1.0 
*  管理员表中的一些查询操作 
*/ 
package news.admin; 
 
import news.database.DBConnect; 
import news.news.*; 
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; 
} 
 
/* 
* 查询所有的管理员(按发新闻数排序) 
*/ 
public Vector allMaster() { 
	DBConnect dbc = null; 
	Vector allMasterVector = new Vector(); 
	 
	try{ 
		dbc  = new DBConnect(); 
		dbc.prepareStatement("SELECT * FROM master order by total 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.setTotal(rs.getInt("total")); 
			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.setTotal(rs.getInt("total")); 
			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; 
} 
 
/* 
* 计算管理员的总数 
*/ 
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.setTotal(rs.getInt("total")); 
			master.setClassid(rs.getInt("classid")); 
			master.setLoginnum(rs.getInt("loginnum")); 
		} 
	}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.setTotal(rs.getInt("total")); 
			master.setClassid(rs.getInt("classid")); 
			master.setLoginnum(rs.getInt("loginnum")); 
		} 
	}catch(Exception e){ 
		System.err.println(e); 
	}finally{ 
		try{ 
			dbc.close(); 
		}catch(Exception e){ 
			e.printStackTrace(); 
		} 
	} 
	return master; 
} 
 
}