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

/** 
*  Title  新闻管理系统 
*  @author: 陈钢 
*  Company: http://www.pcccp.com 
*  Copyright: Copyright (c) 2003 
*  @version 1.0 
*  对class表的一些增，删，改操作 
*/ 
package news.admin; 
 
import news.database.DBConnect; 
import news.news.*; 
import news.admin.*; 
import news.util.*;  
import java.sql.*; 
import java.util.*; 
 
public class ClassControl extends IClass{ 
 
public ResultSet rs; 
 
public ClassControl(){}; 
 
/* 
* 修改栏目名称 
*/ 
public void modifyclass(){ 
DBConnect dbc = null; 
	try{ 
		dbc = new DBConnect(); 
		dbc.prepareStatement("UPDATE class SET name=? WHERE id=?"); 
		dbc.setBytes(1,name.getBytes("GB2312")); 
		dbc.setInt(2,ID); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
	} 
	finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
} 
 
/* 
* 删除栏目 
*/ 
public void delclass(){ 
	DBConnect dbc = null; 
	try{ 
		dbc = new DBConnect(); 
		dbc.prepareStatement("delete from class WHERE id=?"); 
		dbc.setInt(1,ID); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
	} 
	finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
} 
 
/* 
* 添加新的栏目 
*/ 
public void addclass(){ 
DBConnect dbc = null; 
	try{ 
		dbc  = new DBConnect(); 
		dbc.prepareStatement("INSERT INTO class ( name ) VALUES ( ? )"); 
		dbc.setBytes(1,name.getBytes("GB2312")); 
		dbc.executeUpdate(); 
	}catch(Exception e){ 
		System.err.println(e); 
	}finally{ 
	try{ 
		dbc.close(); 
	}catch(Exception e){ 
		e.printStackTrace(); 
		} 
	} 
}	 
 
 
 
 
 
}