package com.dao;

import java.io.Reader;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder;
import com.actionForm.BorrowBookForm;
import java.sql.SQLException;
import java.util.List;


public class BorrowBookDao {
    public SqlMapClient sqlMap;

    public void getSqlMapClient() {
        try {
            String resource = "DataAccess.xml";
            Reader reader = Resources.getResourceAsReader(resource);
            XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
            sqlMap = xmlBuilder.buildSqlMap(reader);
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("Error initializing SqlConfig. Cause: " +
                                       e);
        }
    }
    
    
    public List selectBorrowBookPirtuce() {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
               list = sqlMap.queryForList("selectBorrowBookPirtuce", null);
  
            
        } catch (SQLException ex) {
        }
        return list;
    }
    
    
    

    //查詢該書已經被借用數量
    public List selectBorrowBookNumber(BorrowBookForm form) {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectBorrowBookNumber", form);
        } catch (SQLException ex) {
        }
        return list;
    }

//全部查詢,分頁顯示
    public List selectBorrowBook(int number) {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            if (number < 0) {
                list = sqlMap.queryForList("selectBorrowBook", null);
            } else {
                list = sqlMap.queryForList("selectBorrowBook", null,
                                           number * 14, 14);
            }
        } catch (SQLException ex) {
        }
        return list;
    }

//查詢出多少條紀錄
    public int selectBorrowBook() {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectBorrowBook", null);
        } catch (SQLException ex) {
        }
        int number = list.size();
        if (number % 14 == 0) {
            number = number / 14;
        } else {
            number = number / 14 + 1;
        }
        return number;
    }

    public BorrowBookForm selectBorrowBook(BorrowBookForm form) {
        BorrowBookForm borrowBookForm = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            borrowBookForm = (BorrowBookForm) sqlMap.queryForObject(
                    "selectBorrowBook", form);
        } catch (SQLException ex) {
        }
        return borrowBookForm;
    }

    
    
    public BorrowBookForm selectBorrowBookGoOn(BorrowBookForm form) {
        BorrowBookForm borrowBookForm = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            borrowBookForm = (BorrowBookForm) sqlMap.queryForObject(
                    "selectBorrowBookGoOn", form);
        } catch (SQLException ex) {
        }
        return borrowBookForm;
    }
    
    
    
    

    //添加借閱圖書信息的方法
    public boolean insertBorrowBook(BorrowBookForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.insert("insertBorrowBook", form);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

    //刪除的方法
    public boolean deleteBorrowBook(BorrowBookForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.delete("deleteBorrowBook", form);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

    //續借的方法

    public boolean updateBorrowBook(BorrowBookForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.update("updateBorrowBook", form);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }
    //歸還的方法
    public boolean lendBorrowBook(BorrowBookForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.update("lendBorrowBook", form);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

}