column.java

NTsky新闻发布v1.0(提供JavaBean)

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：大栏目管理
*   代码编写：姚君林
*   编写日期：2003/4/1
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin.column;
import ntsky.database.*;
import java.sql.*;
public class Column{
	private ResultSet rs = null;
	private String set_content = null;
	private int set_classid;
	//pulic(共用)参数
	public int set_classid(int num){
		this.set_classid = num;
		return this.set_classid;
	}
	/**
	*栏目录入	
	*/
	//获取大栏目的结果集
	public ResultSet rs_columnt(){
		try{
			String sql = "select id,classid,content from class where id=1;";
			DBConnect dbc = new DBConnect();
			rs=dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("Column:"+e.getMessage());
		}
		return rs;
	}
	//IOColumn类get过来的值
	public String set_content(String str) throws Exception{
		this.set_content = str;
		return this.set_content;
	}
	//插入数据
	public void insertContent() throws Exception{
		String sql = "insert into class(id,classid,content) VALUES(1,?,?);";
		DBConnect dbc = new DBConnect(sql);
		dbc.setInt(1,set_classid);
		dbc.setString(2,set_content);
		dbc.executeUpdate();
 	}
	/**
	*修改栏目
	*/
	//修改栏目的指针
	public ResultSet rs_editcolumn() throws Exception{
		try{
			String sql = "select content from class where id=1 and classid=?;";
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,set_classid);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("Column:"+e.getMessage());
		}
		return rs;
	}
	//插入数据
	public void inserteditcontent() throws Exception {
		String sql = "update class set content=? where id=1 and classid=?;";
		DBConnect dbc = new DBConnect(sql);
		dbc.setString(1,set_content);
		dbc.setInt(2,set_classid);
		dbc.executeUpdate();
	}
	/**
	*删除栏目
	*/
	public void delcontent() throws Exception{
		String sql = "delete from class where classid=?;";
		DBConnect dbc = new DBConnect(sql);
		dbc.setInt(1,set_classid);
		dbc.executeUpdate();
	}
	/**
	*清空指针
	*/
	public void close() throws Exception{
		if(rs != null){
			rs.close();
		}
	}
}