package cn.yang.novel.data;

import java.sql.*;
import java.util.*;

import cn.yang.novel.db.*;
import cn.yang.novel.entity.*;
import cn.yang.novel.properties.Proper;

public class FetchData {

	public ArrayList getNoveListsFromDatabase(ResultSet rs) {

		ArrayList rsNovel = new ArrayList();
		NoveList novelist = null;
		//int end	= start + 2999;//包括0-999			
		//int index = 0;
		try {

			//System.out.println(Proper.getDocidfto());

			/*
			if (Proper.is_ISDOCID())
				sql = "SELECT ID, Title, PageCount, HasCount, DocID,"
						+ "Type_flag, intro, author, class,Content_TableName FROM novelList"
						+ " where Type_flag = 1 and docID>="
						+ Proper.getDocidfrom() + " and docId<="
						+ Proper.getDocidfto() + "  order by DocID asc";
*/
			//Statement statment = con.createStatement();

			//ResultSet rs = statment.executeQuery(sql);

			
			
			
			//next : start=1000,end=2000
			
			for (;rs.next();) {	
				
			
			//	System.out.println("index:" + index);
				novelist = new NoveList();

				// 作者
				String author =rs.getString("author");
				if ( author!=null) 
				novelist.setAuthor(author.trim());
				// 類別
				String bookClass = rs.getString("Class");
				if(bookClass!=null)
				novelist.setBookClass(bookClass.trim());
				// 標識
				novelist.setDocID(rs.getInt("docID"));

				novelist.setHasCount(rs.getInt("hasCount"));
				novelist.setID(rs.getInt("ID"));
				// 簡介
				novelist.setIntro(

				rs.getString("intro").replaceAll("<br/>", "").replaceAll(
						"<br>", "").trim());

				novelist.setPageCount(rs.getInt("pageCount"));
				// 書的名稱
				novelist.setTitle(rs.getString("title").trim());
				// 是否能用
				novelist.setType_flag(rs.getInt("type_flag"));
				// 本小說對應的是哪個表的記錄
				novelist
						.setContent_TableName(rs.getString("Content_TableName"));
				rsNovel.add(novelist);
				
				//System.out.println(novelist.getTitle());
				
			}
			rs.close();
			// con.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("COUNT:" + rsNovel.size() );
		return rsNovel;
	}

	// 得到章節，得到章節和頁數目
	public ArrayList getNovelChapter(ResultSet rs ) throws Exception {
		// Db db = new Db();
		// Connection con;

		ArrayList rsChapter = new ArrayList();
		NovelChapter chapter = null;

	

		while (rs.next()) {
			// 章節的編號
			chapter = new NovelChapter();
			chapter.setChapterNo(rs.getInt("ChapterNo"));
			chapter.setDocID(rs.getInt("DocID"));
			chapter.setID(rs.getInt("ID"));
			chapter.setPageFrom(rs.getInt("PageFrom"));
			chapter.setPageTo(rs.getInt("PageTo"));
			chapter.setTitle(rs.getString("Title"));
			
			
			//System.out.println(chapter.getTitle());
			rsChapter.add(chapter);
		}
rs.close();
		return rsChapter;
	}

	// 得到各章節的內容
	public Hashtable getNovelContent(ResultSet rs)
			throws Exception {

	//	int charNo = novelChapter.getChapterNo();
	//	int docId = novelChapter.getDocID();
		//int pageFrom = novelChapter.getPageFrom();
		//int pageTo = novelChapter.getPageTo();
		//String title = novelChapter.getTitle();
		String content = null;

		//StringBuffer strBuff = new StringBuffer();
		//prepatedStatement.setString(1,novelContent_n);
	
		//prepatedStatement.setInt(2, pageFrom - 1);
		//prepatedStatement.setInt(3, pageTo + 1);

		
		//	System.out.println("Content:" + prepatedStatement.toString());

		//prepatedStatement.g
		//System.out.println( prepatedStatement.g() );
		//StringBuffer strBuff = new StringBuffer();
		Hashtable contentHash = new Hashtable();
		
		while (rs.next()) {
			content = rs.getString("Content").replaceAll("<br/>", "\n")
					.replaceAll("<br>", "").trim();
			int pageNo = rs.getInt( "pageno");
			contentHash.put( new Integer(pageNo) , content);
			
		}
		rs.close();
		return contentHash;
	
	}

	// 測試 使用
	public static void main(String[] args) {
		FetchData fetchData = new FetchData();

	}
}