摘要:
1.Startup.ConfigureServices services.AddHttpClient(); 2.构造函数注入 private readonly IHttpClientFactory _clientFactory; public XXX(IHttpClientFactory clien 阅读全文
摘要:
背景: 参数没有通过校验模型检查时,直接返回错误信息,但是这个错误信息可读性很弱,并不能被前端很方便的使用 { "type": "https://xxx", "title": "One or more validation errors occurred.", "status": 400, "tra 阅读全文
摘要:
1.Nuget install-package Quartz.Extensions.Hosting 2.添加文件:WhileJob /// <summary> /// while quartz job /// </summary> [DisallowConcurrentExecution] publ 阅读全文
摘要:
异常:Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.org.gjt.mm.mysql.Driver Link1:https 阅读全文
摘要:
Sql SELECT ITEM_DATE, TO_CHAR(ITEM_DATE, 'YYYY-MM-DD') CURRENT_DATE_STR, CURRENT_YEAR, CASE TO_CHAR(ITEM_DATE, 'MM') WHEN '01' THEN 'JAN' WHEN '02' TH 阅读全文
摘要:
选择指定tab: 1.ExcelRowIndex:为该行在源excel中的行索引 2.RowIndex:为读取数据时新集合中的行索引 ExcelRowIndex 和 RowIndex 并不相等 Reference: Kettle 连接 Oracle 使用手册 及 问题解决方案 Kettle 读取Ex 阅读全文
摘要:
简单删除 DELETE TABLE_NAME WHERE KEY = 1; DELETE TABLE_NAME WHERE KEY IN (1, 2, 3); DELETE TABLE_NAME WHERE KEY IN (SELECT 1 FROM DUAL); 多条件删除 1.EXISTS DE 阅读全文
摘要:
查询所有表对应的数据量 1.GROUP SELECT A.NAME AS 表名, MAX(B.ROWS) AS 记录条数 FROM SYS.SYSOBJECTS AS A INNER JOIN SYS.SYSINDEXES AS B ON A.ID = B.ID AND (A.XTYPE = 'U' 阅读全文
摘要:
固定表头 <el-table-column label="姓名\N张三" header-align="center" // 设置列表表头居中 :render-header="renderHeader" > </el-table-column> 多语言表头对象 { table: { Name: '姓名 阅读全文
摘要:
导入命名空间 using System.Data.SqlClient; 代码 var sqlBuilder = new StringBuilder("SELECT SUM(TOTAL) AS TOTAL FROM ("); sqlBuilder.Append(" SELECT COUNT(1) AS 阅读全文