图书管理系统——读者管理

1、dao接口和实现

ReaderCardMapper.java

/**
     * 查询所有的记录信息  分页
     */
    List<ReaderCard> queryReaderListAll(ReaderCard readerCard);

注解：加

@Component(“readerDao”)

实现
ReaderCardMapper.xml

 <select id="queryReaderListAll" parameterType="com.zhaolei.po.ReaderCard" resultType="com.zhaolei.po.ReaderCard">
    select * from reader_card
    <where>
        <if test="username!=null">
          and username like '%${username}%'
        </if>
      <if test="tel!=null">
        and username like '%${tel}%'
      </if>
      <if test="cardnumber!=null">
        and username like '%${cardnumber}%'
      </if>
    </where>

  </select>

1.2、Service接口和实现

ReaderService .java

package com.zhaolei.service;

import com.github.pagehelper.PageInfo;
import com.zhaolei.po.ReaderCard;

import java.util.List;

public interface ReaderService {

    /**
     * 查询读者信息分页功能
     */
    PageInfo<ReaderCard> queryReaderAll(ReaderCard readerCard,int page,int limit);

    /**
     * 添加
     */
    void addReaderInfoSubmit(ReaderCard readerCard);

    /**
     * 查询  根据id查询读者信息
     */
    ReaderCard queryReaderById(Integer id);

    /**
     * 修改
     */
    void updateReaderInfoSubmit(ReaderCard readerCard);

    /**
     * 删除
     */
    void deleteReaderByIds(List<String> ids);

}

实现
注解：加

@Service(“ReaderService”)

ReaderServiceImpl .impl

package com.zhaolei.service;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zhaolei.dao.ReaderCardMapper;
import com.zhaolei.po.ReaderCard;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("ReaderService")
public class ReaderServiceImpl implements ReaderService{
    @Autowired
    private ReaderCardMapper readerDao;

    @Override
    public PageInfo<ReaderCard> queryReaderAll(ReaderCard readerCard, int page, int limit) {
        PageHelper.startPage(page,limit);
        List<ReaderCard> list=readerDao.queryReaderListAll(readerCard);
        PageInfo<ReaderCard> pageInfo = new PageInfo<>(list);

        return pageInfo;
    }

    @Override
    public void addReaderInfoSubmit(ReaderCard readerCard) {
        readerDao.insert(readerCard);

    }

    @Override
    public ReaderCard queryReaderById(Integer id) {

        return readerDao.selectByPrimaryKey(id);
    }

    @Override
    public void updateReaderInfoSubmit(ReaderCard readerCard) {
        readerDao.updateByPrimaryKey(readerCard);

    }

    @Override
    public void deleteReaderByIds(List<String> ids) {
        for(String id:ids){
            readerDao.deleteByPrimaryKey(Integer.valueOf(id));
        }

    }
}