SpringBoot 操作docker oracle容器

淡淡的烟草味﹌ 2022-05-08 06:56 222阅读 0赞

SpringBoot 操作docker oracle容器  
\#\#**springBoot pom配置**  
  
  
  
org.springframework.boot  
spring-boot-starter

<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-test</artifactId>
    		<scope>test</scope>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-aop</artifactId>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-web</artifactId>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-thymeleaf</artifactId>
    	</dependency>
    	
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-devtools</artifactId>
    		<optional>true</optional> 
    	</dependency>
    
    	
    	<dependency>
    		<groupId>mysql</groupId>
    		<artifactId>mysql-connector-java</artifactId>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.mybatis.spring.boot</groupId>
    		<artifactId>mybatis-spring-boot-starter</artifactId>
    		<version>${mybatis.spring.boot.starter.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>com.github.pagehelper</groupId>
    		<artifactId>pagehelper-spring-boot-starter</artifactId>
    		<version>${pagehelper.spring.boot.starter.version}</version>
    	</dependency>
    
    	
    	<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>${druid.version}</version>
        </dependency>
    
    	
    	<dependency>
    		<groupId>org.apache.commons</groupId>
    		<artifactId>commons-lang3</artifactId>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>commons-io</groupId>
    		<artifactId>commons-io</artifactId>
    		<version>${commons.io.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>commons-fileupload</groupId>
    		<artifactId>commons-fileupload</artifactId>
    		<version>${commons.fileupload.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.apache.shiro</groupId>
    		<artifactId>shiro-core</artifactId>
    		<version>${shiro.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.apache.shiro</groupId>
    		<artifactId>shiro-spring</artifactId>
    		<version>${shiro.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.apache.shiro</groupId>
    		<artifactId>shiro-ehcache</artifactId>
    		<version>${shiro.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>com.github.theborakompanioni</groupId>
    		<artifactId>thymeleaf-extras-shiro</artifactId>
    		<version>${thymeleaf.extras.shiro.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>com.alibaba</groupId>
    		<artifactId>fastjson</artifactId>
    		<version>${fastjson.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>eu.bitwalker</groupId>
    		<artifactId>UserAgentUtils</artifactId>
    		<version>${bitwalker.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-context-support</artifactId>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.quartz-scheduler</groupId>
    		<artifactId>quartz</artifactId>
    		<exclusions>
    			<exclusion>
    				<groupId>com.mchange</groupId>
    				<artifactId>c3p0</artifactId>
    			</exclusion>
    		</exclusions>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.apache.velocity</groupId>
    		<artifactId>velocity</artifactId>
    		<version>${velocity.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>com.github.penggle</groupId>
    		<artifactId>kaptcha</artifactId>
    		<version>${kaptcha.version}</version>
    		<exclusions>
    			<exclusion>
    				<artifactId>javax.servlet-api</artifactId>
    				<groupId>javax.servlet</groupId>
    			</exclusion>
    		</exclusions>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>io.springfox</groupId>
    		<artifactId>springfox-swagger2</artifactId>
    		<version>${swagger.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>io.springfox</groupId>
    		<artifactId>springfox-swagger-ui</artifactId>
    		<version>${swagger.version}</version>
    	</dependency>
    
    	
    	<dependency>
    		<groupId>org.jsoup</groupId>
    		<artifactId>jsoup</artifactId>
    		<version>${jsoup.version}</version>
    	</dependency>
    	
    	
    	<dependency>
    		<groupId>org.apache.poi</groupId>
    		<artifactId>poi-ooxml</artifactId>
    		<version>3.17</version>
    	</dependency>
    			
    	<dependency>
    		<groupId>com.oracle</groupId>
    		<artifactId>ojdbc8</artifactId>
    		<version>11.2.0.2</version>
    	</dependency>
    		<dependency>
    		<groupId>com.google.guava</groupId>
    		<artifactId>guava</artifactId>
    		<version>18.0</version>
    	</dependency>
    		<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-data-jpa</artifactId>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-data-rest</artifactId>
    	</dependency>
    	
    </dependencies>
    
    <build>
    	<finalName>${project.artifactId}</finalName>
    	<plugins>
    		<plugin>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-maven-plugin</artifactId>
    			<configuration>
    				<fork>true</fork> 
    			</configuration>
    		</plugin>
    	</plugins>
    </build>

application.yml 配置  
spring:  
datasource:  
url: jdbc:oracle:thin:@192.168.1.215:1521:xe  
type: com.alibaba.druid.pool.DruidDataSource  
username: system  
password: oracle  
driver-class-name: oracle.jdbc.OracleDriver  
jpa:  
hibernate:  
ddl-auto: update

tnsnames.ora 配置  
XE =  
(DESCRIPTION =  
(ADDRESS\_LIST =  
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))  
)  
(CONNECT\_DATA =  
(SERVICE\_NAME = xe)  
)  
)