springboot整合phoenix mybatis

其他整合mybatis查询很简单，就是保存需要拼接sql，不多说，直接贴代码

pom.xml

<dependency> <groupId>org.springframework.boot </groupId> <artifactId>spring-boot-starter-data-redis </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-test </artifactId> <scope>test </scope> </dependency> <dependency> <groupId>org.projectlombok </groupId> <artifactId>lombok </artifactId> <optional>true </optional> </dependency> <dependency> <groupId>com.fasterxml.jackson.core </groupId> <artifactId>jackson-databind </artifactId> <version>2.8.9 </version> </dependency> <!-- fastjson工具类 --> <dependency> <groupId>com.alibaba </groupId> <artifactId>fastjson </artifactId> <version>1.2.31 </version> </dependency> <dependency> <groupId>com.aliyun.phoenix </groupId> <artifactId>ali-phoenix-core </artifactId> <version>4.12.0-AliHBase-1.1-0.2 </version> </dependency> <dependency> <groupId>org.nutz </groupId> <artifactId>nutz </artifactId> <version>1.b.51 </version> </dependency> <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba </groupId> <artifactId>druid </artifactId> <version>1.1.12 </version> </dependency> <!-- https://mvnrepository.com/artifact/tk.mybatis/mapper --> <dependency> <groupId>tk.mybatis </groupId> <artifactId>mapper </artifactId> <version>4.0.2 </version> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter --> <dependency> <groupId>org.mybatis.spring.boot </groupId> <artifactId>mybatis-spring-boot-starter </artifactId> <version>1.3.2 </version> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql </groupId> <artifactId>mysql-connector-java </artifactId> </dependency>

application.yml

 

spring:   datasource:     type: com.alibaba.druid.pool.DruidDataSource     url:      username:      password:      driverClassName: org.apache.phoenix.jdbc.PhoenixDriver server:   port: 5858 mybatis:   mapper-locations: classpath:mybatis/*Mapper.xml   type-aliases-package:

 

DataSourceConfig
 
 

@Value("${spring.datasource.driverClassName}") private String driverClassName; @Value("${spring.datasource.password}") private String password; @Value("${spring.datasource.username}") private String username; @Value("${spring.datasource.url}") private String url; @Bean(name = "druidDataSource") public DruidDataSource druidDataSource() { DruidDataSource dds = new DruidDataSource(); try { dds.setDriverClassName(driverClassName); dds.setUrl(url); dds.setUsername(username); dds.setPassword(password); dds.setInitialSize(1); dds.setMaxActive(10); dds.setMinIdle(1); dds.setMaxWait(6000); dds.setPoolPreparedStatements(true); dds.setMaxOpenPreparedStatements(50); dds.setValidationQuery("SELECT 1"); dds.setTestOnBorrow(false); dds.setTestOnReturn(false); dds.setTestWhileIdle(true); dds.setTimeBetweenEvictionRunsMillis(60000); dds.setMinEvictableIdleTimeMillis(25200000); dds.setRemoveAbandoned(true); dds.setRemoveAbandonedTimeout(1800); dds.setLogAbandoned(false); dds.setFilters("stat"); } catch (SQLException e) { e.printStackTrace(); } return dds; } @Bean(name = "phoenixJdbcTemplate") public JdbcTemplate phoenixJdbcTemplate(@Qualifier("druidDataSource") DruidDataSource dataSource) { return new JdbcTemplate(dataSource); }

按照上面的步骤配置，使用 String sql ="upsert into table (id,name,data) values ( NEXT VALUE FOR SEQ ,'name',TO_DATE('2019-01-10 16:39:30'))"; jdbcTemplate.execute(sql); 就可以保存了，查询使用mybatis中的查询就行

请大哥们尊重原创，谢谢