1.3 spring boot整合presto

系统管理员 2021-12-16 04:16 704阅读 0赞

首先自己创建spring boot工程，做好基本引用；下面只介绍满足presto的引用

引用pom文件：

<groupId>junit</groupId>

<artifactId>junit</artifactId>

</dependency>

<groupId>com.facebook.presto</groupId>

<artifactId>presto-jdbc</artifactId>

</dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-jdbc</artifactId>

</dependency>

<groupId>com.zaxxer</groupId>

<artifactId>HikariCP</artifactId>

</dependency>

</dependencies>

application.properties文件：

server.port=8000

spring.datasource.presto.name=presto

spring.datasource.presto.type=org.apache.tomcat.jdbc.pool.DataSource

spring.datasource.presto.driver-class-name=com.facebook.presto.jdbc.PrestoDriver

spring.datasource.presto.jdbc-url=jdbc:presto://192.168.227.3:8001/system/runtime //url改成jdbc-url，不然可能会报jdbcUrl is required with driverClassName

spring.datasource.presto.username=root

数据源配置类：

import javax.sql.DataSource;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.boot.jdbc.DataSourceBuilder;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.jdbc.core.JdbcTemplate;

/\*\*

\* <p>创建数据源配置类</p>

\* 2019年7月4日上午8:52:44

\* @author lvjie

\*/

@Configuration

public class GlobalDataSourceConfiguration \{

private static Logger LOG = LoggerFactory.getLogger(GlobalDataSourceConfiguration.class);

@Bean(name = "prestoDataSource")

@ConfigurationProperties(prefix = "spring.datasource.presto")

public DataSource prestoDataSource() \{

LOG.info("-------------------- presto init ---------------------");

return DataSourceBuilder.create().build();

@Bean(name = "prestoTemplate")

public JdbcTemplate prestoJdbcTemplate(@Qualifier("prestoDataSource") DataSource dataSource) \{

return new JdbcTemplate(dataSource);

访问使用类：

import java.util.List;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Service;

import com.hww.boot.service.ITestService;

@Service

public class TestServiceImpl implements ITestService\{

@Autowired

@Qualifier("prestoTemplate")

private JdbcTemplate prestoTemplate;

@Override

public List<Map<String, Object>> findList() \{

// TODO Auto-generated method stub

return prestoTemplate.queryForList("SELECT a.id,a.name,b.id,b.name FROM postgresql.public.fd\_area a,mongodb.test.user b where a.id = b.id");

1.3 spring boot整合presto

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 13. Mybatis 整合Spring boot 2

相关 Spring Boot（八）：Spring Boot整合Druid和整合JSP

相关【Spring Boot】034-Spring Boot 整合 JUnit

相关【Spring Boot】010-Spring Boot整合Mybatis

相关 Spring Boot 实战（13）springboot 整合redis

相关 presto整合MyBatis

相关 Spring Boot整合一之Spring Boot整合RabbitMQ

相关 Spring Boot -03- Spring Boot 整合 JSP

相关 1.3 spring boot整合presto

相关 Spring Boot 13-springjpa