您好,登錄后才能下訂單哦!
這篇文章將為大家詳細(xì)講解有關(guān)Spring Boot對(duì)jdbc支持的示例分析,小編覺得挺實(shí)用的,因此分享給大家做個(gè)參考,希望大家閱讀完這篇文章后可以有所收獲。
pom.xml:
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <parent> <artifactId>spring-boot-02</artifactId> <groupId>com.keafmd</groupId> <version>1.0-SNAPSHOT</version> </parent> <modelVersion>4.0.0</modelVersion> <artifactId>spring-boot-08</artifactId> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- 解析jsp類庫 --> <dependency> <groupId>org.apache.tomcat.embed</groupId> <artifactId>tomcat-embed-jasper</artifactId> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- JDBC-啟動(dòng)器, 默認(rèn)的數(shù)據(jù)源 HikariCP --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!-- JDBC-啟動(dòng)器, 默認(rèn)的數(shù)據(jù)源 HikariCP --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.46</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> </dependency> </dependencies> </project>
application.yml
server: port: 80 spring: datasource: url: jdbc:mysql://127.0.0.1:3306/ssm-java1?useSSL=false driver-class-name: com.mysql.jdbc.Driver username: root password: 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); }}
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/ */ @SpringBootApplication public class App08 { public static void main(String[] args) { SpringApplication.run(App08.class, args); } }
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/ */ @Service public class UserServiceImpl implements IUserService { @Autowired UserDao userDao; @Override public List list() { return userDao.userList(); } }
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/ */ @RestController public class UserController { @Autowired IUserService 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 { @Autowired UserDao userDao; @Test public void test(){ List userlist = userDao.userList(); for (Object o : userlist) { System.out.println(o); } } }
運(yùn)行test方法的效果:
運(yùn)行啟動(dòng)類,測(cè)試效果
運(yùn)行啟動(dòng)類,訪問:http://127.0.0.1/userlist
關(guān)于“Spring Boot對(duì)jdbc支持的示例分析”這篇文章就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,使各位可以學(xué)到更多知識(shí),如果覺得文章不錯(cuò),請(qǐng)把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。