addarticle.java

来自「NTsky新闻发布v1.0(提供JavaBean)」· Java 代码 · 共 78 行

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：添加文章
*   代码编写：姚君林
*   编写日期：2003/4/5
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin.article;
import java.sql.*;
import ntsky.database.*;
public class AddArticle{
	private ResultSet rs = null;
	private int sum;
	DBConnect dbc = new DBConnect();
	//栏目
	public ResultSet rs_column(){
		String sql = "select classid,content from class;";
		try{
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("rs_column:" + e.getMessage());
		}
		return rs;
	}
	//栏目总和
	public int sum_column() throws Exception{
		String sql = "select count(classid) as t from class;";
		rs = dbc.executeQuery(sql);
		if(rs != null){
			rs.next();
			sum = rs.getInt("t");
			return sum;
		}
		else{
			return 0;
		}
	}
	//类别
	public ResultSet rs_kind(){
		String sql = "select id,content,classid from kind;";
		try{
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("rs_kind:" + e.getMessage());
		}
		return rs;
	}
	//类别总和
	/**
	public int sum_kind() throws Exception{
		String sql = "select count(id) as t from kind;";
		rs = dbc.executeQuery(sql);
		if(rs != null){
			rs.next();
			sum = rs.getInt("t");
			return sum;
		}
		else{
			return 0;
		}
	}
	*/
/**
*关闭指针
*/
	public void close() throws Exception{
		if(rs != null){
			dbc.close();
			rs.close();
			rs = null;
		}
	}
}