tableinfo

最新推荐文章于 2022-12-09 23:33:32 发布
转载 最新推荐文章于 2022-12-09 23:33:32 发布 · 687 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：https://my.oschina.net/bboss/blog/638840

为什么80%的码农都做不了架构师？>>>   hot3.png



INSERT INTO `tableinfo` (`TABLE_NAME`, `TABLE_ID_NAME`, `TABLE_ID_INCREMENT`, `TABLE_ID_VALUE`, `TABLE_ID_GENERATOR`, `TABLE_ID_TYPE`, `TABLE_ID_PREFIX`) VALUES
('TB_SM_INPUTTYPE', 'INPUT_TYPE_ID', 1, 9, 'SEQ_TB_SM_INPUTTYPE', 'sequence', ' '),
('td_cms_channel', 'channel_id', 1, 1, NULL, 'int', NULL),
('td_cms_collect_answer', 'answer_id', 1, 0, NULL, 'int', NULL),
('td_cms_collect_ipctrl2', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_collect_title', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOCCOMMENT_DICT', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOCCOM_IMPEACHINFO', 'ID', 1, 0, NULL, 'int', NULL),
('td_cms_docsource', 'docsource_id', 1, 1, NULL, 'int', NULL),
('td_cms_document', 'document_id', 1, 2, NULL, 'int', NULL),
('td_cms_doc_attach', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOC_COMMENT', 'COMMENT_ID', 1, 0, 'SEQ_TD_CMS_DOC_COMMENT', 'sequence', NULL),
('td_cms_doc_task', 'task_id', 1, 6, NULL, 'int', NULL),
('td_cms_doc_template', 'id', 1, 0, 'SEQ_TD_CMS_DOC_TEMPLATE', 'sequence', NULL),
('td_cms_extfield', 'field_id', 1, 0, NULL, 'int', NULL),
('TD_CMS_EXTVALUESCOPE', 'ID', 1, 0, NULL, 'int', NULL),
('td_cms_mailserverinfo', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_site', 'site_id', 1, 1, NULL, 'int', NULL),
('td_cms_site_search', 'id', 1, 1, NULL, 'int', NULL),
('td_cms_template', 'template_id', 1, 3, NULL, 'int', NULL),
('TD_CMS_TEMPLATE_STYLE', 'STYLE_ID', 1, -1, NULL, 'int', NULL),
('TD_CMS_VOTE_ANSWER', 'ANSER_ID', 1, 0, 'SEQ_TD_CMS_VOTE_ANSWER', 'sequence', NULL),
('TD_CMS_VOTE_IPCTRL', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_vote_items', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_vote_questions', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_VOTE_TIMECTRL', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_VOTE_TITLE', 'id', 1, 0, NULL, 'int', NULL),
('TD_ESB_BUSINESS_LINE', 'BUSINESS_LINE_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_GLOBAL_PARAM', 'PARAM_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_GROUP', 'GROUP_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_METADATA', 'METADATA_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_METADATA_SET', 'METADATA_SET_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_RESOUCE_PERMISSION', 'resouce_permission_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE', 'service_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_METADATA', 'service_metadata_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RESOURCE', 'id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RESOURCE_DETAIL', 'service_res_detail_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RES_CALLED_LOG', 'LOG_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_SERVICE_RES_STATUS_LOG', 'ID', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_STATUS_LOG', 'ID', 1, 0, '', 'uuid', ''),
('td_remindinfo', 'id', 1, 0, NULL, 'int', NULL),
('td_sd_notepaper', 'notepaper_id', 1, 0, 'SEQ_TD_SD_NOTEPAPER', 'sequence', ' '),
('td_sd_notic', 'notic_id', 1, 0, 'SEQ_TD_SD_NOTIC', 'sequence', ' '),
('td_sd_ratifyadvice', 'ratifyadvice_id', 1, 0, 'SEQ_TD_SD_RATIFYADVICE', 'sequence', ' '),
('td_sd_remind', 'remind_id', 1, 0, 'SEQ_TD_SD_REMIND', 'sequence', ' '),
('td_sd_schedular', 'schedular_id', 1, 0, 'SEQ_TD_SD_SCHEDULAR', 'sequence', ' '),
('td_sm_dictdata', 'dictdata_id', 1, 193, 'SEQ_TD_SM_DICTDATA', 'sequence', ' '),
('TD_SM_DICTKEYWORDS', 'KEYWORD_ID', 1, 0, 'SEQ_DICTKEYWORD', 'sequence', ' '),
('td_sm_dicttype', 'dicttype_id', 1, 2312, 'SEQ_TD_SM_DICTTYPE', 'sequence', ' '),
('td_sm_group', 'group_id', 1, 0, 'SEQ_TD_SM_GROUP', 'sequence', ' '),
('td_sm_job', 'job_id', 1, 1, 'SEQ_TD_SM_JOB', 'sequence', ' '),
('TD_SM_LOG', 'LOG_ID', 1, 121, 'SEQ_LOG', 'sequence', ' '),
('TD_SM_LOGDETAIL', 'DETAIL_ID', 1, 0, 'SEQ_LOG_DETAIL', 'sequence', ' '),
('TD_SM_LOGMODULE', 'id', 1, 3, 'SEQ_TD_SM_LOGMODULE', 'sequence', ' '),
('td_sm_organization', 'org_id', 1, 1, 'SEQ_TD_SM_ORGANIZATION', 'sequence', ' '),
('td_sm_res', 'res_id', 1, 0, 'SEQ_TD_SM_RES', 'sequence', ' '),
('td_sm_role', 'role_id', 1, 4, 'SEQ_TD_SM_ROLE', 'sequence', ' '),
('td_sm_roletype', 'type_id', 1, 1, 'SEQ_TD_SM_ROLETYPE', 'sequence', ' '),
('td_sm_user', 'user_id', 1, 1, 'SEQ_TD_SM_USER', 'sequence', ' '),
('tl_cms_doc_oper_log\n', 'id', 1, 0, NULL, 'int', NULL);

转载于:https://my.oschina.net/bboss/blog/638840

MyBatis Plus生成代码秘诀：模板文件中的TableInfo实用指南
u013558123的博客
04-09 1067
TableInfo类是MyBatis Plus代码生成过程中模板文件中的核心所在。通过其丰富的属性和方法，开发者可以轻松地获取数据库表的结构和注解信息，生成符合自己需求的代码。
mysql table info_mysql的简单操作
weixin_35286433的博客
01-27 784
mac版打开mysql需要执行以下语句：<1>alias mysql=/usr/local/mysql/bin/mysql<2>mysqladmin=/usr/local/mysql/bin/mysqladmin<3>mysql -u root -p;<4>输入你的mysql密码；<5>在mysql命令行输入：show database...
获取所有表及属性
cxzhq2002的杂记
09-07 512
create VIEW [dbo].[VTableInfo] AS SELECT DISTINCT                       obj.name AS TableName, col.colid AS ColumnIndex, col.name AS ColumnName, scol.DATA_TYPE, col.length AS ColumnLength, CONVERT
Oracle中tablesinfo_oracle table info
weixin_42382558的博客
12-23 249
--在删除一个表中的全部数据时，须使用TRUNCATE TABLE--因为用DROP TABLE，DELETE * FROM 表名时，TABLESPACE表空间该表的占用空间并未释放，反复几次DROP，DELETE操作后，该TABLESPACE上百兆的空间就被耗光了。--删除指定用户所有表的方法select 'Drop table '||table_name||';' from all_table...
mapxtreme2004经典代码之二：TableInfo
weixin_34110749的博客
01-08 119
The example code below convers the concept of System.Reflection.Also it is a Window application, but I have write Console.WriteLine() method in it, so u should run it in the command line like thiseg: ...
商业编程-源码-Csharp实例74 tableInfo.zip
06-20
在本压缩包“商业编程-源码-Csharp实例74 tableInfo.zip”中，我们可以深入探讨C#编程语言的一个实际应用实例，特别是涉及到表格信息处理的方面。C#是一种广泛用于构建Windows桌面应用、Web应用以及游戏开发的强大...
//风雨水情查询 private async sendMessage(text?: string) { if (this.textLoading && !text) { this.$message.warning("稍等片刻，等Deepseek回复后再发送哦～"); return; } if (!this.content.trim() && !text) { this.$message.warning("不可发送空消息"); return; } // 接口参数 const params = { query: this.content.trim() || text, user: JSON.parse(sessionStorage.getItem("role")).loginName, inputs: {}, response_mode: "blocking", conversation_id: this.selectId, }; //预案信息 使用streaming模式 if (this.content.includes("预案")) { params.response_mode = "streaming"; this.genericPlan(); return; } if (!text) { // 添加用户消息 this.chartData.push({ type: "self", content: this.content }); } this.scrollToBottom(); this.textLoading = true; this.showBtn = false; try { const res: any = await chartServer.openDeepseek(params); //创建表格 const tableinfo: any = Vue.observable({ type: "table", data: [], AItitle: "", pointType: "", isShow: true, }); const root: any = Vue.observable({ type: "root", content: "", AItitle: "", pointType: "", idnex: 0, }); if (!res) { this.$Bus.$emit("clearAllData"); // 清空其他点位 this.chartData.push(tableinfo); } else { // 普通请求 if (!this.isValidJSON(res.answer)) { root.content = res.answer; root.showType = "markdown"; this.textLoading = false; this.content = ""; this.chartData.push(root); // 添加AI消息 // 获取应该添加多少个流试输出 let num = this.chartData.filter(item => item.type == "root").length - 1; root.idnex = num; this.triggerResponse(res.answer, num); return; } // 天气查询 if (this.content.includes("天气")) { root.content = JSON.parse(res.answer).summary; root.showType = "markdown"; this.textLoading = false; this.content = ""; this.chartData.push(root); // 添加AI消息 // 获取应该添加多少个流试输出 let num = this.chartData.filter(item => item.type == "root").length - 1; root.idnex = num; this.triggerResponse(JSON.parse(res.answer).summary, num); return; } // 判断是查询条数还是查询站点或者资源周边 选择条数需要带上之前会话id if (res.conversation_id) { this.selectId = res.conversation_id; } else { this.selectId = ""; } console.log(9071, JSON.parse(res.answer)); let resat = JSON.parse(res.answer).data; // 定位或者周边选择的数据 let selectedData = JSON.parse(res.answer).selected || []; if (resat.length == 0 && selectedData.length == 0) { tableinfo.isShow = false; this.$Bus.$emit("clearAllData"); // 清空其他点位 } console.log(959, resat, selectedData); // 风雨水气象查询 if (JSON.parse(res.answer).type == "气象查询") { console.log(1278, JSON.parse(res.answer)); this.tableData = resat; // 总结标题 this.AItitle = JSON.parse(res.answer).summary; // 气象查询查数量 if (this.tableData.length) { switch (this.tableData[0].qxtype) { case "sq": this.pointType = "water"; tableinfo.pointType = "water"; this.getNljsListData(this.tableData); break; // 昨日雨情信息 case "hsyq": this.pointType = "rain"; tableinfo.pointType = "rain"; this.getYqjcListData(this.tableData); break; case "yq": this.pointType = "rain"; tableinfo.pointType = "rain"; this.getYqjcListData(this.tableData); break; case "fq": this.pointType = "wind"; tableinfo.pointType = "wind"; this.getfqjcListData(this.tableData); break; //水库水位下降预警 case "xjsw": this.pointType = "waterRegime"; tableinfo.pointType = "waterRegime"; this.getNljsListData(this.tableData); break; case "sksq": this.pointType = "reservoir"; tableinfo.pointType = "reservoir"; this.getNljsListData(this.tableData); break; default: tableinfo.pointType = "noTable"; break; } tableinfo.data = this.tableData; } // 气象查询只有一条数据时直接定位到点位 打开弹框 if (this.tableData.length == 1) { setTimeout(() => { this.clickSingleData(this.tableData[0], tableinfo.pointType); }, 10); } if (this.AItitle) { tableinfo.AItitle = this.AItitle; tableinfo.isShow = true; } } // 周边资源查询 if (JSON.parse(res.answer).type == "资源查询") { console.log(1343, JSON.parse(res.answer)); if (selectedData.length == 0 && resat.length > 0) { if (resat[0].mainType) { this.pointType = resat[0].mainType; tableinfo.pointType = resat[0].mainType; tableinfo.AItitle = resat[0].tabCnName+"查询总数"+resat.length+"条" || ""; console.log(1031, this.pointType, tableinfo.pointType); } else { this.pointType = "queryAssets"; tableinfo.pointType = "queryAssets"; tableinfo.AItitle = "请点击 选择 按钮 或者在下方 输入 查询该条数据的位置信息或者周边资源信息"; } this.$store.state.mapModule.mapObj.centerAtPoint( 114.2373, 23.539, 9, ); //设置视角 tableinfo.data = resat; this.addPositionPoint(resat); console.log(1054, this.pointType, tableinfo.pointType); } //周边资源查询只有一条数据时直接选择第一条 if (selectedData.length == 0 && resat.length == 1) { setTimeout(() => { this.Details(resat[0], 0); }, 10); } } if (JSON.parse(res.answer).type == "选择数据，选择第几条数据") { if (resat.length && resat[0].tabCnName) { tableinfo.data = resat; this.pointType = resat[0].mainType; tableinfo.pointType = resat[0].mainType; tableinfo.AItitle = tableinfo.data.length > 1 ? "选择数据如下" : "该条数据如下"; this.chartData.push(tableinfo); this.checkCenter(resat[0], false); return; } else { switch (resat[0].qxtype) { case "sq": this.pointType = "water"; tableinfo.pointType = "water"; break; case "yq": this.pointType = "rain"; tableinfo.pointType = "rain"; break; case "fq": this.pointType = "wind"; tableinfo.pointType = "wind"; break; case "sksq": this.pointType = "reservoir"; tableinfo.pointType = "reservoir"; break; case "hsyq": this.pointType = "rain"; tableinfo.pointType = "rain"; break; case "xjsw": this.pointType = "waterRegime"; tableinfo.pointType = "waterRegime"; break; default: break; } tableinfo.data = resat.map(item => { return { ...item, isOne: true, id: item.id || item.obtid || item.stcd, tabName: item.qxtype == "sq" ? "waterSituation" : item.qxtype == "yq" ? "yu" : "feng", }; }); console.log(1143, tableinfo.data); // tableinfo.AItitle =tableinfo.data.length > 1? "选择数据如下 总共"+tableinfo.data.length+'条':"该条数据如下"; tableinfo.AItitle = tableinfo.data.length > 1 ? "选择数据如下" : "该条数据如下"; this.clickSingleData(tableinfo.data[0], this.pointType); } } // 选择定位功能 if (selectedData.length > 0 && resat.length == 0) { let itemData = JSON.parse(res.answer).selected[0]; this.pointType = "queryAssets"; tableinfo.pointType = "queryAssets"; this.checkCenter(itemData); tableinfo.AItitle = "已定位至该位置"; tableinfo.data = itemData; } // 周边资源信息 if (selectedData.length > 0 && resat.length > 0) { console.log(1037, "周边周边", resat); this.surroundingsinfo = selectedData[0]; this.pointType = "surroundings"; tableinfo.pointType = "surroundings"; this.radius = JSON.parse(res.answer).radius; this.checkCenter(selectedData[0]); this.addPositionPoint(resat); tableinfo.AItitle = "周边资源数据如下"; tableinfo.data = resat; } //周边资源查询只有一条数据时 直接定位打开弹框 if (resat.length == 1) { this.checkCenter(resat[0], false); } this.chartData.push(tableinfo); } } finally { console.log(895, this.chartData); this.textLoading = false; this.content = ""; this.scrollToBottom(); } }帮我优化以上代码逻辑
最新发布
09-03
const tableinfo = this.createTableInfo(); this.chartData.push(tableinfo); } ``` --- #### ✅ 6. 主要响应处理函数 ```ts private async handleResponse(res: any) { const parsed = this.parseAnswer(res...
configBuilder TableInfo 自定义字段
06-10
如果您想在使用 configBuilder 或 TableInfo 工具时添加自定义字段，可以根据以下步骤进行操作： 1. 在您的数据库表中添加自定义字段，并在注释中添加相关信息，例如： ```sql ALTER TABLE `table_name` ADD `...
mybatis plus error: can not find TableInfo from Class
10-11
MyBatis Plus遇到"can not find TableInfo from Class"错误通常是由于你尝试操作的实体类（Class）未正确地映射到数据库表。TableInfo是MyBatis Plus为了自动管理数据访问而维护的，它关联了Java类和数据库表之间的...
// 初始化，在应用启动后调用 public static void init() { // 获取所有已经解析的TableInfo（MybatisPlus启动时会自动解析） for (TableInfo tableInfo : TableInfoHelper.getTableInfos()) { String tableName = tableInfo.getTableName(); // 判断该实体类是否有tenantId属性 boolean hasTenantField = tableInfo.getFieldList().stream() .anyMatch(field -> "tenant_id".equalsIgnoreCase(field.getColumn())); tableHasTenantFieldMap.put(tableName, hasTenantField); } System.out.println(tableHasTenantFieldMap); } public static boolean hasTenantField(String tableName) { // 如果表名在映射中，返回结果；否则，默认返回false（或者根据需求，可以认为没有租户字段） return tableHasTenantFieldMap.getOrDefault(tableName, false); }这个是什么时候有，什么时候没有，根据哪个类决定
08-23
for (TableInfo tableInfo : TableInfoHelper.getTableInfos()) { // 检查字段列表中是否存在列名为tenant_id的字段 boolean hasTenantField = tableInfo.getFieldList().stream() .anyMatch(field -> "tenant...
Java中Table的应用
weixin_34194359的博客
09-13 699
<span style="font-size:14px;">import java.util.Vector; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.tab...
Scripts:报告数据库中表信息汇总dba_table_info.sql
elvis的Oracle Lab
05-27 783
-- +----------------------------------------------------------------------------+ -- |                          Jeffrey M. Hunter                                 | -- |                      jhunter@
Oracle中tablesinfo_Oracle对表的操作
weixin_31710835的博客
12-31 221
/*1.Oracle ORCL Vss Writer Service。Oracle卷映射拷贝写入服务，VSS(Volume Shadow Copy Service)能够让存储基础设备(比如磁盘，阵列等)创建高保真的时间点映像，即映射拷贝 (shadow copy)。它可以在多卷或者单个卷上创建映射拷贝，同时不会影响到系统的系统能。2.OracleDBConsoleorcl。Oracle数据库控制台...
Oracle中tablesinfo_Oracle中建表及表操作
weixin_29865183的博客
12-23 394
一、创建表Oracle中的建表语句：create table 表名(字段名1 数据类型 列属性,字段名2 数据类型 列属性,......)-- Create tablecreate table OA_DM.DM_GY_USER(user_id CHAR(32),username VARCHAR2(100) not null,loginname VARCHAR2(50) not null,passw...
将List中所有tableInfo数据提交到数据库中
weixin_30505751的博客
06-03 203
public static bool TableSubmit(List<tableInfo> tableList) { bool bolResult = false; using (SQLiteConnection connection = new SQLiteConnection(DbHelperSQL.connectionS...
mybatis-plus框架TABLE_INFO_CACHE获取不到对应的TableInfo对象
weixin_44822312的博客
12-09 8538
mybatis-plus框架TABLE_INFO_CACHE获取不到对应的TableInfo对象
java table_Java中Table的应用
weixin_32179097的博客
02-12 575
import java.util.Vector;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableCellRenderer;import javax.swin...
Oracle中tablesinfo_oracle 表碎片整理
weixin_33478575的博客
12-31 214
又是一年双11，双十一对从事电商的it人员来说是一场噩梦，这个只是前奏，下面说重点：表碎片整理,首先收集那些表需要做碎片整理：1.1根据统计信息检查表碎片：SELECT table_name,ROUND ( (blocks 8), 2) "高水位空间 k",ROUND ( (num_rows avg_row_len / 1024), 2) "真实使用空间 k",ROUND ( (blocks 10...
mybatisPlus
weixin_45388014的博客
09-02 197
mybatisplus
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值