当前位置：网站首页>SQL Server Connectors By Thread Pool | DTSQLServerTP 插件使用说明
SQL Server Connectors By Thread Pool | DTSQLServerTP 插件使用说明
2022-04-23 20:14:00 【阿六_Dexter】
本插件主要是支持在UE4蓝图中使用线程池异步连接和异步操作SQL Server数据库。
本插件采用的链接和执行SQL都是异步操作，不会卡主绘画主线程，提高运行效率。在数据库返回以后才会回调蓝图的Completed节点。
1. 数据库连接 【 Create SQL Server 】
输入：
Host：数据库IP地址
Port: 数据库开放端口
User: 数据库用户名
Password：数据库密码
DBName：指定连接的数据库库名
Thread Pool Count：连接线程的数量
输出：
Success：返回数据库是否连接成功
Error No: 连接错误返回错误编号，成功返回0
Error Msg：连接错误返回错误信息
2. 操作数据库 【 Execute SQL 】
输入：
SQL: 执行的SQL语句，支持 SELECT, DELETE, INSERT, UPDATE, EXEC。 基本所有的SQL语句都是支持的，可以直接在这里操作数据库。
需要一定的SQL语法知识掌握，可以参考 SQL Server教程 (yiibai.com)
输出：
Success： 返回操作是否执行成功
Error No：错误编号，成功返回0
Error Msg: 执行错误返回错误信息
Result：返回数据库结果集
3. 结果集分解
Result 返回的结果集为 一个MAP的数组，一个数组等于一行的信息，这一行的数据保存在一个MAP中。
也可以使用本插件自带功能，把输出结果集转换为JSON。
版权声明
本文为[阿六_Dexter]所创，转载请带上原文链接，感谢
https://blog.csdn.net/wmy19890322/article/details/124324676
边栏推荐
- STM32 Basics
- An error is reported in the initialization metadata of the dolphin scheduler -- it turns out that there is a special symbol in the password. "$“
- NC basic usage 4
- Change the material of unity model as a whole
- Five minutes to show you what JWT is
- R language uses timeroc package to calculate the multi time AUC value of survival data under competitive risk, uses Cox model and adds covariates, and R language uses the plotauccurve function of time
- SIGIR'22「微软」CTR估计：利用上下文信息促进特征表征学习
- 山东大学软件学院项目实训-创新实训-网络安全靶场实验平台（六）
- Electron入门教程3 ——进程通信
- selenium. common. exceptions. WebDriverException: Message: ‘chromedriver‘ executable needs to be in PAT
猜你喜欢
PHP reference manual string (7.2000 words)
AQS learning
【文本分类案例】(4) RNN、LSTM 电影评价倾向分类，附TensorFlow完整代码
Wave field Dao new species end up, how does usdd break the situation and stabilize the currency market?
如何在BNB链上创建BEP-20通证
[text classification cases] (4) RNN and LSTM film evaluation Tendency Classification, with tensorflow complete code attached
PCL点云处理之计算两平面交线（五十一）
CVPR 2022 | querydet: use cascaded sparse query to accelerate small target detection under high resolution
程序设计语言基础(2)
STM32 Basics
随机推荐
How to do product innovation—— Exploration of product innovation methodology I
【问题解决】‘ascii‘ codec can‘t encode characters in position xx-xx: ordinal not in range(128)
R language uses the preprocess function of caret package for data preprocessing: BoxCox transform all data columns (convert non normal distribution data columns to normal distribution data and can not
CVPR 2022 | querydet: use cascaded sparse query to accelerate small target detection under high resolution
Cadence OrCAD capture batch change component packaging function introduction graphic tutorial and video demonstration
Kibana reports an error server is not ready yet. Possible causes
Building googlenet neural network based on pytorch for flower recognition
Local call feign interface message 404
STM32 Basics
R语言ggplot2可视化分面图（facet_wrap）、使用lineheight参数自定义设置分面图标签栏（灰色标签栏）的高度
渤海期货这家公司怎么样。期货开户办理安全？
Intersection calculation of straight line and plane in PCL point cloud processing (53)
Mfcc: Mel frequency cepstrum coefficient calculation of perceived frequency and actual frequency conversion
SRS 的部署
Five minutes to show you what JWT is
Mysql database - single table query (III)
The textarea cursor cannot be controlled by the keyboard due to antd dropdown + modal + textarea
Azkaban recompile, solve: could not connect to SMTP host: SMTP 163.com, port: 465 [January 10, 2022]
R language survival package coxph function to build Cox regression model, ggrisk package ggrisk function and two_ Scatter function visualizes the risk score map of Cox regression, interprets the risk
SRS deployment