1、使用IDEA创建一个springboot的工程,创建springboot工程详细步骤请移步查看:https://blog.csdn.net/qq_38555490/article/details/90260295
2、修改pom文件,添加mybatis-plus的依赖,以及连接数据库mysql的依赖
<!--mybatis-plus和springboot整合的起步依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.1.1</version>
</dependency>
<!--mysql包-->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
图示:
3、pom文件添加一个lombok的插件来对我们的pojo生成get,set方法
<!--pojo注解生成get、set方法-->
<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.18</version>
<scope>provided</scope>
</dependency>
图示:
3、创建我们的工程目录结构(我这里创建的是一个demo)
4、我们的dao层继承我们mybatis-plus的BaseMapper<T>
继承了我们就拥有了操作单表的方法,而不用像mybatis用逆向工程生成mapper.xml文件,是不是很方便,极大的使我们的开发效率上升。
public interface StuDao extends BaseMapper<Student> {
}
图示:
5、修改application.properties文件,后缀改为yml,yml类型是springboot支持文件类型的一种。
具体yml介绍使用方法,请移步该文章查看:https://blog.csdn.net/qq_38555490/article/details/90264257
6、application.yml配置数据源,配置端口
#配置数据源
spring:
datasource:
url: jdbc:mysql://localhost:3306/mydb
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
#配置服务器端口
server:
port: 8888
6、springboot启动类配置注解扫描
@SpringBootApplication(scanBasePackages = "com.xiaomin")
@MapperScan("com.xiaomin.mapper")
6、测试
创建数据库表
CREATE TABLE sutdent(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20) NOT NULL,
age INT NOT NULL,
birthday DATE NOT NULL
)
图示:
pojo-Student.java 创建我们的实体类
package com.xiaomin.pojo;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import java.util.Date;
/**
* @author jattxgt
* @site jattxgt
* @company jattxgt.com
* @create 2019-06-13 9:17
*/
@Getter //get方法
@Setter //set方法
@AllArgsConstructor //有参构造方法
@NoArgsConstructor //无参构造方法
public class Student {
private int id;
private String name;
private int age;
private Date birthday;
}
mapper-StuDao.java
package com.xiaomin.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xiaomin.pojo.Student;
/**
* @author jattxgt
* @site jattxgt
* @company jattxgt.com
* @create 2019-06-13 9:16
*/
public interface StuDao extends BaseMapper<Student> {
}
server-StuServer.java
package com.xiaomin.service;
import com.xiaomin.pojo.Student;
import java.util.List;
/**
* @author jattxgt
* @site jattxgt
* @company jattxgt.com
* @create 2019-06-13 9:17
*/
public interface StuService {
//删除
int deleteById(int id);
//查询
List<Student> selectAll();
}
serverimpl-StuServerImpl.java
package com.xiaomin.service.impl;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.xiaomin.mapper.StuDao;
import com.xiaomin.pojo.Student;
import com.xiaomin.service.StuService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @author jattxgt
* @site jattxgt
* @company jattxgt.com
* @create 2019-06-13 9:26
*/
@Service
public class StuServiceImpl implements StuService {
@Autowired
private StuDao stuDao;
/**
* 通过Id来删除
* @param id 页面传入过来的id
* @return
*/
@Override
public int deleteById(int id) {
int aa=stuDao.deleteById(id);
return aa;
}
/**
* 查询所有的学生信息
* @return
*/
@Override
public List<Student> selectAll() {
List<Student> list=stuDao.selectList(null);
return list;
}
}
controller-StuController.java
package com.xiaomin.controller;
import com.xiaomin.pojo.Student;
import com.xiaomin.service.StuService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.Date;
import java.util.List;
/**
* @author jattxgt
* @site jattxgt
* @company jattxgt.com
* @create 2019-06-13 9:17
*/
@RestController
public class StuController {
@Autowired
private StuService stuService;
/**
* 通过id删除
* @param id
* @return
*/
@RequestMapping(value = "/delete/{id}")
public String deleteById(@PathVariable int id){
int aa=stuService.deleteById(id);
return "删除成功,影响行数为:"+aa;
}
/**
* 查询所有的学生信息
* @return
*/
@RequestMapping("/selectAll")
public List<Student> selectAll(){
List<Student> list= stuService.selectAll();
return list;
}
}
浏览器测试
demo百度云地址:
链接:https://pan.baidu.com/s/15kezv4uXQgzPtq5y115CbA
提取码:yh3w