sharticle.java

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

package ntsky.admin.article;
import java.sql.*;
import ntsky.database.*;

public class SHArticle{
	private ResultSet rs = null;
	private int sum;
	DBConnect dbc = new DBConnect();
	//判断有无文章
	public int sum() throws Exception{
		String sql = "select count(articleid) as t from article where state=0;";
		rs=dbc.executeQuery(sql);
		rs.next();
		if(rs != null){
			sum = rs.getInt("t");
			return sum;
		}
		else{
			return 0;
		}
	}
	//获取参数
	public ResultSet rs_shtitle(){
		String sql = "select articleid,title,author,state,date from article where state=0;";
		try{
			rs = dbc.executeQuery(sql);			
		}
		catch(Exception e){
			System.out.println("rs_title" +e.getMessage());
		}
		return rs;
	}
	//关闭指针
	public void close(){
		try{
			if(rs != null){
				rs.close();
			}
		}
		catch(Exception e){
			System.out.print("rs.close"+e.getMessage());
		}
	}
}