- 博客(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
185
原创 小段数据库代码
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
161
原创 通信基站和通信技术机房
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
736
原创 KAK
List queryIDCFilterListPage(PageBean page); select id="queryIDCFilterListPage" parameterType="PageBean" resultType="RptCapMachroom"> /*合计能耗*/SELECT tmp.*, = tmp.pue and tmp
2018-02-02 11:29:00
210
原创 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
492
原创 我的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
144
原创 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
277
原创 两表拼接
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
385
原创 我的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
1728
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
570
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
443
原创 查看衔接
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
282
原创 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
153
原创 自己的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
108
原创 我的一个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
130
原创 找错误
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
634
原创 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
797
原创 最近的一次跑错地方的
### 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
328
原创 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
177
原创 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
333
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人