Mybatis generator

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
  <classPathEntry location="D:\eclipse_selfservice\WorkStation\Selfservice\src\main\resources\ojdbc14.jar" />
  <context id="context1">
    <jdbcConnection connectionURL="jdbc:oracle:thin:@???1521:misdb" driverClass="oracle.jdbc.driver.OracleDriver" password="????" userId="???" />
    <javaModelGenerator targetPackage="com.fet.Selfservice.model" targetProject="D:\eclipse_selfservice\WorkStation\Selfservice\src\main\java" />
    <sqlMapGenerator targetPackage="com.fet.Selfservice.map" targetProject="D:\eclipse_selfservice\WorkStation\Selfservice\src\main\java" />
    <javaClientGenerator targetPackage="com.fet.Selfservice.dao" targetProject="D:\eclipse_selfservice\WorkStation\Selfservice\src\main\java" type="XMLMAPPER" />
    <table schema="seedsp" tableName="customer">
      <!-- <columnOverride column="???" property="???" /> -->
    </table>
  </context>
</generatorConfiguration>

D:\eclipse_selfservice\WorkStation\Selfservice
λ java -jar C:\Users\yewchen\.m2\repository\org\mybatis\generator\mybatis-generator-core\1.3.5\mybatis-generator-core-1.3.5.jar -configfile D:\eclipse_selfservice\Work Station\Selfservice\src\main\resources\generatorConfig.xml -overwrite
MyBatis Generator finished successfully.

Read More

[Eclipse] eclipse deploy web application到哪去了~

通常都在
workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps

可以參考 :
https://www.mkyong.com/eclipse/where-is-eclipse-deploy-web-application-tomcat/

Read More

[Oracle][SQL] 搜尋月份區間的簡易方法

/* 每個設備的單月加總 */
SELECT TO_CHAR(METERDATE, 'yyyy/mm'), SUM(METER) FROM WATERMETER
WHERE USERNO = 'F9605018'
AND EXTRACT( MONTH FROM METERDATE ) IN ( 5,4,3,2 )
AND EXTRACT( YEAR FROM METERDATE ) IN ( 2017 )
AND DEVICE = 'drinking'
GROUP BY TO_CHAR(METERDATE, 'yyyy/mm')
ORDER BY 1;


/* 用戶單月平均值 */
SELECT * FROM WATERMETER
WHERE userno = 'F9605018'
AND EXTRACT( MONTH FROM METERDATE ) IN ( 5 )
AND EXTRACT( YEAR FROM METERDATE ) IN ( 2017 );

SELECT * FROM WATERMETER
WHERE userno = 'F9605018'
AND EXTRACT( MONTH FROM METERDATE ) IN ( 3, 4, 5 )
AND EXTRACT( YEAR FROM METERDATE ) IN ( 2017 )
ORDER BY METERDATE;

Read More

[CSS]讓DIV永遠在某處

#Div0 {
    position: fixed;
    top: 0;
    left: 0;
    width: 100%;
    height: 53px;
    z-index: 10000;
    background-color: white;
}                              
#Div1 {  
    position: fixed;
    top: 53px;
    left: 0;
    z-index: 10000;
    background-color: white;

}
#Div2 {
    position: relative;
    top: 53px;
}  

http://blog.webgolds.com/view/304

Read More

[Maven Dependency] 使用本機端lib方法

真簡單，但是我找好久(廢)

<dependency>
<groupId>com.ericsson.services</groupId>
<artifactId>mms.sdk.vasp.api</artifactId>
<version>1.0</version>
<scope>system</scope>
<systemPath>${project.basedir}/src/main/resources/lib/MM7/vasp.jar </systemPath>
</dependency>

Read More

[maven] proxy擋住mvn install問題

[ERROR] Failed to execute goal on project...
PKIX path building failed:
time out ...


這東西就算我去maven/conf/setting.xml
裡面加入了proxy auth的設定還是依然無解

http://stackoverflow.com/questions/25911623/problems-using-maven-and-ssl-behind-proxy

