typereaderdao.java

图书管理系统 jsp+tomcat+sql2000

package com.dao;

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

public class TypeReaderDao {
    private SqlMapClient sqlMap;

    private void getSqlMapClient() {
        try {
            String resource = "DataAccess.xml";
            Reader reader = Resources.getResourceAsReader(resource);
            XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
            sqlMap = xmlBuilder.buildSqlMap(reader);
        } catch (Exception ex) {
            throw new RuntimeException("抛出异常" + ex);
        }
    }

    //添加读者类别信息的操作
    public boolean insertTypeReader(TypeReaderForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.insert("insertTypeReader", form);
            return true;
        } catch (Exception ex) {
            return false;
        }
    }

    //删除读者类别信息的操作
    public boolean deleteTypeReader(TypeReaderForm form) {
        try {
            this.getSqlMapClient();
            sqlMap.delete("deleteTypeReader", form);
            return true;
        } catch (Exception ex) {
            return false;
        }
    }

    //以读者类别信息为条件，查询一组数据
    public TypeReaderForm selectOneTypeReader(TypeReaderForm form) {
        TypeReaderForm typeReaderForm = null;
        try {
            this.getSqlMapClient();
            typeReaderForm = (TypeReaderForm) sqlMap.queryForObject(
                    "selectTypeReader", form);
        } catch (SQLException ex) {
        }
          return typeReaderForm;
    }

    //查询读者类别的全部信息
    public List selectOneTypeReader() {
      List list=null;
      this.getSqlMapClient();
    try {
        list = sqlMap.queryForList("selectTypeReader", null);
    } catch (SQLException ex) {
    }
      return list;
    }


}