beiqi的博客
beiqi · 共 31 篇文章
mysql 分组排序
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 ;
2015-09-21 18:36 · sql · 评论(0)
mybatis 多数据源配置
<?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.springframework.org/schema/tx " xmlns:jdbc=" http://www.springfra…
2015-09-15 17:08 · mybatis sql · 评论(0)
mybatis 存储过程
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; IF i_platid = 0 THEN SELECT postdate ,…
2015-09-15 16:51 · mybatis sql · java · 评论(0)
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").datebox("setValue", myformatter1(new Date()));
2015-09-15 16:50 · easyui · 评论(0)
java常用语句
//str=[a,b,c] 判断是否包含元素 Arrays.asList(str).contains("a") ------------------------------------------------------------------------ //str2=a|b|c 字符串分隔 str2.split(" \\|")[0 ] ------------------------------------------------------------------------- //jsonArray 数组 JSONArray jarray= JSONArray.fromObject(…
2015-07-22 10:40 · java · 评论(0)
dom4j 解析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 node = xpathSelector…
2015-05-14 16:58 · xml · 评论(0)
sping mvc打印错误信息
@ExceptionHandler(Exception.class) public void handleException(Exception ex) { ex.printStackTrace(); }
2015-05-14 15:40 · springMVC · 评论(0)
spirngMVC 不把读取文件当做action配置
<mvc:resources location="/config/" mapping="/config/**" />
2015-04-21 14:24 · springMVC · 评论(0)
spirngMVC 返回json 配置
<bean class ="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" > <property name="messageConverters"> <list> <ref bean="mappingJacksonHttpMessageConverter" /><!-- json转换器 --> </list> </property> </bean> <bean id="mappingJacksonHttpMessageConverter" class="org.springfram…
2015-04-21 14:22 · spingMVC JSON · 评论(0)
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 = $("#del_type").find("option:selected").val(); $.ajax ({ //请求登录处理页 url: ContextPath + "/File/imageList.a…
2015-04-02 11:33 · jquery · 评论(0)
dom4j 解析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 = reader.rea…
2015-04-02 11:29 · xml · 评论(0)
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: 微软雅黑;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <h4 class="mod…
2015-04-02 11:22 · bootstrap · 评论(0)
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: { required:true, length:true, size1:true, }, version: { required:true, maxlengt…
2015-04-02 11:15 · jquery · 评论(0)
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; server localhost:8081; # ip_hash; } server { listen 80; server_name 192.168.10.24; location / { root…
2015-04-02 09:26 · nginx · 评论(0)