ad.java

新闻发布系统

package dsp.web;

/**
 * <p>Title: DSP实验室</p>
 * <p>Description: DSP教学网
 *                 公告类
 * </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author 李艳生
 * @version 1.0
 */

import java.sql.*;
import dsp.utils.*;
import dsp.database.*;

public class Ad {
	String content;
	String date;
	boolean status;  //状态
	String msg;  //提示信息

	public Ad() {
		content = "";
		date = GetDate.getStringDateShort();
		status = false;
		msg = "";
	}

	public void setContent(String content){
		this.content = content;
	}

	public String getContent(){
		return content;
	}
	public String getMsg() {
		return msg;
	}
	public void setMsg(String msg) {
		this.msg = msg;
	}
	public boolean isStatus() {
		return status;
	}

	/** 添加公告信息
	 *
	 */
	public void addAnnounce() throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "INSERT INTO web_ad (ad, time) VALUES ('" + content + "', '" + date + "')";

		try{
			conn.update(sql);
			status = true;
		}
		catch(Exception e){
			status = false;
			msg = e.getMessage();
		}
		finally{
			conn.closestmt();
			conn.closeconn();
		}
	}

	/** 删除公告信息
	 *
	 */
	public void delAnnounce() throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "DELETE FROM web_ad";

		try{
			conn.update(sql);
			status = true;
		}
		catch(Exception e){
			status = false;
			msg = e.getMessage();
		}
		finally{
			conn.closestmt();
			conn.closeconn();
		}
	}
}