表格数据导出Excel function download() { var fileName =new Date().Format("yyyyMMddhhmmss"); //$("#datagrid").datagrid("toExcel", fileName); let table = document.getElementById('datagrid'); console.log(table) console.log(table.getElementsByTagName("tr")) for(var i=0; i<table.getElementsByTagName("tr").length;i++) { var tr = table.getElementsByTagName("tr")[i]; var hiddenCell = []; for (var j=0; j<tr.getElementsByTagName("td").length;j++){ var td = tr.getElementsByTagName("td")[j]; if ("style" in td){ if (td.style.display=="none"){ hiddenCell.push(j); } } } var flag = 0; for (var k=0;k<hiddenCell.length;k++){ var index = hiddenCell[k]; tr.deleteCell(index-flag); flag++; } } let sheet = XLSX.utils.table_to_sheet(table);//将一个table对象转换成一个sheet对象 sheet['!cols']=[{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100}]; openDownloadDialog(sheet2blob(sheet), fileName+'.xlsx'); } //导出Excel // 将一个sheet转成最终的excel文件的blob对象，然后利用URL.createObjectURL下载 function sheet2blob(sheet, sheetName) { sheetName = sheetName || 'sheet1'; var workbook = { SheetNames: [sheetName], Sheets: {} }; workbook.Sheets[sheetName] = sheet; // 生成excel的配置项 var wopts = { bookType: 'xlsx', // 要生成的文件类型 bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性 type: 'binary' }; var wbout = XLSX.write(workbook, wopts); var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" }); // 字符串转ArrayBuffer function s2ab(s) { var buf = new ArrayBuffer(s.length); var view = new Uint8Array(buf); for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF; return buf; } return blob; } function openDownloadDialog(url, saveName) { if (typeof url == 'object' && url instanceof Blob) { url = URL.createObjectURL(url); // 创建blob地址 } var aLink = document.createElement('a'); aLink.href = url; aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效 var event; if (window.MouseEvent) event = new MouseEvent('click'); else { event = document.createEvent('MouseEvents'); event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null); } aLink.dispatchEvent(event); }

EasyUI 表格填充 $(function () { var url = projectName + '/pns/notice/getNotices'; var queryParams = {}; initDataGrid(url, queryParams); $('#notice').datagrid({singleSelect: (this.value == 1)}); }); function initDataGrid(url, queryParams) { $('#notice').datagrid({ method: 'post', url: url, queryParams: queryParams, nowrap: true, pagination: true, pageSize: 30, pageList: [10, 20, 30, 40, 50], fit: true, fitColumns: false, border: false, singleSelect: true, rownumbers: true, sortable: true, remoteSort: false, sortName: 'issueTime', sortOrder: 'desc', toolbar: [{ text: "发布通知", iconCls: 'icon-add', handler: add }, { text: "批量删除", iconCls: 'icon-no', handler: Delete }], frozenColumns: [[{ field: 'ck', checkbox: true, align: 'center', }, { field: 'ids', title: '序号', align: 'center', hidden: true, }, { title: '发布时间', field: 'issueTime', align: 'center', sortable: 'true', width: 220 }, { title: '发布内容', field: 'content', align: 'left', width: 320, formatter: function (value, row, index) { return '<span title=' + value + '>' + value + ''; } }, { title: '发布人', field: 'issueUser', align: 'left', width: 100 }, { field: 'opt', title: '操作选项', align: 'center', width: 100, formatter: function (value, row, index) { var handleHtml = ""; handleHtml += "<a href='javascript:void(0);' class='easyui-linkbutton' onclick='showNotice(" + row.id + ")'>查看详情</a>&nbsp;"; return handleHtml; } } ]], }); }

js向div中追加html代码 //这是直接插入html document.getElementById("div_id").innerHTML = "你想往div里插入的html代码"; //如果想追加，可以这样 //先保存div中原来的html var html = document.getElementById("div_id").innerHTML; //再跟你想追加的代码加到一起插入div中 document.getElementById("div_id").innerHTML = html + "你想往div里追加的html代码";

Mysql 时间查询 查询今天的数据SELECT * FROM t_date WHERE TO_DAYS(create_time) = TO_DAYS(NOW());查询某个月的数据SELECT * FROM t_date WHERE DATE_FORMAT(create_time, '%Y-%m')='2020-06';查询某年的数据SELECT * FROM t_date WHERE DATE_FORMAT(create_time, '%Y')= 2020;SELECT * FROM t_date WHERE YEAR(create_time) = 2020;根据日期区间查询数据,并排序SELECT * FROM t_date WHERE DATE_FORMAT(create_time, '%Y') BETWEEN '2018' AND '2020' ORDER BY create_time DESC;-- 昨天 select fullName,addedTime from t_user where to_days(NOW()) - TO_DAYS(addedTime) <= 1; -- 近7天 select fullName,addedTime from t_user where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(addedTime); -- 近30天 SELECT fullName,addedTime FROM t_user where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(addedTime);-- 本月 SELECT fullName,addedTime FROM t_user WHERE DATE_FORMAT( addedTime, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' );-- 上一月 SELECT fullName,addedTime FROM t_user WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( addedTime, '%Y%m' ) ) =1; -- 查询本季度数据 select fullName,addedTime FROM t_user where QUARTER(addedTime)=QUARTER(now()); -- 查询上季度数据 select fullName,addedTime FROM t_user where QUARTER(addedTime)=QUARTER(DATE_SUB(now(),interval 1 QUARTER)); -- 查询本年数据 select fullName,addedTime FROM t_user where YEAR(addedTime)=YEAR(NOW()); -- 查询上年数据 select fullName,addedTime FROM t_user where year(addedTime)=year(date_sub(now(),interval 1 year)); -- 查询距离当前现在6个月的数据 select fullName,addedTime FROM t_user where addedTime between date_sub(now(),interval 6 month) and now(); -- 查询当前这周的数据 SELECT fullName,addedTime FROM t_user WHERE YEARWEEK(date_format(addedTime,'%Y-%m-%d')) = YEARWEEK(now()); -- 查询上周的数据 SELECT fullName,addedTime FROM t_user WHERE YEARWEEK(date_format(addedTime,'%Y-%m-%d')) = YEARWEEK(now())-1; -- 查询上个月的数据 select fullName,addedTime FROM t_user where date_format(addedTime,'%Y-%m')=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y-%m'); -- 查询当前月份的数据select fullName,addedTime FROM t_user where DATE_FORMAT(addedTime,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m');select fullName,addedTime FROM t_user where date_format(addedTime,'%Y-%m')=date_format(now(),'%Y-%m'); -- 查询指定时间段的数据select fullName,addedTime FROM t_user where addedTime between '2017-1-1 00:00:00' and '2018-1-1 00:00:00'; select fullName,addedTime FROM t_user where addedTime >='2017-1-1 00:00:00' and addedTime < '2018-1-1 00:00:00';

数据库 常见指令 Structured Query Language sql行 字段 列 记录varchar char一个代表225改表结构 加 tablefrom 在select 之前执行创建库create database d_text; create database 表名;查看有多少库show databases;打开这个库use 库名;创建表 合里边的字段create table t_student (id int primary key AUTO_INCREMENT, username varchar(255) , pwd varchar(32) not null default '123456'); create table 表名 （字段名 属性(大小) 主键 , 字段名 属性(大小) 不为空 默认密码123456）；insert into t_score (realname , major, score) value ('libing','java','60') ,('xiaozhi','java','80') ,('aning','数学','59');查里边有里有多少表show tables;增 插入值insert into t_student(字段名1, 字段名2) value ('值1','值2'); insert into 表名 (字段名1, 字段名2) value ('值1','值2');查select * from 表名; select 字段 , 字段 from 表名;删 （and or !=）!= 不等于 <>delete from t_student where username = 'xx' and 1 = 1; delete from 表名 where 字段名 = 'xx' and 布尔表达式;删符合条件的**delete from t_student where username in ('xx','vv');** 删除除过这两个之外的两条delete from t_student where username not in ('xx','vv'); delete from 表名 where 字段名 not in ('值1','值2');模糊查询delete from t_student where username like '%l%'; delete from 表名 where 字段名 like '等于什么';模糊查询 前边delete from t_student where username like 'l%'; delete from 表名 where 字段名 like '等于什么';模糊查询 后边delete from t_student where username like '%l'; delete from 表名 where 字段名 like '等于什么';全部清空 表结构还在TRUNCATE TABLE table_name; TRUNCATE TABLE 表名;查表结构desc t_student; desc 表名;删除表 表结构都删除drop table t_student; drop table 表名;创建表 设置主键create table 表名(字段名称 类型 primary key（字段名称）);修改主键alter table t_student add primary key(username); alter table 表名 add primary key(字段);修改update t_student set pwd = '123456' where username = 'qq'; update 表名 set 字段 = 值1 where 字段 = 原本值; update t_student set pwd = '123456',username = 'xiaozhi' where username = 'qq'; update 表名 set 字段1 = 值1 ,字段2 = 值2 where 字段 = 原本值;;加一个字段 不建议使用alter table t_student add (gender varchar(10)); alter table 表名 add (字段 varchar(10));删除一行alter table t_student drop gender; alter table 表名 drop 字段;查询查询设置字段别名 as可以省略select username as '账号' from t_student; select 字段 as '别名' from 表名;查询设置表名别名select `s`.`username` as'账号' from t_student s; 展示 username 这个字段 并把这个表当做s查具有可比较性的 between 数字 两数之间select * from t_score where score between 50 and 70; select * from 表名 where 字段 between 50 and 70; 查前边两个值select * from t_score limit 0,2; select * from 表名 limit 0到第二个;排序升序select * from t_score order by score; select * from 表名 order by 字段;降序select * from t_score order by score desc; select * from 表名 order by 字段 desc;成绩查询 科目没有挂过科的人select realname from t_score where realname not in (select realname from t_score where score < 60);子查询加在from之后必须加别名 as temp；