Spring Boot整合Mybatis完成对数据库增删改查功能
@(我的第一个笔记本)[JackMa, 2018-07-23]
前谈:
开发工具:Intellij IDEA
开发环境:Java version1.8
所用技术:springboot+mybatis+mysql
测试工具:postman
一. 创建项目
File–new –project–Spring Initializr
二. 编写代码
1.数据库
创建数据库test,员工表User
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL,
`name` varchar(100) character set utf8 default NULL,
`gender` varchar(10) character set latin1 default NULL,
`job` varchar(200) character set latin1 default NULL,
`birthday` date default NULL,
`number` varchar(255) default NULL,
`password` varchar(255) default NULL,
`image` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
SET FOREIGN_KEY_CHECKS=1;
2.entity层实体类
在src/main/java目录下添加entity层的实体类User:
package com.example.demo.entity;
public class User {
private int id;
private String name;
private String password;
private String number;
private String birthday;
private String job;
private String gender;
public int getId() {
return id;}
public void setId(int id) {
this.id = id; }
public Str