bookdao.java

STRUTS+IBITS开发的一个图书管理系统

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

public class BookDao {
    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 String selectMaxIdBook() {
        String book = null;
        BookForm form = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            form = (BookForm) sqlMap.queryForObject("selectMaxIdBook", null);
        } catch (SQLException ex) {
        }
        if (form != null) {
            book = form.getBookNumber();
        }
        book = DealwithString.maxNumberString(book, "BOOK-", 5);
        return book;
    }


    //添加图书信息的方法
    public boolean insertBook(BookForm bookForm) {
        try {

            this.getSqlMapClient();
            sqlMap.startTransaction();
            sqlMap.insert("insertBook", bookForm);
            sqlMap.commitTransaction();
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

    //全部查询,分页显示
    public List selectBook(int number) {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectBookForm", null, number * 14,
                                       14);
        } catch (SQLException ex) {
        }
        return list;
    }
    /**通过FORM把值传递到(updateBook.jsp)页面
     * 通过一个bookNumber把数据库的相应记录查询出来
     * @param bookSortForm
     * @return
     */
    public BookForm selectBook(BookForm bookSortForm) {
        BookForm form = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            form = (BookForm) sqlMap.queryForObject("selectBookForm",
                    bookSortForm);

        } catch (SQLException ex) {
        }
        return form;
    }


    //查询出多少条纪录
    public int selectBook() {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectBookForm", null);
        } catch (SQLException ex) {
        }
        int number = list.size();
        if (number % 14 == 0) {
            number = number / 14;
        } else {
            number = number / 14 + 1;
        }
        return number;
    }

    //以图书名称为条件，删除一组数据
    public boolean deleteBook(BookForm bookForm) {
        try {
            this.getSqlMapClient();
            sqlMap.delete("deleteBook", bookForm);
            return true;
        } catch (SQLException ex) {
            return false;
        }
    }

    //修改图书信息的方法
    public boolean updateBook(BookForm bookForm) {
        try {

            this.getSqlMapClient();

            sqlMap.insert("updateBook", bookForm);

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

    //修改图书数目
    public boolean addBook(BookForm bookForm) {
        try {

            this.getSqlMapClient();

            sqlMap.insert("addBook", bookForm);

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


   //全部查询
      public List selectBookAll() {
          List list = null;
          try {
              this.getSqlMapClient();
              sqlMap.startTransaction();
              list = sqlMap.queryForList("selectBookForm", null);
          } catch (SQLException ex) {
          }
          return list;
    }






}