帮助使用氚云的各位快速crud
本方法包括:
1.氚云通用删除工具类
2.氚云通用获取全部参数工具类
3.氚云通用单关键字检索工具类
请注意 使用本工具类需要导入OKHttp3
<!-- https://mvnrepository.com/artifact/com.squareup.okhttp3/okhttp -->
<dependency>
<groupId>com.squareup.okhttp3</groupId>
<artifactId>okhttp</artifactId>
<version>4.9.1</version>
</dependency>
下面放代码
package Frame.util;
import okhttp3.*;
import org.springframework.lang.NonNull;
import java.io.IOException;
public class RequestTool {
/**
* 氚云通用获取全部参数工具类
* @param tableName 表名
* @return Response 类型的服务器返回数据
* */
public static Response getParameterConnection(@NonNull String tableName)throws IOException {
if (tableName.equals(""))return null;
OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "\r\n{\r\n\"ActionName\":\"LoadBizObjects\"," +
"\r\n\"SchemaCode\":\""+tableName+"\",\r\n\"Filter\":\"{\\\"FromRowNum\\\": 0," +
"\\\"RequireCount\\\": false,\\\"ReturnItems\\\": [], \\\"SortByCollection\\\": [],\\\"ToRowNum\\\": 500, " +
" \\\"Matcher\\\": { \\\"Type\\\": \\\"And\\\", \\\"Matchers\\\": [{}]}}\"\r\n}");
Request request = new Request.Builder()
.url("https://www.h3yun.com/OpenApi/Invoke")
.method("POST", body)
.addHeader("Content-Type", "application/json")
.addHeader("EngineCode", "yourEngineCode")
.addHeader("EngineSecret", "yourEngineSecret") .build();
return client.newCall(request).execute();
}
/**
* 氚云通用删除工具类
* @param SchemaCode 表名
* @param BizObjectId 列ID
* @return Response 类型的服务器返回数据
* */
public static Response deleteCorrespondingColumn(@NonNull String SchemaCode,@NonNull String BizObjectId)throws IOException{
if (SchemaCode.length() < 1 || BizObjectId.length() < 1)return null;
OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\r\n\"ActionName\":\"RemoveBizObject\"," +
"\r\n\"SchemaCode\":\""+SchemaCode+"\",\r\n\"BizObjectId\":\""+BizObjectId+"\"}");
Request request = new Request.Builder()
.url("https://www.h3yun.com/OpenApi/Invoke")
.method("POST", body)
.addHeader("Content-Type", "application/json")
.addHeader("EngineCode", "yourEngineCode")
.addHeader("EngineSecret", "yourEngineSecret") .build();
return client.newCall(request).execute();
}
/**
* 氚云通用单关键字检索工具类
* @param isVague 是否模糊查询
* @param type 字段名
* @param Key 要检索的关键字
* @return Response 类型的服务器返回数据
* */
public static Response SingleKeywordSearch(Boolean isVague,String tableName,String type,String Key) throws IOException {
//System.out.println("isV:"+isVague);
if (Key.equals(""))return null;
int VAGUE;
//true为模糊查询,反之为不模糊
if (isVague) VAGUE = 8;else VAGUE = 2;
OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\r\n\"ActionName\":\"LoadBizObjects\",\r\n\"SchemaCode\":\""+tableName+"\"," +
"\r\n\"Filter\":\"{\\\"FromRowNum\\\":0,\\\"RequireCount\\\":false,\\\"ReturnItems\\\":[],\\\"SortByCollection\\\": [],\\\"ToRowNum\\\": 500," +
" \\\"Matcher\\\": { \\\"Type\\\": \\\"And\\\", \\\"Matchers\\\": [{\\\"Type\\\":\\\"Item\\\",\\\"Name\\\":\\\""+type+"\\\"," +
"\\\"Operator\\\":"+VAGUE+",\\\"Value\\\":\\\"" + Key + "\\\"},]}}\"\r\n}");
Request request = new Request.Builder()
.url("https://www.h3yun.com/OpenApi/Invoke")
.method("POST", body)
.addHeader("Content-Type", "application/json")
.addHeader("EngineCode", "yourEngineCode")
.addHeader("EngineSecret", "yourEngineSecret") .build();
return client.newCall(request).execute();
}
}