,可以通过以下步骤实现:
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
import oracle.jdbc.pool.OracleDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
import java.sql.SQLException;
@Configuration
public class DataSourceConfig {
@Value("${spring.datasource.url}")
private String url;
@Value("${spring.datasource.username}")
private String username;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.driver-class-name}")
private String driverClassName;
@Bean
public DataSource dataSource() throws SQLException {
OracleDataSource dataSource = new OracleDataSource();
dataSource.setURL(url);
dataSource.setUser(username);
dataSource.setPassword(password);
dataSource.setDriverType(driverClassName);
return dataSource;
}
}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
@Service
public class OracleService {
private final DataSource dataSource;
@Autowired
public OracleService(DataSource dataSource) {
this.dataSource = dataSource;
}
public void queryData() throws SQLException {
try (Connection connection = dataSource.getConnection()) {
String sql = "SELECT * FROM your_table";
try (PreparedStatement statement = connection.prepareStatement(sql)) {
try (ResultSet resultSet = statement.executeQuery()) {
while (resultSet.next()) {
// 处理查询结果
}
}
}
}
}
}
以上就是在SpringBoot 2中获取OracleDataSource的完整步骤。在这个过程中,我们使用了Oracle官方提供的ojdbc驱动,并通过配置文件和数据源Bean的方式实现了与Oracle数据库的连接和操作。如果你想了解更多关于SpringBoot和Oracle数据库的相关内容,可以参考腾讯云的产品文档:Spring Boot和Oracle数据库。
领取专属 10元无门槛券
手把手带您无忧上云