www.pudn.com > 2_15692.zip > MasterControl.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 news.admin.*; 
import news.util.*;  
import java.sql.*; 
import java.util.*; 
 
public class MasterControl extends Master{ 
 
public ResultSet rs; 
 
public MasterControl(){}; 
 
/* 
* 管理员发新闻次数加一 
*/ 
public void addnewsnum(){ 
DBConnect dbc = null; 
	try{ 
		dbc  = new DBConnect(); 
		dbc.prepareStatement("UPDATE master SET total = total+1 WHERE name = ?"); 
		dbc.setBytes(1,userName.getBytes("GB2312")); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		System.err.println(e); 
	}finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
}	 
 
/* 
* 管理员登陆次数加一 
*/ 
public void addloginnum(){ 
DBConnect dbc = null; 
	try{ 
		dbc  = new DBConnect(); 
		dbc.prepareStatement("UPDATE master SET loginnum = loginnum+1 WHERE name = ?"); 
		dbc.setBytes(1,userName.getBytes("GB2312")); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		System.err.println(e); 
	}finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
} 
 
/* 
* 添加新的管理员 
*/ 
public void addmaster(){ 
DBConnect dbc = null; 
	try{ 
		dbc  = new DBConnect(); 
		dbc.prepareStatement("INSERT INTO master ( name,pass,joindate,classid ) VALUES ( ?,?,?,? )"); 
		dbc.setBytes(1,userName.getBytes("GB2312")); 
		dbc.setBytes(2,userPassword.getBytes("GB2312")); 
		dbc.setBytes(3,GetDate.getStringDateShort().getBytes("GB2312")); 
		dbc.setInt(4,classid); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		System.err.println(e); 
	}finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
}	 
 
/* 
* 删除管理员 
*/ 
public void delmaster(){ 
	DBConnect dbc = null; 
	try{ 
		dbc = new DBConnect(); 
		dbc.prepareStatement("delete from master WHERE id=?"); 
		dbc.setInt(1,ID); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
	} 
	finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
} 
 
/* 
* 修改管理员信息 
*/ 
public void modifymaster(){ 
DBConnect dbc = null; 
	try{ 
		dbc = new DBConnect(); 
		dbc.prepareStatement("UPDATE master SET name=?,pass=?,total=?,classid=?,joindate=?,loginnum=? WHERE id=?"); 
		dbc.setBytes(1,userName.getBytes("GB2312")); 
		dbc.setBytes(2,userPassword.getBytes("GB2312")); 
		dbc.setInt(3,total); 
		dbc.setInt(4,classid); 
		dbc.setBytes(5,joindate.getBytes("GB2312")); 
		dbc.setInt(6,loginnum); 
		dbc.setInt(7,ID); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
	} 
	finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
} 
 
 
 
}