/**
*  Title  新聞管理系統(tǒng)
*  @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(){};

/*
* 管理員發(fā)新聞次數(shù)加一
*/
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();
		}
	}
}	

/*
* 管理員登陸次數(shù)加一
*/
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();
		}
	}
}



}