1. Add the Query button on the DataGrid to further filter the data listed by the DataGrid.
Events triggered by the query button:
// Get Filtered data values var colnamesearch = $ (' #colNameSearch '). Val (); // methods for calling the DataGrid $ (' #communityManage '). DataGrid (' Load ', {colname:colnamesearch // parameter });
2. Format the date, see on the internet, feel good, put it here in case you forget:
/** Add a formatdate for date to format dates * * YYYY * MM months * dd days * hh hours * mm minutes * ss seconds * QQ Quarter * S milliseconds * * format:yyyy-* * Cnfengqinag 2015-04-07*/Date.prototype.formatDate=function(format) {varo = { "m+": This. GetMonth () + 1,//Month"D+": This. GetDate (),// Day"H +": This. GetHours (),//Hour"m+": This. getminutes (),//minute"S+": This. getseconds (),//Second"q+": Math.floor (( This. GetMonth () + 3)/3),//Quarter"S": This. Getmilliseconds ()//Millisecond }; if(/(y+)/.test (format)) format = Format.replace (regexp.$1, ( This. getFullYear () + ""). substr (4-regexp.$1. length)); for(varKinchOif(NewRegExp ("(" + K + ")"). Test (format)) format= Format.replace (regexp.$1, regexp.$1.length = = 1?O[k]: ("XX" + o[k]). substr ("" +O[k]) (length)); returnformat;};
For a date that is marked with milliseconds, you can convert to a time object as follows:
var New Date (value);
3. Errors found, the type of datatime in the database corresponds to the types in Java that are Java.sql.Timestamp,
Today's colleague uses date correspondence, which is wrong in the save date times.
Work notes (i)