firsttitlepaging.java

新闻发布系统

package JavaBean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class FirstTitlePaging extends Paging {

	public FirstTitlePaging() {
		super("news","FirstLevelTitle","[Id]");
		// TODO Auto-generated constructor stub
	}

	@Override
	public void doSql(ResultSet rs) {
		FirstLevelTitle title = null;
		try {
			this.lst.clear();
			while(rs.next()) {
				title = new FirstLevelTitle();
				title.setId(rs.getLong("Id"));
				title.setTitleName( rs.getString("TitleName"));
				title.setCreater( rs.getString("Creater"));
				title.setDatatime(rs.getString("CreatTime"));
				this.lst.add(title);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			this.lst.clear();
		} finally {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		this.firstOfPage = ((FirstLevelTitle)this.lst.get(0)).getId();
		this.lastOfPage = ((FirstLevelTitle)this.lst.get(this.lst.size()-1)).getId();
	}

}