一、引入依赖

中的表我们如何用Java框架来操作MaxComputer中的表数据呢有几种方法今天我推荐的是MaxComputer结合Spring

Boot

https://maxcompute.console.aliyun.com/cn-shanghai/sql-express

一、引入依赖

依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!--添加阿里云的依赖--dependencygroupIdcom.aliyun/groupIdartifactIdaliyun-java-sdk-core/artifactIdversion4.5.0/version/dependencydependencygroupIdcom.aliyun.odps/groupIdartifactIdodps-sdk-udf/artifactIdversion0.36.4-public/version/dependencydependencygroupIdcom.aliyun.odps/groupIdartifactIdodps-sdk-core/artifactIdversion0.36.4-public/version/dependency!--

MyBatis

--dependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion2.0.1/version/dependency!--

MaxCompute

--dependencygroupIdcom.aliyun.odps/groupIdartifactIdodps-jdbc/artifactIdversion3.2.0/version/dependency

二、配置文件

aliyun.accessKeySecretN8rsIEWSH6AwinhfDp8shiDEHhRbpD

aliyun.endpoint

http://service.cn-shanghai.maxcompute.aliyun.com/api

aliyun.project

spring.datasource.urljdbc:odps:http://service.cn-shanghai.maxcompute.aliyun.com/api?projectliingniu_2023

spring.datasource.passwordN8rsIEWSH6AwinhfDp8shiDEHhRbpD

spring.datasource.driver-class-namecom.aliyun.odps.jdbc.OdpsDriver#

MyBatis

mybatis.mapper-locationsclasspath:mapper/*.xml

三、实体类User.java

com.huixin.service.UserService;

import

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

import

org.springframework.web.bind.annotation.*;import

RequestMapping(/api)

return*/GetMapping(/users)public

ListUser

userService.selectAll();}}五、UserService

package

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

import

org.springframework.stereotype.Service;import

public

userDao.getAllUsers();}}六、UserDao

package

org.apache.ibatis.annotations.Mapper;import

java.util.List;/***

3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd

mapper

namespacecom.huixin.dao.UserDaoselect

idgetAllUsers

resultTypecom.huixin.model.UserSELECT

id,

操作。

它的设计更多地侧重于批处理和大规模数据查询因此MaxCompute

中并不直接支持