wyqiang-CSDN博客

原创 Oauth2

-- used in tests that use HSQL create table oauth_client_details ( client_id VARCHAR(256) PRIMARY KEY, resource_ids VARCHAR(256), client_secret VARCHAR(256), scope VARCHAR(256), authorized...

2018-12-23 18:41:27 264

原创小段数据库代码

SELECT pot.metering_person,pot.metering_date,MAX(decode(pot.metering_type, 1, pot.col )) AS watch_metering, MAX(decode(pot.metering_type, 2, pot.col)) AS evulate_metering, MAX(decode(pot.meteri...

2018-09-27 17:41:57 204

原创通信基站和通信技术机房

SELECT nowtime.EC_CITY_NAME as EC_CITY_NAME, nowtime.EC_ITEM_TIME as EC_ITEM_TIME, nowtime.EC_ARENA_NAME as EC_ARENA_NAME, nowtime.TOTAL_USAGE as NOW_TOTAL_USAGE,

2018-02-04 20:51:57 894

原创 KAK

List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp

2018-02-02 11:29:00 255

原创 DateHelper

package com.crowdcrystal.model;import java.io.Serializable;import java.util.Date;import java.util.List;import java.util.Map;import java.text.ParseException;import java.text.SimpleDateFormat;im

2018-02-02 11:27:51 577

原创我的SQL

SELECT nowtime.EC_CITY_NAME as EC_CITY_NAME, nowtime.EC_ITEM_TIME as EC_ITEM_TIME,nowtime.EC_ARENA_NAME as EC_ARENA_NAME, nowtime.TOTAL_USAGE as NOW_TOTAL_USAGE, nowtime.AIRCON_USA

2018-02-01 19:47:14 186

原创我写的SQL

SELECT (CASE WHEN tabl.t1 is not null then tabl.t1 WHEN tabl.t2 is not null then tabl.t2 WHEN tabl.t3 is not null then tabl.t3 WHEN tabl.t4 is not null then tabl.t4

2018-02-01 16:03:54 184

原创 SQL 年月

SELECT b.EC_CITY_NAME, b.EC_ITEM_TIME, SUM(b.TOTAL_USAGE), SUM(b.AIRCON_USAGE),SUM(b.MAIN_USAGE), SUM(GENERATOR_USAGE) FROM (SELECT sr.NAME as EC_CITY_NAME,

2018-02-01 15:15:42 327

原创两表拼接

SELECT sr.NAME, rcs.READTIME, rb.BTSNAME, SUM(rcs.TOTAL_USAGE) totalusage, TO_CHAR(SUM(rcs.AIRCON_USAGE),'0999.99') airconusage, SUM(rcs.MAIN_USAGE) mainusage, SUM(rcs.GENERATOR_USAGE)

2018-01-30 15:04:35 448

原创我的信息

/alidata/server/emsp_static8099http://120.76.220.115:8099

2018-01-06 13:51:25 207

原创我的keytool

[root@localhost bin]# keytool -genkey -alias zljh -keypass talent -keyalg RSA -keysize 1024 -validity 3650 -keystore /home/certificates/zljh.keystore -storepass talentWhat is your first and last na

2018-01-04 08:53:47 1843

原创 2018 年数据证书的生成

keytool -genkey -alias zljh -keypass talent -keyalg RSA -keysize 1024 -validity 3650 -keystore /home/certificates/zljh.keystore -storepass talentkeytool -genkey -alias client1 -keypass 123456

2018-01-03 20:27:30 622

原创正确的

yunqiangs-MacBook-Pro:bin yunqiang$ tail -f ../logs/catalina.out02-Jan-2018 17:25:55.897 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8088"]02-Jan-2018

2018-01-02 17:27:16 589

原创查看衔接

02-Jan-2018 17:11:35.239 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["ajp-nio-8009"]02-Jan-2018 17:11:45.971 WARNING [main] org.apache.tomcat.util.digester.Set

2018-01-02 17:13:51 410

keytool -genkey -alias zljh -keypass talent -keyalg RSA -keysize 1024 -validity 1461 -keystore /home/certifcates/zljh.keystore -storepass talentkeytool -genkey -alias client1 -keypass 123456 -keyalg R

2018-01-02 16:00:33 209

原创登陆公司服务器

ssh [email protected]

2018-01-02 15:17:40 1253

原创自己的pom

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 4.0.0 e

2018-01-02 08:56:53 147

原创我的一个pom

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 4.0.0 e

2017-12-29 19:35:23 167

wyqiang的专栏