Spring Boot对jdbc的支持【超详细】

一时失言乱红尘 2022-11-17 03:50 227阅读 0赞

### Spring Boot对jdbc的支持 ###

*  项目结构
 *  pom.xml
 *  application.yml
 *  启动类
 *  Dao层
 *  Service层
 *  Controller层
 *  测试类测试
 *  运行启动类，测试效果

# 项目结构 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70]

# pom.xml #

**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>
    
            
            <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>
    
    
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
    
            
            <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/ */
    
    
    @SpringBootApplication
    public class App08 { 
    
        public static void main(String[] args) { 
            SpringApplication.run(App08.class, args);
        }
    
    }

# Dao层 #

**UserDao：**

package com.keafmd.dao;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: UserDao * @Description: * @author: 牛哄哄的柯南 * @Date: 2021-04-08 11:47 * @Blog: https://keafmd.blog.csdn.net/ */
    @Repository
    public class UserDao { 
    
        @Autowired
        JdbcTemplate jdbcTemplate;
    
        public List userList(){ 
            String sql ="select * from user";
            return jdbcTemplate.queryForList(sql);
    
        }
    
    
    
    }

# 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/ */
    @Service
    public class UserServiceImpl implements IUserService { 
    
        @Autowired
        UserDao userDao;
    
        @Override
        public 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/ */
    @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);
            }
        }
    
    }

**运行test方法的效果：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 1]

# 运行启动类，测试效果 #

**运行启动类，访问：http://127.0.0.1/userlist**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 2]

> **以上就是Spring Boot对jdbc的支持【超详细】的全部内容。**

**看完如果对你有帮助，感谢点赞支持！  
如果你是电脑端的话，看到右下角的 “一键三连” 了吗，没错点它\[哈哈\]**  
![在这里插入图片描述][20210115230629703.gif_pic_center]

**加油！**

**共同努力！**

**Keafmd**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70]: /images/20221022/cadb122aa69c460faabb871047abc1f9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 1]: /images/20221022/82ac643eda2c460191c8916b675ccdc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 2]: /images/20221022/cffc3cdbcc2748489e3711021fc1e405.png
[20210115230629703.gif_pic_center]: /images/20221022/466b43942766465cb61fa7643a4a257f.png