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.ReaderForm;
import java.sql.SQLException;
import java.util.List;
import com.tool.DealwithString;

public class ReaderDao {
    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 ReaderForm selectReader(ReaderForm form) {
     ReaderForm readerForm=null;
       try {
           this.getSqlMapClient();
           sqlMap.startTransaction();
        readerForm=(ReaderForm)sqlMap.queryForObject("selectReaderForm",form);
    } catch (SQLException ex) {
       }
       return readerForm;
   }


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

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


  //自動編號的方法
  public String selectMaxIdReader() {
      String reader = null;
      ReaderForm form = null;
      this.getSqlMapClient();
      try {
          sqlMap.startTransaction();
          form = (ReaderForm) sqlMap.queryForObject("selectMaxIdReader", null);
      } catch (SQLException ex) {
      }
      if (form != null) {
          reader = form.getBookCardMark();
      }
      reader = DealwithString.maxNumberString(reader, "R-", 2);
      return reader;
  }


  //添加讀者信息的方法
  public boolean insertReader(ReaderForm form) {
      try {
          this.getSqlMapClient();
          sqlMap.insert("insertReader", form);
          return true;
      } catch (SQLException ex) {
          return false;
      }
  }

  //以書證號為條件刪除一組數據
  public boolean deleteReader(ReaderForm form) {
      try {
          this.getSqlMapClient();
          sqlMap.delete("deleteReader", form);
          return true;
      } catch (SQLException ex) {
          return false;
      }
  }

}