文章列表
求和：sum(decode(sign(xingji - 6),'',h.real_count,1,h.real_count,0))
decode相较于case when，函数里面不能使用and连接多个条件，只能使用函数嵌套
例如：sum(decode(sign(xingji - 6),-1,decode(hh.quxian,18,h.real_count,19,h.real_count,20,h.real_count,24,h.real_count,34,h.real_count,35,h.real_count,0),0))
求和：sum(case when start_time = '24' ...
/**
* 将低位二进制存储转换为高位存储，并返回相应的数字
* @param b
* @return
* @author lxzqz
*/
public int convertBinary(byte[] b) {
for (int i = 0; i < b.length/2; i++) {
if(i == 0) {
byte bb = b[0];
b[0] = b[3];
b[3] = bb;
}
if(i == 1) {
byte bb = b[1];
b[1] = b[2];
b[2] = b ...
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv=&q ...
(function ($) {
HashMap = function () {
var index = 0;
var content = '';
var keyV = new Array();
var valueV = new Array();
//向map中添加key，value键值对
this.put = function (key,value) {
if(key == undefined || key.Trim == '') {
return;
...