package com.dao;

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

public class ManagerDao {
    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 boolean insertManager(ManagerForm managerForm) {
        try {

            sqlMap.insert("insertManager", managerForm);

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

//操作員分頁查詢
    public PaginatedList selectManagerList() {
        PaginatedList  list = null;
        try {
            sqlMap.startTransaction();
            list = sqlMap.queryForPaginatedList("selectManager", null,13);
            sqlMap.commitTransaction();
        } catch (SQLException ex) {
        }
        return list;
    }
    //操作員全部查詢
    public List selectManager() {
        List  list = null;
        try {
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectManager",null);
            sqlMap.commitTransaction();
        } catch (SQLException ex) {
        }
        return list;
    }


    //以操作員為條件查詢的方法
    public ManagerForm selectManager(ManagerForm managerForm) {
        ManagerForm form = null;
        try {
            sqlMap.startTransaction();
            form = (ManagerForm) sqlMap.queryForObject("selectManager",managerForm);
            sqlMap.commitTransaction();
        } catch (SQLException ex) {
        }
        return form;
    }

    //以操作員賬號(hào)為條件修改操作員的密碼和權(quán)限
    public boolean updateManager(ManagerForm managerForm) {
        try {

            sqlMap.update("updateManager", managerForm);

            return true;
        } catch (SQLException ex) {
            return false;
        }
    }
    //以操作員賬號(hào)為條件刪除操作員
     public boolean deleteManager(ManagerForm managerForm) {
         try {

             sqlMap.delete("deleteManager", managerForm);

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