Hibernate Find By Example

-
當TB_FD_USER裡面的PK=USER_NO時候
只有放PK到findByExample會被忽略喔...

eStoreService dao = (eStoreService)SpringService.getService(SpringService.USE_JDBC, "eStoreService");
TbFdUser user = new TbFdUser();
user.setUserNo(new Long(1));
Collection c = dao.getUserByExample(user);
System.out.println("result size:"+c.size());

Result...
Hibernate: select this_.USER_NO as USER1_4_0_, this_.ADDRESS as ADDRESS4_0_, this_.AREA_CODE as AREA3_4_0_, this_.BANK_ACCOUNT as BANK4_4_0_, this_.BIRTHDAY as BIRTHDAY4_0_, this_.CITY as CITY4_0_, this_.COMPANY_NAME as COMPANY7_4_0_, this_.COUNTRY_CODE as COUNTRY8_4_0_, this_.CREATE_BY as CREATE9_4_0_, this_.CREATE_DATE as CREATE10_4_0_, this_.EMAIL as EMAIL4_0_, this_.FAX_NO as FAX12_4_0_, this_.FLAG as FLAG4_0_, this_.ID_NO as ID14_4_0_, this_.INTRODUCED_BY as INTRODUCED15_4_0_, this_.LOGIN_ID as LOGIN16_4_0_, this_.LOGIN_PWD as LOGIN17_4_0_, this_.MOBILE_NO as MOBILE18_4_0_, this_.PROVINCE_CODE as PROVINCE19_4_0_, this_.SEX as SEX4_0_, this_.STATUS as STATUS4_0_, this_.TEL_NO as TEL22_4_0_, this_.TITLE as TITLE4_0_, this_.UPDATE_BY as UPDATE24_4_0_, this_.UPDATE_DATE as UPDATE25_4_0_, this_.USER_NAME as USER26_4_0_, this_.USER_TYPE as USER27_4_0_ from tb_fd_user this_ where (1=1)
result size:3


eStoreService dao = (eStoreService)SpringService.getService(SpringService.USE_JDBC, "eStoreService");
TbFdUser user = new TbFdUser();
user.setUserNo(new Long(1));
user.setEmail("xxx@ooo.com");
Collection c = dao.getUserByExample(user);
System.out.println("result size:"+c.size());

Result...
Hibernate: select this_.USER_NO as USER1_4_0_, this_.ADDRESS as ADDRESS4_0_, this_.AREA_CODE as AREA3_4_0_, this_.BANK_ACCOUNT as BANK4_4_0_, this_.BIRTHDAY as BIRTHDAY4_0_, this_.CITY as CITY4_0_, this_.COMPANY_NAME as COMPANY7_4_0_, this_.COUNTRY_CODE as COUNTRY8_4_0_, this_.CREATE_BY as CREATE9_4_0_, this_.CREATE_DATE as CREATE10_4_0_, this_.EMAIL as EMAIL4_0_, this_.FAX_NO as FAX12_4_0_, this_.FLAG as FLAG4_0_, this_.ID_NO as ID14_4_0_, this_.INTRODUCED_BY as INTRODUCED15_4_0_, this_.LOGIN_ID as LOGIN16_4_0_, this_.LOGIN_PWD as LOGIN17_4_0_, this_.MOBILE_NO as MOBILE18_4_0_, this_.PROVINCE_CODE as PROVINCE19_4_0_, this_.SEX as SEX4_0_, this_.STATUS as STATUS4_0_, this_.TEL_NO as TEL22_4_0_, this_.TITLE as TITLE4_0_, this_.UPDATE_BY as UPDATE24_4_0_, this_.UPDATE_DATE as UPDATE25_4_0_, this_.USER_NAME as USER26_4_0_, this_.USER_TYPE as USER27_4_0_ from tb_fd_user this_ where (this_.EMAIL=?)
result size:1

這個網誌中的熱門文章

Bash判斷參數是否存在

-
早上看到nixCraft的文章後，決定在這邊記錄一下... 透過之前提過的 -z "$var"可以判斷var這個變數是否存在 而很多的shell希望判斷可以再精簡一點... 所以會有結合[ test ]跟&&, ||來做流程的方式 其中： [ ] 裡面可以放test語句，執行完會傳出結果為true或false || 我比較不常用，看起來是如果前面為非則執行後面的程式段落 && 這個後面接的是當前面段落執行無錯誤時候，則執行後面程式段落 透過上面說明，使用"||"組句的話，我們可以把判斷是這樣寫： [ -z "$var" ] || echo "Empty"     #如果var存在為非，則echo Empty [[ -z "$var" ]] || echo "Empty"   #同上 反之，使用"&&"組句的話，可以： [ ! -z "$var" ] && echo "Empty"   # 如果var存在為是，則echo Empty [[ ! -z "$var" ]] && echo "Empty"  #同上 參考自： http://www.cyberciti.biz/faq/unix-linux-bash-script-check-if-variable-is-empty/
閱讀完整內容

Node.js package : forever

-
forever為一套node.js維運套件 透過監控程式健康狀態來管理node.js程式，並在異常關閉時候重新啓動您的程式，這樣就不用怕程式因為沒有handle的exception導致異常關閉時候不能提供服務拉！ forever的安裝與使用相當簡單： 1.首先，安裝forever套件(當然，您需要先有node.js與npm套件拉！)，其中 -g 很重要，因為您必須要安裝到系統目錄，才能夠支援在任何環境下啟動forever程式 # npm install forever -g 2.使用forever管理您的node.js程式： (這邊假設我們建立了一個express專案，app.js的路徑是/tmp/TestPrj/app.js) 啟動您的node.js程式： forever start [node.js application path] # forever start /tmp/TestPrj/app.js  info:   Forever processing file: /tmp/TestPrj/app.js 檢視已啓動的forever程式(就是您使用forever啓動的node.js程式)： forever list # forever list info:   Forever processes running data:       uid  command script              forever pid   logfile                          uptime         data:   [0] P0Fa node    /tmp/TestPrj/app.js 50062   50079 /Users/simonsu/.forever/P0Fa.log 0:1:49:10.335  關閉已啓動的Node程式： forever stop [forever process id] # forever stop 0 info:   Forever stopped process: data:       uid  command script              forever pid   logfile      
閱讀完整內容