mybatis实现curd的方式有三种
一、继承IService接口,直接调用该接口中的方法
方法包含以下接口方法
二、继承BaseMapper,直接调用该接口中的方法
上面两中方法,下面展示代码
controller
package com.tp.mybatisplusstudy.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.tp.mybatisplusstudy.dao.UserMapper; import com.tp.mybatisplusstudy.service.IUserService; import com.tp.mybatisplusstudy.vo.User; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.ArrayList; import java.util.List; /** * @Package: com.tp.mybatisplusstudy.controller * @ClassName: UserController * @Author: tanp * @Description: ${description} * @Date: 2020/4/22 9:13 */ @RestController @RequestMapping(value = "/user") public class UserController { @Autowired private UserMapper userMapper; @Autowired private IUserService iUserService; @RequestMapping(value = "/getUsers") public List<User> getUsers() { System.out.print("请求次数--"); List<User> users = userMapper.selectList(null); return users; } @RequestMapping(value = "/getUsers23") public List<User> getUsers2() { List<User> users = iUserService.list(); return users; } @RequestMapping(value = "/save") public boolean save() { User user = new User(); user.setId(8L); user.setAge(8); user.setEmail("123456789@qq,com"); user.setName("8888"); return iUserService.save(user); } @RequestMapping(value = "/svaeList") public boolean save2(){ List<User> userList = new ArrayList<>(); User user; for(int i=0; i<5; i++){ user = new User(); user.setName("mike"+i); user.setAge(i); user.setId(Long.parseLong("10"+i)); userList.add(user); } return iUserService.saveBatch(userList); } @RequestMapping(value = "getUserList2") public List<User> getUserList2(){ QueryWrapper qw = new QueryWrapper(); qw.likeRight("name","mike"); return userMapper.selectList(qw); } @RequestMapping(value = "getUserList3") public List<User> getUserList3(){ QueryWrapper qw = new QueryWrapper(); qw.likeLeft("name","mike"); return userMapper.selectList(qw); } }
service
package com.tp.mybatisplusstudy.service; import com.baomidou.mybatisplus.extension.service.IService; import com.tp.mybatisplusstudy.vo.User; /** * @ClassName: IUserService * @Author: tanp * @Description: ${description} * @Date: 2020/4/22 16:25 */ public interface IUserService extends IService<User> { }
package com.tp.mybatisplusstudy.service.impl; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.tp.mybatisplusstudy.dao.UserMapper; import com.tp.mybatisplusstudy.service.IUserService; import com.tp.mybatisplusstudy.vo.User; import org.springframework.stereotype.Service; /** * @ClassName: UserServiceImpl * @Author: tanp * @Description: ${description} * @Date: 2020/4/22 16:32 */ @Service public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService { }
mapper
package com.tp.mybatisplusstudy.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.tp.mybatisplusstudy.vo.User; import org.springframework.stereotype.Repository; /** * @Package: com.tp.mybatisplusstudy.dao * @ClassName: UserMapper * @Author: tanp * @Description: ${description} * @Date: 2020/4/21 19:26 */ @Repository public interface UserMapper extends BaseMapper<User> { }
三、在xml中写sql实现查询