- 博客(24)
- 收藏
- 关注
RSS订阅原创 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
240
原创 小段数据库代码
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
188
原创 通信基站和通信技术机房
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
855
原创 KAK
List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp
2018-02-02 11:29:00
241
原创 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
557
原创 我的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
169
原创 我写的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
174
原创 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
315
原创 两表拼接
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
429
原创 我的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
1803
原创 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
604
原创 正确的
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
568
原创 查看衔接
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
383
原创 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
191
原创 自己的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
138
原创 我的一个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
156
原创 找错误
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
840
原创 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
960
原创 最近的一次跑错地方的
### 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
461
原创 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
221
原创 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
378
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人