booksortdao.java

图书管理系统 jsp+tomcat+sql2000

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

public class BookSortDao {
    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 selectMaxIdSort() {
        String sort = null;
        BookSortForm form = null;
        this.getSqlMapClient();
        try {
            sqlMap.startTransaction();
            form = (BookSortForm) sqlMap.queryForObject("selectMaxIdBookSort", null);
        } catch (SQLException ex) {
        }
        if (form != null) {
            sort = form.getSortNumber();
        }
        sort = DealwithString.maxNumberString(sort, "S-", 2);
        return sort;
    }

//以图书类别名称为条件，删除一组数据
    public boolean deleteBookSort(BookSortForm bookSortForm) {
        try {
            this.getSqlMapClient();

            sqlMap.delete("deleteBookSort", bookSortForm);

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

    //添加图书类别信息的方法
    public boolean insertBookSort(BookSortForm bookSortForm) {
        try {
            this.getSqlMapClient();

            sqlMap.insert("insertBookSort", bookSortForm);

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

    //以图书名称为条件，修改图书类别
    public boolean updateBookSort(BookSortForm bookSortForm) {
        try {
            this.getSqlMapClient();

            sqlMap.insert("updateBookSort", bookSortForm);

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

    public BookSortForm selectBookSort(BookSortForm bookSortForm) {
        BookSortForm form = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            form = (BookSortForm) sqlMap.queryForObject("selectBookSortForm",
                    bookSortForm);

        } catch (SQLException ex) {
        }
        return form;
    }
    
    
    public BookSortForm selectBookSort(String number) {
        BookSortForm form = new BookSortForm();
        
        form.setSortNumber(number);
        
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            form = (BookSortForm) sqlMap.queryForObject("selectBookSortForm",form);

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

    //全部查询,分页显示
    public List selectBookSort(int number) {
        List list = null;
        try {
            this.getSqlMapClient();
            sqlMap.startTransaction();
            list = sqlMap.queryForList("selectBookSortForm", null, number * 14,
                                       14);
        } catch (SQLException ex) {
        }
        return list;
    }

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


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

}