最後找出的解決辦法就是匯入https://repo.maven.apache.org/ 的金鑰囉

1. 到https://repo.maven.apache.org/
2. 右鍵內容>憑證>詳細資料>把金鑰用Base 64 X.509 (.CER)的方式存到你的電腦裡面
3. 開啟command line, 生成key sotre
   keytool -import -file C:\temp\mavenCert.cer -keystore C:\temp\mavenKeystore
4.之後就可以增加參考此keysotre的paramter了

• Now you can run the command again with the parameter
  -Djavax.net.ssl.trustStore=C:\temp\mavenKeystore
• Under linux use absolute path
  -Djavax.net.ssl.trustStore=/tmp/mavenKeystore

例如我在執行mvn clean install的時候我就直接執行
mvn clean install -Djavax.net.ssl.trustStore=C:\temp\mavenKeystore


終於不用再走偏方繞出公司內網vpn了
真的是有夠麻煩

Read More

[Maven Dependency] 當repo上沒有.jar的手動安裝方法

這幾天用到JDBC
在import的時候compiler一直跳出找不到class的錯誤

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

仔細查了一下發現是缺了classes12.jar這東西
(這邊先穿插一下,  ojdbc14.jar 也是適用於這篇的解決方法)
於是我上了 http://mvnrepository.com/artifact/com.oracle/classes12/10.2.0.2.0
找到Maven dependency把他加到我project底下的pom.xml

然後mvn install

然後玄了

mvn跳出無法下載這個artifact的錯誤訊息

於是我直接去repo看 http://repo1.maven.org/maven2/com/oracle/classes12/10.2.0.2.0/

挖哩勒 裡面還真的是空空如也

There is no such artifact in maven central repository:
http://repo1.maven.org/maven2/com/oracle/ojdbc14/10.2.0.4.0 (only pom).
I guess due to some licensing issues you must download the file manually from JDBC, SQLJ, Oracle JPublisher and Universal Connection Pool (UCP) download page.

看起來是甲骨文耍傲嬌的意思？！

=======================解決辦法分隔線=========================

所以就先到oracle手動下載classes12.jar 或 ojdbc14.jar 吧

連結在這不洩了  http://www.oracle.com/technetwork/apps-tech/jdbc-10201-088211.html

下載好以後, 有兩個建議做法, 建議一是不建議的建議做法; 建議二是建議的建議做法

建議一 : 

隨便找個地方放好你剛下載好的classes12.jar或ojdbc14.jar

然後在eclipse的project右鍵選Build Path然後Add External JARs..

為什麼不建議呢, 因為這樣你要自己管理好這個jar...

要是你哪天心情不好看他不爽把它砍了, 你就會又要google然後找到這篇文章再看一次了

(不過這樣提高我的blog的曝光度好像其實對我而言是建議做法)

建議二 : 

把你下載好的classes12.jar或ojdbc14.jar隨便放在一個地方, 我這邊就舉例放在D:/

(然後我假定你已經有設定好mvn的環境變數了)

(蛤你沒設好??!!)

M2_HOME : C:\Program Files\apache-maven-3.3.9 

PATH : %M2_HOME%\bin

(不洩了)

然後打開命令提示位元(cmd), 輸入

D:>mvn install:install-file -Dfile=classes12.jar -DgroupId=com.oracle -DartifactId=classes12 -Dversion=10.2.0.2.0 -Dpackaging=jar

如果是ojdbc14就

D:>mvn install:install-file -Dfile=ojdbc14.jar -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=10.2.0.4.0 -Dpackaging=jar

然後系統就會手動安裝啦~灑花~

安裝完以後就可以去你的local的maven repo裡面查看看他到底有沒有安裝成功

C:\Users\名子兒\.m2\repository\com\oracle

最後你就可以用你的pom.xml新增這個dependency來管理啦~

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>classes12</artifactId>
    <version>10.2.0.2.0</version>
</dependency>

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc14</artifactId>
    <version>10.2.0.4.0</version>
</dependency>

Read More