mysql按月分组并补齐 selecta.month,fromselectunionselectunionselectunionselectunionselectunionselectunionselectunionselectunionselectunionselectunionselectunionselect) aselectfromonwhere。
java 两个不同list<map> 取差集 并相互补全 public static BatchMetric list(BatchMetric metric, List<Map<Object,Object>> list1, List<Map<Object,Object>> list2){ System.out.println("#---------前"+list1); System.out.println("#---------前"+list2); Map<Ob.
java8List集合根据对象的属性去重 @RequiresPermissions("system:statistical:list") @PostMapping("/list") @ResponseBody public TableDataInfo list(AttPrimary attPrimary) { List rs = new ArrayList(); Map mapRs = HkApiPerson.getOrgListByParent("root000000","1...
java8多个list对象用lambda求差集 @RequiresPermissions("system:statistical:list")@PostMapping("/getStuListNotClockIn/{orgIndexCode}/{accessTime}")@ResponseBodypublic TableDataInfo getStuListNotClockIn(@PathVariable String orgIndexCode,@PathVariable String accessTime){ AttPrimary a.
JSONObject转换成需要的对象类型 { "name": "小名", "age":19 "subTradeList": [ { "balance": "2083.63", "money": "0.01", "tradeDesc": "工资", "tradeTime": "2018-12-07 11:51:01", "tradeType": "1", "queryT...
mysql 按时间分组统计 /*** 每小时统计*/SELECT a.hour hour, ifnull(b.count, 0) count FROM (SELECT 0 hour UNION ALL SELECT 1 hour UNION ALL SELECT 2 hour UNION ALL SELECT 3 hour UNION ALL SELECT 4 hour UNION ALL SELECT 5 hour UNION ALL SELECT 6 hour UNION ALL SELECT 7 hour UNION..
java excel导出 package com.ruoyi.primary.utils;import cn.hutool.core.collection.CollUtil;import java.io.IOException;import java.io.OutputStreamWriter;import java.io.PrintWriter;import java.lang.reflect.Field...
xmlHelper package com.gszcn.gsrssj.utils;import net.sf.json.JSONObject;import org.dom4j.Document;import org.dom4j.DocumentHelper;import org.dom4j.Element;import java.util.*;public class XMLHelper { ...
java httpclient byxml json package com.gszcn.gsrssj.utils;import java.io.IOException;import java.net.URI;import java.security.KeyManagementException;import java.security.KeyStoreException;import java.security.NoSuchAlgor...
java excel 导出简单封装 package com.liyankun.api.utils;import cn.hutool.core.collection.CollUtil;import cn.hutool.core.date.DateUtil;import cn.hutool.core.util.RandomUtil;import cn.hutool.poi.excel.BigExcelWriter;impor...
nodejs mysql 操作 const db = require('../config/db')let show = (table) => { return new Promise((resolve, reject) => { db.query(`select * from ${table}`, (err, rows) => { if (err) { ...
golang struct 转 json package mainimport ( "fmt" "reflect" "time")type Persion struct { Id int Name string}func StructToMapViaReflect() { m := make(map[interface{}]interface{}) t := time.Now() person ...
golang 导出excel封装2 func ExcelExportData360(db *gorm.DB, config config.Config, header []interface{}, data [][]interface{}, sheetName string) string { timeStr := time.Now().Format("2006-01-02 15:04:05") f := excelize....
Golang excel 封装导出功能 package myutilsimport ( "feinail/of_capital/config" "fmt" "github.com/jinzhu/gorm" "github.com/tealeg/xlsx" "strconv" "time")func ExcelExportData(db *gorm.DB, config config.Config, header ...
golang json 配置文件 //config.go:package configimport ( "reflect")type Config struct { Values map[string]interface{}}func New(fileName string) *Config { return NewJson(fileName, nil)}func config() *...
golang excel 导出功能 package myutilsimport ( "feinail/app/config" "github.com/jinzhu/gorm" "github.com/tealeg/xlsx" "strconv" "time")func ExcelExportData(db *gorm.DB, config config.Config, header []st...
golang gorm 自定义 json,time.Time 格式 package utilsimport ( "bytes" "errors" "database/sql/driver")//自定义json类型type JSON []bytefunc (j JSON) Value() (driver.Value, error) { if j.IsNull() { return nil, nil } return string(...
python 级别联动实现 from utils.httputil import Httpfrom utils.dbQry import MyDbUtilhttp = Http()mydb = MyDbUtil()def query_interface(): list = mydb.select_some("systems", "switch", 1) nodes = mydb.select_...
python3 pymysql 常用操做封装 import pymysqlfrom config import DB_CONFIGclass MyDbUtil(object): def __init__(self): self._conn = pymysql.connect(host=DB_CONFIG[0].get("master")["host"], ...
deepin/ubuntu 系统 安装rtl8821ce 无线驱动 git clonehttps://github.com/tomaspinho/rtl8821cecd rtl8821cemakesudo make installsudo modprobe -a 8821ce