MybatisPlus增删改查操作

UserMapper.xml?xml version1.0 encodingUTF-8?!DOCTYPEmapperPUBLIC-//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmappernamespacecom.hk.mapper.UserMapperresultMapidUserMaptypecom.hk.entity.UserInforesultcolumnidpropertyid/resultcolumnnamepropertyname/resultcolumnlogin_idpropertyloginId/resultcolumnpwdpropertypwd/resultcolumnversionpropertyversion/resultcolumnstatuspropertystatus/resultcolumnorg_namepropertyorgName//resultMapselectidgetUserByNameparameterTypeStringresultMapUserMapselect u.*,o.name org_name from user u inner join org o on u.org_ido.id where u.name#{name}/selectselectidgetUserByLoginIdparameterTypeStringresultMapUserMapselect u.*,o.name org_name from user u inner join org o on u.org_ido.id where u.login_id${loginId}/selectselectidqueryListresultTypecom.hk.entity.UserInfoselect * from user ${ew.customSqlSegment}/select/mapperUserMapper.javapackagecom.hk.mapper;importcom.baomidou.mybatisplus.core.conditions.Wrapper;importcom.baomidou.mybatisplus.core.mapper.BaseMapper;importcom.baomidou.mybatisplus.core.metadata.IPage;importcom.baomidou.mybatisplus.core.toolkit.Constants;importcom.hk.entity.UserInfo;importorg.apache.ibatis.annotations.Mapper;importorg.apache.ibatis.annotations.Param;importjava.util.List;MapperpublicinterfaceUserMapperextendsBaseMapperUserInfo{publicListUserInfogetUserByName(Param(name)Stringname);publicListUserInfogetUserByLoginId(Param(loginId)StringloginId);publicIPageUserInfoqueryList(IPageUserInfopage,Param(Constants.WRAPPER)WrapperUserInfowrapper);}IUserService.javapackagecom.hk.service;importcom.baomidou.mybatisplus.core.conditions.query.QueryWrapper;importcom.baomidou.mybatisplus.core.metadata.IPage;importcom.baomidou.mybatisplus.extension.service.IService;importcom.hk.entity.UserInfo;importjava.util.List;publicinterfaceIUserServiceextendsIServiceUserInfo{publicListUserInfogetUserByName(Stringname);publicListUserInfogetUserByLoginId(StringloginId);/** * 分页查询用户 * param pageNo 页码 * param pageSize 每页记录数 * param queryWrapper * return */publicIPageUserInfoqueryList(IntegerpageNo,IntegerpageSize,QueryWrapperUserInfoqueryWrapper);}UserServiceImpl.javapackagecom.hk.service.impl;importcom.baomidou.mybatisplus.core.conditions.query.QueryWrapper;importcom.baomidou.mybatisplus.core.metadata.IPage;importcom.baomidou.mybatisplus.extension.plugins.pagination.Page;importcom.baomidou.mybatisplus.extension.service.impl.ServiceImpl;importcom.hk.entity.UserInfo;importcom.hk.mapper.UserMapper;importcom.hk.service.IUserService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importorg.springframework.transaction.annotation.Propagation;importorg.springframework.transaction.annotation.Transactional;importjava.util.Collections;importjava.util.List;ServiceTransactional(readOnlyfalse,rollbackForException.class,propagationPropagation.REQUIRED)publicclassUserServiceImplextendsServiceImplUserMapper,UserInfoimplementsIUserService{OverridepublicListUserInfogetUserByName(Stringname){returnbaseMapper.getUserByName(name);}OverridepublicListUserInfogetUserByLoginId(StringloginId){returnbaseMapper.getUserByLoginId(loginId);}OverridepublicIPageUserInfoqueryList(IntegerpageNo,IntegerpageSize,QueryWrapperUserInfoqueryWrapper){if(pageNonull)pageNo1;if(pageSizenull)pageSize10;PageUserInfopnewPage(pageNo,pageSize);IPageUserInfopageListbaseMapper.queryList(p,queryWrapper);returnpageList;}}UserTests.javapackagecom.hk.user;importcom.baomidou.mybatisplus.core.conditions.query.QueryWrapper;importcom.baomidou.mybatisplus.extension.plugins.pagination.Page;importcom.hk.Starter;importcom.hk.entity.UserInfo;importcom.hk.mapper.UserMapper;importcom.hk.service.IUserService;importorg.junit.Test;importorg.junit.runner.RunWith;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.boot.test.context.SpringBootTest;importorg.springframework.test.context.junit4.SpringRunner;importjava.util.ArrayList;importjava.util.List;RunWith(SpringRunner.class)SpringBootTest(webEnvironmentSpringBootTest.WebEnvironment.RANDOM_PORT,classesStarter.class)publicclassUserTest{AutowiredprivateIUserServiceuserServ;AutowiredprivateUserMapperuserMapper;TestpublicvoidsaveByMapper(){UserInfousernewUserInfo();user.setId(100);user.setName(Java);user.setLoginId(SpringBoot);user.setPwd(pwd);userMapper.insert(user);}TestpublicvoidsaveByService(){UserInfousernewUserInfo();user.setId(100);user.setName(Java);user.setLoginId(SpringBoot);user.setPwd(pwd);booleansaveuserServ.save(user);Stringiduser.getId();System.out.println(saveByService 结果为saveuseruser);}TestpublicvoidsaveBatch(){ListUserInfouserListnewArrayList();for(inti0;i20;i){UserInfousernewUserInfo();user.setId(i);user.setName(Java);user.setLoginId(SpringBoot);user.setPwd(pwd);userList.add(user);}booleanisSuccessuserServ.saveBatch(userList);System.out.println(saveBatch 返回结果isSuccess);}TestpublicvoiddelByMapper(){intcountuserMapper.deleteById(14);System.out.println(delByMapper count);}TestpublicvoiddelBatchByMapper(){ListStringidsnewArrayList();ids.add(12);ids.add(13);userMapper.deleteBatchIds(ids);}TestpublicvoiddelByQueryWrapper(){QueryWrapperwrappernewQueryWrapper();wrapper.eq(name,Java);userMapper.delete(wrapper);}TestpublicvoiddelByLambdaQuery(){userMapper.delete(newQueryWrapperUserInfo().lambda().eq(UserInfo::getName,Java).eq(UserInfo::getLoginId,SpringBoot));}TestpublicvoidupdateByService(){UserInfousernewUserInfo();user.setId(100);user.setName(Java);user.setLoginId(SpringBoot);user.setPwd(pwd);booleanbuserServ.updateById(user);System.out.println(updateByService:b);}TestpublicvoidqueryByMapper(){userMapper.selectList(newQueryWrapperUserInfo().lambda().eq(UserInfo::getName,Java).eq(UserInfo::getLoginId,SpringBoot));}TestpublicvoidqueryByService(){userServ.list(newQueryWrapperUserInfo().lambda().eq(UserInfo::getName,Java).eq(UserInfo::getLoginId,SpringBoot));}TestpublicvoidqueryByParam1(){ListUserInfolstuserMapper.getUserByName(Java);for(UserInfou:lst){System.out.println(#参数 u.nameu.getName(),u.orgNameu.getOrgName());}}TestpublicvoidqueryByParam2(){ListUserInfolstuserMapper.getUserByLoginId(1);for(UserInfou:lst){System.out.println(#参数 u.nameu.getName(),u.orgNameu.getOrgName());}}}