column.java

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

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：大栏目管理
*   代码编写：姚君林
*   编写日期：2003/4/1
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin.column;

import java.sql.*;
import ntsky.database.*;

public class Column{
	private ResultSet rs = null;
	private int sum;
	DBConnect dbc = new DBConnect();

	//列出栏目的值
	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;
	}
	//记录总值(判断有没有选择)
	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 void close() throws Exception{
		if(rs != null){
			dbc.close();
			rs.close();
		}
	}
}