class.java~8~

新闻发布系统

package dsp.web.admin;

/**
 * <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.database.*;
import dsp.web.admin.*;

public class Class {
	//first：一级栏目名称,second:二级栏目名称
	private String first,second;
	private boolean status;
	private String msg;

	public Class() {
		first = "";
		second = "";
		status = false;
		msg = "";
	}
	public String getFirst() {
		return first;
	}
	public String getMsg() {
		return msg;
	}
	public String getSecond() {
		return second;
	}
	public boolean isStatus() {
		return status;
	}

	public void setSecond(String second) {
		this.second = second;
	}
	public void setMsg(String msg) {
		this.msg = msg;
	}
	public void setFirst(String first) {
		this.first = first;
	}

	/** 添加一级栏目
	 *  status为true,则添加成功
	 */
	public void addFirst() throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "INSERT INTO web_class (classname, flag) VALUES ('" + first + "', 0)";

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

	/** 添加二级栏目
	 *  id:所属一级栏目的id号
	 *  status为true,则添加成功
	 */
	public void addSecond(int id) throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "INSERT INTO web_class (classname, flag) VALUES ('" + second + "', "+id+")";

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

	/** 修改一级栏目
	 *  id:要修改的栏目的编号
	 */
	public void modFirst(int id) throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "UPDATE web_class SET classname='"+first+"' WHERE id="+id;

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

	}

	/** 修改二级栏目
	 *  id1: 要修改的二级栏目的编号
	 *  id2: 所属一级栏目的编号
	 */
	public void modSecond(int id1, int id2) throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "UPDATE web_class SET classname='"+second+"', flag="+id2+" WHERE id="+id1;

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

	}

	/** 删除一级栏目
	 *  id:要删除栏目的ID号
	 *  path :主目录
	 */
	public void delFirst(String path, int id) throws ClassNotFoundException,SQLException{
		Operation conn = new Operation();
		String sql = "SELECT * FROM web_class WHERE flag="+id;
		int  no[]=new int[1];
		ResultSet rs = null;
		int num = 0;
		int i = 0;
		Data news = new Data();

		try{
			//删除文章
			rs = conn.query(sql);

			if(rs.next()){
				num = conn.totalRecord(rs);
				no = new int[num];

				do {
					no[i++] = rs.getInt("id");
				}
				while (rs.next());

				for (i = 0; i < num; i++) {
					sql ="SELECT * FROM web_data WHERE class=" + no[i];

					rs = conn.query(sql);
					while(rs.next()){
						//删除文章
						news.del(path, rs.getInt("id"));
					}
				}
			}

			//删除二级栏目
			sql = "DELETE FROM class WHERE flag="+ id;
			conn.update(sql);

			//删除要删除的一级栏目
			sql = "DELETE FROM class WHERE id="+ id;
			conn.update(sql);

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

	/** 删除二级栏目
	 *  id:要删除栏目的ID号
	 *  path: 主目录
	 */
	public void delSecond(String path, int id) throws ClassNotFoundException,SQLException{
		Operation conn = new Operation();
		Data news = new Data();
		String sql ="SELECT * FROM news WHERE class="+id;
		ResultSet rs = null;
		try{
			rs = conn.query(sql);
			while(rs.next()){
				//删除文章
				news.del(path, rs.getInt("id"));
			}

			//删除要删除的二级栏目
			sql = "DELETE FROM class WHERE id="+ id;
			conn.update(sql);

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