springboot+mybatis plus框架下进行增删改查操作
框架搭建完成后,假设要对teacher表进行增删查改:
第一步
创建一个Teacher的POJO类
用注解指定该类对应的数据表
@TableName("teacher") public class Teacher {...}
如果id字段为自增还需要用注解标明
@TableId(value = "tecid",type = IdType.AUTO) private Integer tecid;
然后把所有涉及到增删查改操作的属性声明并且设置getter/setter
第二步
创建对应Dao接口并用@Repository注解标注,继承BaseMapper<Teacher>
@Repository public interface TeacherDao extends BaseMapper<Teacher> {}
第三步
创建对应的Service接口,在Service接口中声明需要对数据进行操作的方法
public interface TeacherService { int insertTeacher(Teacher teacher); int updateTeacher(Teacher teacher); List<Teacher> selectTeacherList(Teacher teacher); Page<Teacher> selectTeacherByPage(Teacher teacher, long pageNum, long pageSize); Teacher selectTeacherById(Integer teacherId); }
第四步
创建一个Service的实现类,并将所有方法实现。
@Service,表示这个为业务层
@Autowired注解是把这个对象自动注入到IOC容器中
部分关键代码:
@Service public class TeacherServiceImpl implements TeacherService { @Autowired private TeacherDao teacherDao; @Override public int insertTeacher(Teacher teacher) {...} @Override public int updateTeacher(Teacher teacher) {...} @Override public List<Teacher> selectTeacherList(Teacher teacher) {...} @Override public Page<Teacher> selectTeacherByPage(Teacher teacher, long pageNum, long pageSize) {...} @Override public Teacher selectTeacherById(Integer teacherId) {...}
第五步
写一个Controller类,把拿到的数据输出到要显示的页面上
在类上用@RestController注解表明这是Controller层
@Api(tags = "teacher案例接口") @RestController @RequestMapping("/teacher") public class TeacherController {...}
示例方法:
根据"tectitle"字段查询一个教师的详细信息
@ApiOperation("查询teacher列表案例") @ApiImplicitParams({ @ApiImplicitParam(name = "tectitle", value = "传递字符串") }) @GetMapping("/list") public ListMessage<Teacher> selectTeacherList(Teacher teacher){ ListMessage<Teacher> listMessage = new ListMessage<>(); List<Teacher> list = teacherService.selectTeacherList(teacher); if (list != null) { listMessage.setDatalist(list); listMessage.setCode(1); } else { listMessage.setCode(0); listMessage.setMsg("没有查询到数据"); } return listMessage; }
第六步
开启运行类后,这里用的是swagger,端口号设置为默认的80,访问下面的网址就可以进行测试了
网页示例: