newscontrol.java

小虫新闻管理系统 V1.0(jsp+javabean+mysql)

/**
*  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 NewsControl extends News{

public ResultSet rs;

private int newsid;

public NewsControl(){};

/*
* 添加新闻
*/
public int insertnews(){
	DBConnect dbc = null;
	try{
		dbc = new DBConnect();
		dbc.prepareStatement("INSERT INTO news ( topic,body,adddate,adduser,rootid,pic ) VALUES ( ?,?,?,?,?,? )");
		dbc.setBytes(1,topic.getBytes("GB2312"));
		dbc.setBytes(2,body.getBytes("GB2312"));
		dbc.setBytes(3,GetDate.getStringDate().getBytes("GB2312"));
		dbc.setBytes(4,adduser.getBytes("GB2312"));
		dbc.setInt(5,rootID);
		dbc.setBytes(6,pic.getBytes("GB2312"));
		dbc.executeUpdate();
		
		dbc.prepareStatement("SELECT max(id) FROM news");
		rs = dbc.executeQuery();
		if(rs.next())
				newsid = rs.getInt(1);
		
	}catch(Exception e){
			System.err.println(e);
		}finally{
			try{
				dbc.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	return newsid;
}

/*
* 修改新闻
*/
public void modifynews(){
DBConnect dbc = null;
	try{
		dbc = new DBConnect();
		dbc.prepareStatement("UPDATE news SET topic=?,body=?,rootid=?,pic=? WHERE id=?");
		dbc.setBytes(1,topic.getBytes("GB2312"));
		dbc.setBytes(2,body.getBytes("GB2312"));
		dbc.setInt(3,rootID);
		dbc.setBytes(4,pic.getBytes("GB2312"));
		dbc.setInt(5,ID);
		dbc.executeUpdate();
	}catch(Exception e){
		e.printStackTrace();
	}
	finally{
	try{
		dbc.close();
	}catch(Exception e){
		e.printStackTrace();
		}
	}
}

/*
* 删除新闻
*/
public void delnews(){
	try{
		DBConnect dbc = new DBConnect();
		dbc.prepareStatement("delete from news WHERE id=?");
		dbc.setInt(1,ID);
		dbc.executeUpdate();
		dbc.close();
	}catch(Exception e){
		e.printStackTrace();
	}
}

/*
* 新闻浏览次数加一
*/
public void addhits(){
DBConnect dbc = null;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("UPDATE news SET hits = hits +1 WHERE id = ?");
		dbc.setInt(1,ID);
		dbc.executeUpdate();
	}catch(Exception e){
		System.err.println(e);
	}finally{
	try{
		dbc.close();
	}catch(Exception e){
		e.printStackTrace();
		}
	}
}	

}