1、搭建一个简易的SpringBoot 项目连接MySql数据库,适合入门SpringBoot的新人(本人);
步骤:1、导入pom.xml文件 MySql驱动
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.25</version>
</dependency>
步骤:2、配置application.yml文件
server:
port: 8080
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
username: root
password: root
mybatis:
mapper-locations: classpath:mapper
步骤:3、创建controller、service(Impl)、entity、mapper类,以及mapper映射文件。
Controller(控制器)、
@Controller
public class HelloController {
@Autowired
private IStudent iStudent;
@RequestMapping("/getAll")
@ResponseBody
public List<Student> selectAll() {
List<Student> students = iStudent.getAll();
return students;
}
}
**********华丽分割线,下面两段是Service层的 接口与实现类
Iservice(service接口)
public interface IStudent {
public List<Student> getAll();
}
Impl(接口实现)、
@Service
public class StudentImpl implements IStudent {
@Autowired
StudentMapper studentMapper;
@Override
public List<Student> getAll() {
List<Student> students = studentMapper.getAll();
return students;
}
}
entity(实体类)、
@Component
public class Student {
private int id;
private String name;
private String sex;
private String classname;
}
步骤:4、运行SpringBoot入口
步骤:5、浏览器访问地址,显示数据,说明项目初步成功