一篇超详细的Spring|一篇超详细的Spring Boot对jdbc支持的文章一篇超详细的SpringBoot对jdbc支持

项目结构

pom.xml
启动类
Dao层
Service层
Controller层
测试类测试

总结

项目结构

一篇超详细的Spring|一篇超详细的Spring Boot对jdbc支持的文章

文章图片

pom.xml
pom.xml：

spring-boot-02com.keafmd1.0-SNAPSHOT4.0.0spring-boot-08org.springframework.bootspring-boot-starter-weborg.apache.tomcat.embedtomcat-embed-jasperjstljstl1.2org.springframework.bootspring-boot-starter-jdbcmysqlmysql-connector-java5.1.46org.springframework.bootspring-boot-starter-testorg.springframework.bootspring-boot-devtools

application.yml

server:port: 80spring:datasource:url: jdbc:mysql://127.0.0.1:3306/ssm-java1?useSSL=falsedriver-class-name: com.mysql.jdbc.Driverusername: rootpassword: 18044229

启动类

package com.keafmd; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; /** * Keafmd * * @ClassName: App08 * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 11:48 * @Blog: https://keafmd.blog.csdn.net/ */@SpringBootApplicationpublic class App08 {public static void main(String[] args) {SpringApplication.run(App08.class, args); }}

Dao层
UserDao：

package com.keafmd; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; /** * Keafmd * * @ClassName: App08 * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 11:48 * @Blog: https://keafmd.blog.csdn.net/ */@SpringBootApplicationpublic class App08 {public static void main(String[] args) {SpringApplication.run(App08.class, args); }}

Service层
IUserService ：

package com.keafmd.service; import java.util.List; /** * Keafmd * * @ClassName: IUserService * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 11:59 * @Blog: https://keafmd.blog.csdn.net/ */public interface IUserService {List list(); }

UserServiceImpl：

package com.keafmd.service.impl; import com.keafmd.dao.UserDao; import com.keafmd.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; /** * Keafmd * * @ClassName: UserServiceImpl * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 12:00 * @Blog: https://keafmd.blog.csdn.net/ */@Servicepublic class UserServiceImpl implements IUserService {@AutowiredUserDao userDao; @Overridepublic List list() {return userDao.userList(); }}

Controller层
UserController：

package com.keafmd.controller; import com.keafmd.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; /** * Keafmd * * @ClassName: UserController * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 18:04 * @Blog: https://keafmd.blog.csdn.net/ */@RestControllerpublic class UserController {@AutowiredIUserService userService; /*** http://127.0.0.1/userlist* @return*/@RequestMapping("userlist")List UserList(){return userService.list(); }}

测试类测试
UserDaoTest：

package com.keafmd.dao; import com.keafmd.App08; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import java.util.List; import static org.junit.jupiter.api.Assertions.*; @SpringBootTest(classes = App08.class)class UserDaoTest {@AutowiredUserDao userDao; @Testpublic void test(){List userlist = userDao.userList(); for (Object o : userlist) {System.out.println(o); }}}

【一篇超详细的Spring|一篇超详细的Spring Boot对jdbc支持的文章】运行test方法的效果：