kind.java

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

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：类别管理
*   代码编写：姚君林
*   编写日期：2003/4/1
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin.column;
import java.sql.*;
import ntsky.database.*;
public class Kind{
	private String set_kind = null;
	private int set_column;
	private int set_num;
	private int sum;
	private ResultSet rs = null;
	private int set_id;
	
	DBConnect dbc = new DBConnect();

	//栏目ID的总值
	public int sum() throws Exception{
		String sql = "select count(classid) as t from class;";
		rs=dbc.executeQuery(sql);
		rs.next();
		if(rs != null){
			sum = rs.getInt("t");
			return sum;
		}
		else{
			return 0;
		}
	}
	//栏目列表
	public ResultSet rs_columnt(){
		try{
			String sql = "select classid,content from class;";
			rs=dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("Column:"+e.getMessage());
		}
		return rs;
	}

	//classid的值
	public int set_num(int num) throws Exception{
		this.set_num=num;
		return this.set_num;
	}
	//ResultSet值
	public ResultSet rs_kind(){
		String sql = "select id,classid,content from kind where classid=?";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,set_num);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("kind:"+e.getMessage());
		}
		return rs;
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
		}
	}
}