- 博客(24)
- 收藏
- 关注
原创 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
199
原创 小段数据库代码
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
170
原创 通信基站和通信技术机房
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
764
原创 KAK
List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp
2018-02-02 11:29:00
219
原创 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
525
原创 我的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
149
原创 我写的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
153
原创 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
288
原创 两表拼接
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
407
原创 我的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
1752
2
原创 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
578
1
原创 正确的
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
507
原创 查看衔接
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
294
原创 keytool的学习
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
172
原创 自己的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
117
原创 我的一个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
139
原创 找错误
Last login: Fri Dec 29 11:03:40 on consoleyunqiangs-MacBook-Pro:~ yunqiang$ cd Epcossyunqiangs-MacBook-Pro:Epcoss yunqiang$ lsEpcoss.iml pom.xml src targetyunqiangs-MacBook-Pr
2017-12-29 13:35:12
695
原创 pom.xml 错误
Could not transfer artifact org.apache.maven:maven-plugin-parameter-documenter:jar:2.0.6 from/to central (https://repo.maven.apache.org/maven2): /Users/yunqiang/workspace/maven/repository/org/apache/m
2017-12-27 13:47:41
889
原创 最近的一次跑错地方的
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 's.s_email' in 'field list'### The error may exist in file [/Users/yunqiang/Documents/a
2017-12-26 09:26:24
371
原创 mysql 成功 运行。
2017-12-25 14:19:28,905 INFO [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] - Mapped "{[/BusApplyrecordWithcontractmainAction_deleteData.do],methods=[],params=[],
2017-12-25 14:20:42
195
原创 intellij 看 依赖 冲突
[INFO] workflow:workflow:war:1.0-SNAPSHOT[INFO] +- junit:junit:jar:3.8.1:test[INFO] +- com.oracle:ojdbc14:jar:10.2.0.1.0:compile[INFO] +- javax.servlet:servlet-api:jar:2.5:compile[INFO] +- jav
2017-12-22 22:14:49
351
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人