api 的接口 com.hong.spring.api.IUserService

packagecom.hong.spring.api;importcom.hong.spring.entity.User;importcom.hong.spring.entity.ao.UserAO;importcom.hong.spring.utils.DataResponse;importjava.util.List;* @author: csh* @Date: 2021/1/5 16:32* @Description:*/publicinterfaceIUserService{/**** 功能描述:查询全部** @param:* @return:* @auther: csh* @date: 2020/8/18 15:26*/DataResponse List User findByAll();/**** 功能描述:添加** @param:* @return:* @auther: csh* @date: 2020/8/18 15:26*/DataResponse Boolean save(User user);/**** 功能描述:批量添加** @param:* @return:* @auther: csh* @date: 2020/8/21 15:47*/DataResponse Boolean insertBatch(List User list);/**** 功能描述:更新** @param:* @return:* @auther: csh* @date: 2020/8/18 15:26*/DataResponse Boolean update(User user);/**** 功能描述:通过id查询** @param:* @return:* @auther: csh* @date: 2020/8/18 15:42*/DataResponse User findById(inti);/**** 功能描述:通过分页查询** @param:* @return:* @auther: csh* @date: 2020/8/21 16:04*/DataResponse List User findByPage(UserAO ao);}

注意：其他配置请拉项目看吧！

com.hong.spring.dao.UserMapper

packagecom.hong.spring.dao;importcom.hong.spring.entity.User;importcom.hong.spring.entity.ao.UserAO;importorg.apache.ibatis.annotations.Param;importjava.util.List;* @Auther: csh* @Date: 2020/8/18 15:04* @Description:用户dao层*/publicinterfaceUserMapper{/**** 功能描述:查询总条数** @param:* @return:* @auther: csh* @date: 2020/8/18 15:31*/List User findAllUserList();/**** 功能描述:获取总数** @param:* @return:* @auther: csh* @date: 2020/8/18 15:30*/intfindAllTotal();/**** 功能描述:更新** @param:* @return:* @auther: csh* @date: 2020/8/18 15:30*/intupdate(User user);/**** 功能描述:添加** @param:* @return:* @auther: csh* @date: 2020/8/19 18:39*/intsave(User user);/**** 功能描述:批量添加** @param:* @return:* @auther: csh* @date: 2020/8/21 15:46*/intinsertBatch(@Param(\"list\")List User list);/**** 功能描述:通过id查询** @param:* @return:* @auther: csh* @date: 2020/8/19 18:39*/User findById(intid);/**** 功能描述:通过分页查询** @param:* @return:* @auther: csh* @date: 2020/8/21 16:05*/List User findByPage(UserAO ao);}

com/hong/spring/mapper/UserMapper.xml

 ?xml version=\"1.0\"encoding=\"UTF-8\"?  !DOCTYPE mapperPUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\"  mappernamespace=\"com.hong.spring.dao.UserMapper\"  resultMaptype=\"com.hong.spring.entity.User\"id=\"user\"  idcolumn=\"id\"property=\"id\"/  resultcolumn=\"user_name\"property=\"username\"/  resultcolumn=\"age\"property=\"age\"/  /resultMap  selectid=\"findById\"resultType=\"com.hong.spring.entity.User\" SELECT * FROM user WHERE id = #{id,jdbcType=INTEGER} /select  selectid=\"findByPage\"resultMap=\"user\"parameterType=\"com.hong.spring.entity.ao.UserAO\" select * from user where 1=1 limit #{page},#{pageSize} /select  selectid=\"findAllUserList\"resultMap=\"user\" SELECT * FROM user /select  selectid=\"findAllTotal\"resultType=\"int\" SELECT count(*) FROM user /select  insertid=\"save\" INSERT INTO user ( user_name, age)VALUES (#{username,jdbcType=VARCHAR},#{age,jdbcType=INTEGER}) /insert  insertid=\"insertBatch\" insert into user( user_name, age)values foreachcollection=\"list\"item=\"user\"index=\"index\"separator=\",\" (#{user.username,jdbcType=VARCHAR},#{user.age,jdbcType=INTEGER}) /foreach  /insert  updateid=\"update\" update user set  iftest=\"username !=null\" user_name=#{username,jdbcType=VARCHAR}, /if  iftest=\"age !=null\" age =#{age,jdbcType=INTEGER} /if  /set where id = #{id,jdbcType=INTEGER} /update  /mapper 

com.hong.spring.provider.UserServiceImpl

packagecom.hong.spring.provider;importcom.hong.spring.api.IUserService;importcom.hong.spring.dao.UserMapper;importcom.hong.spring.entity.User;importcom.hong.spring.entity.ao.UserAO;importcom.hong.spring.utils.DataResponse;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importorg.springframework.transaction.annotation.Transactional;importjava.util.List;