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

public class PlaceDao {
    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 selectPlace(int number) {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            if (number < 0) {
                list = sqlMap.queryForList("selectPlace", null);
            } else {
                list = sqlMap.queryForList("selectPlace", null, number * 14, 14);
            }
        } catch (SQLException ex) {
        }
        return list;
    }

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


    //自動編號的方法
    public String selectMaxIdPlace() {
        String place = null;
        PlaceForm form = null;
        this.getSqlMapClient();
        try {
            sqlMap.startTransaction();
            form = (PlaceForm) sqlMap.queryForObject("selectMaxIdPlace", null);
        } catch (SQLException ex) {
        }
        if (form != null) {
            place = form.getPlaceNumber();
        }
        place = DealwithString.maxNumberString(place, "P-", 2);
        return place;
    }


    //添加圖書存放位置信息的方法
    public boolean insertPlace(PlaceForm placeForm) {
        try {
            this.getSqlMapClient();

            sqlMap.insert("insertPlace", placeForm);

            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

    //以圖書編號為條件刪除圖書存放位置
    public boolean deletePlace(PlaceForm placeForm) {
        try {
            this.getSqlMapClient();
            sqlMap.delete("deletePlace", placeForm);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }
}