前提:
已经安装mysql8,并且创建了mydb数据库,登录用户名与密码为root
一、配置依赖与mysql连接信息:
1.添加springboot依赖、mybatis-plus依赖、mysql驱动依赖,在工程根目录的pom.xml中:
<parent>
<artifactId>springboot</artifactId>
<groupId>com.yyh</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<!-- 导入mybatis-plus依赖包 -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
</dependency>
</dependencies>
2.配置mysql连接信息,在工程pom.xml中:
server:
port: 10000
spring:
datasource: #配置数据库连接信息
driver-class-name: com.mysql.cj.jdbc.Driver #驱动
url: jdbc:mysql://localhost:3306/mydb?serverTimezone=UTC #数据库路径信息
username: root #数据库登录用户与密码
password: root
#mybatis-plus: #自定义配置,可以不配置
#config-location: classpath:mybatis-config.xml # 指定单个mapper.xml文件
#mapper-locations: classpath*:*.xml # 指定多个mapper.xml文件
3.配置启动类:
@SpringBootApplication
@MapperScan("com.yyh.mybatisplus.mapper") //扫描UserMapper包
public class MybatisplusApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisplusApplication.class, args);
}
//分页查询要用到
@Bean
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
}
二、增删改查操作:
1.创建实体类:
public class User {
@TableId(value = "ID", type = IdType.AUTO) //设置自增ID值
private Long id;
private String name;
private Integer age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
2.创建Dao接口类:
public interface UserMapper extends BaseMapper<User> {
}
3.创建业务类,调用Dao接口增删改查:
@Service //增删改查
public class UserBiz {
@Autowired
UserMapper userMapper;
//插入数据
public void insert(User user) {
userMapper.insert(user);
}
//更新数据
public void update(User user) {
userMapper.updateById(user);
}
//删除数据
public void delete(Long id) {
userMapper.deleteById(id);
}
//查询分页列表
public List<User> testSelectPage(int pageIndex, int pageNum) {//从第1页开始
IPage<User> userIPage = userMapper.selectPage(new Page<>(pageIndex, pageNum), null);
return userIPage.getRecords();
}
//模糊搜索
public List<User> search(String key) {
QueryWrapper query = new QueryWrapper(new User());
query.like("name", key);
return userMapper.selectList(query);
}
//条件查询
public List<User> queryByLe() {
QueryWrapper queryWrapper = new QueryWrapper(new User());
queryWrapper.le("age", 18);//eq相等,ne、neq不相等,gt大于, lt小于,gte、ge大于等于,lte、le小于等于
return userMapper.selectList(queryWrapper);
}
}