- 浏览: 36007 次
- 性别:
最新评论
文章列表
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 ;
mybatis 多数据源配置
- 博客分类:
- mybatis sql
<?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 ...
mybatis 存储过程
- 博客分类:
- mybatis sql
- java
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;
...
easyui 日期控件格式化
- 博客分类:
- easyui
当前日期前三天
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") ...
//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 ...
sping mvc打印错误信息
- 博客分类:
- springMVC
@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" /> ...
jquery 动态添加下拉框选项
- 博客分类:
- jquery
$('#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 ...
bootstrap 文件上传进度条
- 博客分类:
- bootstrap
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 校验
- 博客分类:
- jquery
$("#formTOAdd").validate({ focusCleanup:true, errorPlacement : function(error, element) { error.appendTo(element.parent().parent()); } , rules: { type:{ required:true, }, memo:{ required:true, maxlength:500 }, fileName: ...
nginx 代理配置
- 博客分类:
- 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 ...
var rows=data.result.rows; $.each(rows, function(i, item){ if(item.value==6){ delete rows[i]; rows.length--; } }); return rows;