- 博客(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
243
原创 小段数据库代码
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
193
原创 通信基站和通信技术机房
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
864
原创 KAK
List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp
2018-02-02 11:29:00
243
原创 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
560
原创 我的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
172
原创 我写的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
176
原创 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
432
原创 我的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
1807
原创 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
608
原创 正确的
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
571
原创 查看衔接
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
387
原创 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
193
原创 自己的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
140
原创 我的一个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
854
原创 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
971
原创 最近的一次跑错地方的
### 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
471
原创 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
225
原创 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
380
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人