article.java

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

package ntsky.admin.article;

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


public class Article{

	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;";
		rs=dbc.executeQuery(sql);
		rs.next();
		if(rs != null){
			sum = rs.getInt("t");
			return sum;
		}
		else{
			return 0;
		}
	}
	public ResultSet rs_title(){
		String sql = "select articleid,title,hits,date from article;";
		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());
		}
	}
}