package com.autumn.pojo.oper;

import java.io.UnsupportedEncodingException;
import java.util.Iterator;

import com.autumn.pojo.Borrowed;
import com.autumn.pojo.History;
import com.autumn.pojo.Reader;


public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		ReaderOper ro = new ReaderOper() ;
		BookOper booko = new BookOper() ;
		
		
		BorrowedOper boro = new BorrowedOper() ; 
//		在borrowed表中插入一條結束記錄
		Borrowed bor= new Borrowed() ;
//		Reader reader = ro.queryById("05080116") ;
//		System.out.println(reader) ;
//		Book book = booko.queryByCode("JDC0875909") ;
//		bor.setBcode("JDC0875909") ;
//		bor.setRid("05080116") ;
//		bor.setOut("20080123") ;
//		bor.setBack("20080312") ;
//		bor.setBook(book) ;
//		bor.setReader(reader);
//		boolean l = boro.insert(bor) ;
//		System.out.println(l) ;
		
		//刪除borrowed表中的記錄
//		boro.delete("JDC0875909") ;
		
		//查詢讀者歷史記錄
//		Reader reader = ro.queryById("05080116") ;
//		System.out.println(reader.getHistory()) ;
//		Iterator ite = reader.getHistory().iterator() ;
//		while(ite.hasNext())
//		{
//			History h = (History)ite.next() ;
//			try {
//				System.out.println(new String(h.getBook().getName().getBytes("ISO8859-1"),"GBK")) ;
//			} catch (UnsupportedEncodingException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//			try {
//				System.out.println(new String(h.getReader().getName().getBytes("ISO8859-1"),"GBK")) ;
//			} catch (UnsupportedEncodingException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//		}
		

		
		//查詢borrowed記錄
//		String rid="05080116" ;
//		Reader reader = ro.queryById(rid) ;
//		System.out.println(reader.getBorrowed()) ;
//		Iterator ite = reader.getBorrowed().iterator() ;
//		System.out.println("借閱證號："+rid) ;
//		while(ite.hasNext())
//		{
//			Borrowed b = (Borrowed)ite.next() ;
//			System.out.println("書號"+b.getBcode()) ;
//			try {
//				System.out.println(new String(b.getBook().getAuthor().getBytes("ISO8859-1"),"GBK")) ;
//			} catch (UnsupportedEncodingException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//		}
		//判斷讀者是否存在
		Reader reader = new Reader();
		reader.setId("0508016") ;
		reader.setPassword("wj129") ;
		boolean bl = ro.exsit(reader) ;
		System.out.println(bl) ;
	}

}