`
文章列表

mysql 分组排序

    博客分类:
  • sql
select r.* from ( select if(@pdept=h.postdate,@rank:=@rank+1,@rank:=1) as rank,@pdept:=h.postdate,h.*from ( select t.* from tbl_summary_report t order by postdate asc ,registusers desc) h ,(select  @pdept := null ,@rank:=0) a ) r ;
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springf ...
CREATE DEFINER = `swc`@`%` PROCEDURE `NewProc`(i_begindate date,i_enddate date,i_channelid SMALLINT,i_platid TINYINT,i_page INT,i_rows INT,out o_rows_total INT)    COMMENT '获取收入信息'BEGIN     DECLARE i_begin_row INT DEFAULT 0;     SET i_begin_row = (i_page - 1) * i_rows;    ...
当前日期前三天 function myformatter1(date){           date.setDate(date.getDate() -3);            var y = date.getFullYear();            var m = date.getMonth()+1;            var d = date.getDate();            return y+'-'+(m<10?('0'+m):m)+'-'+(d<10?('0'+d):d);        }   $("#startDate") ...

java常用语句

    博客分类:
  • java
//str=[a,b,c] 判断是否包含元素 Arrays.asList(str).contains("a")   ------------------------------------------------------------------------ //str2=a|b|c 字符串分隔 str2.split("\\|")[0]   ------------------------------------------------------------------------- //jsonArray 数组  JSONArr ...

dom4j 解析xml字符串

    博客分类:
  • xml
  /** *path xml字符串 *ndename 节点名称 */ public static Node analytic(String path, String nodeName) {  Document doc = null;  try {   doc = DocumentHelper.parseText(path);  } catch (DocumentException e) {      e.printStackTrace();  }  XPath xpathSelector = DocumentHelper.createXPath(nodeName);  Node ...
@ExceptionHandler(Exception.class)       public void handleException(Exception ex) {                      ex.printStackTrace();    } 
<mvc:resources location="/config/"  mapping="/config/**" />
<bean class ="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" >             <property name="messageConverters">                        <list>                           <ref bean="mappingJacksonHttpMessageConverter" /> ...
$('#del_type').bind("change", function(){      if($("#del_type").find("option").length>2){       $("#del_type").find("option").eq(0).remove();      }       $("#del_file").find("option[value!='']").remove();          var type = ...

dom4j 解析xml

    博客分类:
  • xml
import java.io.*;import java.util.List; import org.dom4j.*;import org.dom4j.io.*; public class DomXML {  public static String xmlPath;  public static void deleteNode(String express) throws DocumentException,   IOException {  // 找到结点并删除  SAXReader reader = new SAXReader();  Document document = r ...
div:     <div class="modal fade" id="processModal" data-keyboard="false"  data-backdrop="static" tabindex="-1" role="dialog"  aria-labelledby="processModalLabel" aria-hidden="true" style="font-family: 微软雅黑;&quo ...

jquery validate 校验

 $("#formTOAdd").validate({     focusCleanup:true,    errorPlacement : function(error, element) {           error.appendTo(element.parent().parent());     } ,     rules: {      type:{       required:true,      },      memo:{       required:true,       maxlength:500      },      fileName: ...

nginx 代理配置

worker_processes  1; events {    worker_connections  1024;} http {    include       mime.types;    default_type  application/octet-stream;     sendfile        on;    keepalive_timeout  65;     upstream backend {       server localhost:8080;       s ...

json过滤删除

    博客分类:
  • json
var rows=data.result.rows;    $.each(rows, function(i, item){      if(item.value==6){         delete rows[i];         rows.length--;     }     });     return rows;
Global site tag (gtag.js) - Google Analytics