SpringBoot总结(六)--连接oracle数据库demo

灰太狼 2023-01-01 02:57 214阅读 0赞

github下载界面[https://github.com/lsx888/springboot-lisx/tree/master/Jdbc\_oracle][https_github.com_lsx888_springboot-lisx_tree_master_Jdbc_oracle]（需要权限才能下载）

**目录**

1工程目录结构

2pom.xml

3User\_lisx.java

4JdbcApplication

5application.properties

6在test中测试

7运行效果

--------------------

# 1工程目录结构 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xzeDIwMTc_size_16_color_FFFFFF_t_70][]

# 2pom.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">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.3.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>Jdbc</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.oracle</groupId>
                <artifactId>ojdbc6</artifactId>
                <version>11.2.0.3</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

# 3User\_lisx.java #

package com.example.demo.model;
    
    import lombok.Data;
    import org.springframework.jdbc.core.RowMapper;
    
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    @Data
    public class User_lisx implements RowMapper<User_lisx> {
        private String username;
        private String password;
    
        //  必须重写mapRow方法
        @Override
        public User_lisx mapRow(ResultSet resultSet, int i) throws SQLException {
            User_lisx user_lisx = new User_lisx();
            user_lisx.setUsername(resultSet.getString("csdm"));
            user_lisx.setPassword(resultSet.getString("cansz"));
            return user_lisx;
        }
    }

# 4JdbcApplication #

package com.example.demo;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class JdbcApplication {
    
    	public static void main(String[] args) {
    		SpringApplication.run(JdbcApplication.class, args);
    	}
    
    }

# 5application.properties #

spring.datasource.driver-class-name: oracle.jdbc.driver.OracleDriver
    spring.datasource.url: jdbc:oracle:thin:@localhost:1521:orcl
    spring.datasource.username: wt300
    spring.datasource.password: wt300

# 6在test中测试 #

UserControllerTest.java

package com.example.demo.controller;
    
    import com.example.demo.model.User_lisx;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    @SpringBootTest
    @RunWith(SpringRunner.class)
    public class UserControllerTest {
        @Autowired
        private JdbcTemplate jdbcTemplate;
    
        @Test
        public void getUserByName() throws Exception {
            String sql = "select csdm,cansz from SP02 t";
            List<User_lisx> list = jdbcTemplate.query(sql, new User_lisx());
            for (User_lisx user : list) {
                System.out.println(user);
            }
        }
    }

# 7运行效果 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xzeDIwMTc_size_16_color_FFFFFF_t_70 1][]

[https_github.com_lsx888_springboot-lisx_tree_master_Jdbc_oracle]: https://github.com/lsx888/springboot-lisx/tree/master/Jdbc_oracle
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xzeDIwMTc_size_16_color_FFFFFF_t_70]: /images/20221120/5749d18f216b48549e6011e0004d8d33.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xzeDIwMTc_size_16_color_FFFFFF_t_70 1]: /images/20221120/8ecff784df05492db1d3e359e55665a0.png