一、搭建spring-boot项目
1、打开itellij,点击new–>Project–>Spring Initralizr(如果没有Spring Initralizr,请到setting–>plugin下搜索spring-boot安装插件)
填写好项目名字,选择devTool,spring-Web依赖,生成spring项目
等待安装完依赖包,启动sping-boot项目
2、集成mybatis,实现简单查询数据库功能功能
项目结构
-
项目结构
-
加入mybatis和mysql依赖
pom.xml
<!--mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!--数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.37</version>
</dependency>
3增加配置项, 加入mybatis和mysql依赖
application.properties
# server.servlet.context-path=/business
# redis配置
# spring.redis.host=47.100.55.40
# spring.redis.port=6379
# spring.redis.password=Redis000
#端口
server.port=3111
# 增加数据库连接
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=UTF8&autoReconnect=true
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#mybatis的mapper路径
mybatis.mapper-locations=classpath:/mapper/*.xml
4、在resource增加mapper
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo1.mapper.testMapper">
<select id="list" resultType="com.example.demo1.domain.Test">
select `id`,`name` from `test`
</select>
</mapper>
5、domain增加dto
package com.example.demo1.domain;
public class Test {
private String id;
private String name;
public String getId( ) {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName( ) {
return name;
}
public void setName(String name) {
this.name = name;
}
}
6、mapper文件夹下增加mapper接口
package com.example.demo1.mapper;
import com.example.demo1.domain.Test;
import java.util.List;
public interface testMapper {
public List<Test> list();
}
7、mapper文件夹下增加mapper接口
package com.example.demo1.mapper;
import com.example.demo1.domain.Test;
import java.util.List;
public interface testMapper {
public List<Test> list();
}
8、增加service层
package com.example.demo1.service;
import com.example.demo1.domain.Test;
import com.example.demo1.mapper.testMapper;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class TestService {
@Resource
testMapper testMapper;
public List<Test> list() {
List<Test> list = testMapper.list();
return list;
}
}
9、增加controller层
package com.example.demo1.controller;
import com.example.demo1.domain.Test;
import com.example.demo1.service.TestService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
public class test {
private static final Logger LOG = LoggerFactory.getLogger(test.class);
@Resource
TestService testService;
@GetMapping("/list")
public List<Test> list() {
return testService.list();
}
}
10、在application文件中加入mapper扫描
@MapperScan(“com.example.demo1.mapper”)
三、效果
在数据库中增加数据后,效果
(完)