- 博客(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 182
原创 小段数据库代码
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 156
原创 通信基站和通信技术机房
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 728
原创 KAK
List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp
2018-02-02 11:29:00 209
原创 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 483
原创 我的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 140
原创 我写的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 143
原创 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 276
原创 两表拼接
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 379
原创 我的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 1716 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 565 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 404
原创 查看衔接
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 277
原创 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 151
原创 自己的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 106
原创 我的一个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 129
原创 找错误
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 610
原创 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 759
原创 最近的一次跑错地方的
### 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 309
原创 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 173
原创 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 330
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人