1、spring boot集成jdbctemplate
依赖:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<!--<version>2.1.0.RELEASE</version>-->
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>dubbo</artifactId>
<version>${com.alibaba.dubbo.version}</version>
<exclusions>
<exclusion>
<groupId>org.springframework</groupId>
<artifactId>spring</artifactId>
</exclusion>
<exclusion>
<artifactId>fastjson</artifactId>
<groupId>com.alibaba</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>com.facebook.presto</groupId>
<artifactId>presto-jdbc</artifactId>
<version>0.205</version>
</dependency>
2.application.properties中的配置
spring.datasource.url=jdbc:presto://IP:8848/hive/default
spring.datasource.username=root
#spring.datasource.password=123456
spring.datasource.driver-class-name=com.facebook.presto.jdbc.PrestoDriver
dubbo.application.name=hive-enquiry
dubbo.registry.protocol=zookeeper
#本地
dubbo.registry.address=127.0.0.1:2181
dubbo.protocol.name=dubbo
dubbo.protocol.port=20884
#链接监控中心
dubbo.monitor.protocol=registry
3、接口实现
@Component
@Service(version = "1.0.0", interfaceClass = HiveEnquiryService.class, timeout = 30000)
public class HiveEnquiryServiceImpl implements HiveEnquiryService {
4、启动类
@DubboComponentScan(basePackages = "hive.enquiry")
@EnableDubbo()
5、消费者
xml的配置
package com.config;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.ImportResource;
@Configuration
@ImportResource(locations={"consumer.xml"})
public class ConfigDataSource {
}
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:dubbo="http://code.alibabatech.com/schema/dubbo"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://code.alibabatech.com/schema/dubbo
http://code.alibabatech.com/schema/dubbo/dubbo.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="com.service"></context:component-scan>
<dubbo:application name="all-consumers">
<dubbo:parameter key="qos.enable" value="true" />
<dubbo:parameter key="qos.accept.foreign.ip" value="false" />
<dubbo:parameter key="qos.port" value="33333" />
</dubbo:application>
<dubbo:registry address="127.0.0.1:2181" protocol="zookeeper" timeout="30000"></dubbo:registry>
<dubbo:reference interface="com.service.HiveEnquiryService" id="hiveEnquiryService" version="1.0.0" timeout="30000" check="false"></dubbo:reference>
还有其他方法待更新