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/
閱讀完整內容

使用 minikube 輕鬆上手 kubernetes

-
安裝minikube macOS只需要透過brew即可快速安裝... brew cask install minikube Linux環境可以直接下載執行檔，放到環境變數可以吃到的路徑即可... curl -Lo minikube https: / /storage.googleapis.com/minikube/releases/latest/minikube-linux-amd64 && \ chmod +x minikube && \ sudo mv minikube /usr/local/bin/ Windows的下載網址如下： https://storage.googleapis.com/minikube/releases/latest/minikube-windows-amd64.exe 如果您的kubectl尚未安裝，可以直接使用google cloud sdk來安裝： curl https://sdk.cloud.google.com | bash gcloud components install kubectl 安裝完成後，原則上minikube會在本地端加入minikube的k8s context，我們可以透過下面指令來使用該context… kubectl config use - context minikube 然後，可檢查一下您的minikube node是否正常運作.... $ kubectl get node -o wide NAME       STATUS    AGE       VERSION   EXTERNAL- IP   OS-IMAGE            KERNEL-VERSION minikube   Ready  ...
閱讀完整內容