三月 2017 – 葛麗絲的分享世界

chrome查到網頁request的流量的方式

發表於2017/03/30 由Grace撰寫

1.於chrome => click “F12″ Button，顯示如下頁面
連至欲觀察流量的頁面，
於下方即可看到每個request的url、status(http code)、size(若為cache會顯示from disk cache)

2.有相關篩選可以選擇，於下方內click right mouse，
有清除cache、cookies選項、將檔案開啟在source panel或新頁面，
其中Save as HAR with content是將此分析結果儲存為har檔，
har檔為JSon格式故可以用開啟json的工具觀察，
網路上已有相關的讀取程式。

程式分享

javascript股票走勢圖繪圖及好用的Timeline介紹

發表於2017/03/282017/03/28 由Grace撰寫

一、股票走勢圖繪圖
之前為了網頁能繪製股票走勢圖購買了highstock的license (我是買綁domain的license)，
今天找到用d3.js套件，
若只是顯示，不做互動是可以試用看看~http://arnauddri.github.io/d3-stock/

二、Timeline
1.Responsive Timeline
網址: https://codecanyon.net/item/first-responsive-timeline/19352502?ref=pxcr
費用: 美金12元
Demo: http://iscoalarcon.cidcode.net/timeline/
說明: 可以為網站或投資組合創建自己的時間表。是基於CSS3和jQuery，包括非常簡單的編輯界面，現代設計和各種過渡風格。包括超過40多種動畫，10多種風格。支援responsive，且支援所有HTML內容，如iframe，文本，圖像，視頻，音頻等。適用於從PC、Mobile及Pad，且支援各式瀏覽器。可使用任何獨立的動畫庫（包括圖例）在javascript中進行動畫。

2.vis.js
網址: http://visjs.org
費用: 基於MIT license
Demo: http://visjs.org/timeline_examples.html
說明: 一個動態的，基於瀏覽器的可視化庫。旨在易於使用，處理大量的動態數據，由DataSet、Timeline、Network、Graph2d和Graph3d組成。

3.Timeglider.js
網址: http://timeglider.com/widget/
費用: 非商業免費，商業請參考-https://timeglider.com/widget/?p=license
Demo: https://timeglider.com/widget/kitchen_sink.html
說明: 適用於iOS和Android觸控設備; Windows Surface設備仍然存在問題。數據可使用JSON格式或來自頁面上現有的JavaScript資料。

程式分享

java取得package下的class及function清單，供前端網頁選取時使用

發表於2017/03/232017/03/23 由Grace撰寫

1.先設定3個class

1) JBMethodItem

import java.util.LinkedList;
import java.util.List;

public class JBClassItem {
    private String className;
    private String classLongName;
    private List methodList = new LinkedList();
    
    public JBClassItem(String className, String classLongName) {
        super();
        this.className = className;
        this.classLongName = classLongName;
    }

    public String getClassName() {
        return className;
    }

    public void setClassName(String className) {
        this.className = className;
    }
    
    public String getClassLongName() {
        return classLongName;
    }

    public void setClassLongName(String classLongName) {
        this.classLongName = classLongName;
    }

    public List getMethodList() {
        return methodList;
    }

    public void setMethodList(List methodList) {
        this.methodList = methodList;
    }
    
    public void addMethodList(JBMethodItem jbMethodItem) {
        this.methodList.add(jbMethodItem);
    }

    @Override
    public String toString() {
        String sBuffer = "JBClassItem [className=" + className + ", classLongName=" + classLongName + ", methodList=";
        for (JBMethodItem jbMethodItem : methodList)
            sBuffer += jbMethodItem;
        sBuffer += "]";
        return sBuffer;
    }
}

2) JBMethodItem

import java.util.Iterator;
import java.util.LinkedHashMap;

public class JBMethodItem {
    private String methodName;
    private LinkedHashMap<Integer, JBParamItem> params = new LinkedHashMap<Integer, JBParamItem>();
    
    public JBMethodItem(String methodName) {
        super();
        this.methodName = methodName;
    }
    
    public String getMethodName() {
        return methodName;
    }

    public void setMethodName(String methodName) {
        this.methodName = methodName;
    }
    
    public LinkedHashMap<Integer, JBParamItem> getParams() {
        return params;
    }

    public void setParams(LinkedHashMap<Integer, JBParamItem> params) {
        this.params = params;
    }

    public void addParams(Integer paramIdx, String paramType) {
        JBParamItem paramItem = params.get(paramIdx);
        if (paramItem == null) {
            paramItem = new JBParamItem(paramIdx);
        }
        paramItem.setParamType(paramType);
        
        params.put(paramIdx, paramItem);
    }
    
    @Override
    public String toString() {
        String sBuffer = "JBMethodItem [methodName=" + methodName + ", params=";
        Iterator it = params.keySet().iterator();
        while (it.hasNext()) {      
            Integer iKey = (Integer) it.next();     
            JBParamItem jbParamItem = (JBParamItem) params.get(iKey);
            sBuffer += "\n" + jbParamItem;
        }
        sBuffer += "]";
        return sBuffer;
    }
}

3) JBParamItem

public class JBParamItem {
    private int paramIdx;
    private String paramType;
    
    public JBParamItem(int paramIdx) {
        super();
        this.paramIdx = paramIdx;
    }

    public int getParamIdx() {
        return paramIdx;
    }
    
    public void setParamIdx(int paramIdx) {
        this.paramIdx = paramIdx;
    }
    
    public String getParamType() {
        return paramType;
    }
    
    public void setParamType(String paramType) {
        this.paramType = paramType;
    }

    @Override
    public String toString() {
        return "JBParamItem [paramIdx=" + paramIdx + ", paramType=" + paramType + "]";
    }
}

2.主要程式碼

import java.io.File;
import java.io.IOException;
import java.lang.reflect.Method;
import java.lang.reflect.Modifier;
import java.net.URL;
import java.util.*;
....
....
public class JBMainMonitorAction extends BaseAction {
    @Override
    public String execute() throws Exception {
        //取得package下class 清單
        List jbClassItemList = retriveClassItemList(logger);
        for (JBClassItem jbClassItem : jbClassItemList)
            logger.debug(jbClassItem);
        request.setAttribute("jbClassItemList", jbClassItemList);
        
        return super.execute();
    }

    /**
     * 取得package下class 清單
     * @throws IOException 
     * @throws ClassNotFoundException 
     */
    private static List retriveClassItemList(Logger logger) 
            throws ClassNotFoundException, IOException {
        List classItemList = new LinkedList();
        
        List classList = getClasses("com.tssco.util.job");
        for (Class classTmp : classList) {
            if (classTmp.getSuperclass().getSimpleName().compareToIgnoreCase("SuperMonTask") != 0)
                continue;

            JBClassItem jbClassItem = new JBClassItem(classTmp.getSimpleName(), classTmp.getName());            
            Method[] method = classTmp.getDeclaredMethods();
            for (int iIdx_m = 0; iIdx_m < method.length; iIdx_m++) {                 if (method[iIdx_m].getReturnType().toString().compareToIgnoreCase("boolean") != 0)                  continue;               List modNames = Arrays.asList(Modifier.toString(method[iIdx_m].getModifiers()).split("\\s"));               boolean bPublic = false;                int iElseCnt = 0;               for (String modifier : modNames) {                  if (modifier.compareToIgnoreCase("public") == 0)                        bPublic = true;                     else                        iElseCnt++;                 }               if (iElseCnt > 0 || bPublic == false)
                    continue;
                
                JBMethodItem jbMethodItem = new JBMethodItem(method[iIdx_m].getName());
                Class<?>[] paramList = method[iIdx_m].getParameterTypes();
                int paramIdx = 0;
                for (Class paramTmp : paramList) {
                    logger.info(paramTmp.getSimpleName());
                    jbMethodItem.addParams(++paramIdx, paramTmp.getSimpleName());
                }
                
                jbClassItem.addMethodList(jbMethodItem);
            }
            
            if (jbClassItem.getMethodList().size() > 0)
                classItemList.add(jbClassItem);
        }
        
        return classItemList;
    }
    
    private static List getClasses(String packageName) throws ClassNotFoundException, IOException {
        ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
        assert classLoader != null;
        String path = packageName.replace('.', '/');
        Enumeration resources = classLoader.getResources(path);
        List dirs = new ArrayList();
        while (resources.hasMoreElements()) {
            URL resource = resources.nextElement();
            dirs.add(new File(resource.getFile()));
        }
        ArrayList classes = new ArrayList();
        for (File directory : dirs) {
            classes.addAll(findClasses(directory, packageName));
        }
        return classes;
    }
    
    private static List findClasses(File directory, String packageName) throws ClassNotFoundException {
        List classes = new ArrayList();
        if (!directory.exists()) {
            return classes;
        }
        File[] files = directory.listFiles();
        for (File file : files) {
            if (file.isDirectory()) {
                assert !file.getName().contains(".");
                classes.addAll(findClasses(file, packageName + "." + file.getName()));
            } else if (file.getName().endsWith(".class")) {
                classes.add(Class.forName(packageName + '.' + file.getName().substring(0, file.getName().length() - 6)));
            }
        }
        return classes;
    }
}

3.前端javascript可加上此段讓互動時可以選取

   //取得package下class 清單
    var classMap = new Object();
<%
    List jbClassItemList = (List) request.getAttribute("jbClassItemList");
    for (JBClassItem jbClassItem : jbClassItemList) {
        String className = jbClassItem.getClassName();
        String classLongName = jbClassItem.getClassLongName();
        String methodMapName = "methodMap_" + className;
        out.println("var " + methodMapName + " = new Object();");
        List methodList = jbClassItem.getMethodList();
        for (JBMethodItem jbMethodItem : methodList) {
            String methodName = jbMethodItem.getMethodName();
            LinkedHashMap<Integer, JBParamItem> params = jbMethodItem.getParams();
            String paramListName = "paramList_" + className + "_" + methodName;
            out.println("var " + paramListName + " = [];");
            
            List paramList = new ArrayList(params.values());
            for (JBParamItem JBParamItem : paramList) {
                String paramType = JBParamItem.getParamType();
                if (paramType.compareTo("int") == 0)
                    paramType = "Integer";
                out.println(paramListName + ".push({'paramIdx': " + JBParamItem.getParamIdx() + 
                        ",'paramType': '" + paramType + "'});");
            }
%>
            <%= methodMapName %>['<%= methodName %>'] = {'name' : '<%= methodName %>', 'paramList' : <%= paramListName %>};
<%       } %>
        classMap['<%= classLongName %>'] = {'name' : '<%= className %>', 'longName' : '<%= classLongName %>', 
                    'methodMap' : <%= methodMapName %>};
<%   } %>

4.前端javascript就可取其值做應用了。

工具

eclipse內import github專案

發表於2017/03/222017/03/22 由Grace撰寫

1.下載套件EGit

Eclipse => Eclipse Marketplace => git => EGit => Install

2.找到欲下載的github

Ex.https://github.com/line/line-bot-sdk-java

3.設定Import github專案之路徑

1) Eclipse => File => Import => Git => 選取"Projects from Git" => Click “Next" Button

2) 選"Clone URI" => “Next" Button

3) 輸入github路徑，Ex.https://github.com/line/line-bot-sdk-java.git

其它欄位均自動帶出 => Click “Next" Button

4.Import專案

1) 選取全部 => Click “Next" Button

2) Click “Next" Button

3) 選取"Import as general project" (請依專案狀況選取) => Click “Next" Button

4) Click “Next" Button

5) Import結果如下

工具

eclipse新增svn : 使用subclipse

發表於2017/03/222017/03/22 由Grace撰寫

在eclipse上使用install New Software及 Eclipse Marketplace因出現PKIX path building failed，

(subclipse install路徑 : https://dl.bintray.com/subclipse/releases/subclipse/latest/)

就想說用手動安裝subclipse，步驟如下 :

1.下載 subclipse plugin : 我是用4.2.2

https://dl.bintray.com/subclipse/releases/subclipse/subclipse-4.2.2.zip

2.解壓縮zip檔，分別將路徑下的plugins及features複製至eclipse相對應的路徑下

3.重新啟動eclipse

4.設定SVN Client

Eclipse => Window => Preferences => Team => SVN

=> 彈出一個大大的對話框，報一個Failed to load JavaHL Library.錯誤

=> 按OK Button

=> 於SVN介面: Client只看到"JavaHL (JNI) Not available"，未看到SVNKit，故需要再安裝SVNKit

1) 下載plugin檔 : 我使用1.8.1版本 (https://svnkit.com/download.php)

2) 解壓縮zip檔，分別將路徑下的plugins及features複製至eclipse相對應的路徑下

3) 重新啟動eclipse

5.再次設定SVN Client

Eclipse => Window => Preferences => Team => SVN

=> 彈出一個大大的對話框，報一個Failed to load JavaHL Library.錯誤

=> 按確定 => SVN介面: Client選取"SVNKit (Pure Java)…"選項

=> 按OK Button

6.設定Perspective為 “瀏覽SVN檔案庫"

Eclipse => Window => Perspective => Open Perspective => Other

=> 選取 “瀏覽SVN檔案庫" => OK Button

7.設定SVN位置

於"SVN檔案庫" click 右鍵 => 新增 => 檔案庫位置

=> Url請輸入SVN位置，Ex.https://xxx.xx.xx.xx:8443/svn/grace_svn/

即可在Eclipse做SVN版本控管了。

呈現畫面如下，請參考!

程式分享

Hibernate 5.2 version -> org.hibernate.Query class and methods deprecate?

發表於2017/03/222017/03/22 由Grace撰寫

原本使用org.hibernate.Query於hibernate升級至5.2版出現The type Query<R> is deprecated，
許多method也出現deprecate訊息，
原本

import org.hibernate.Query;
...
Query query = session.createQuery(" FROM WABlog c Order By blogId desc");
query.setMaxResults(iMaxRecord);
query.setFirstResult(0);
List<WABlog> waBlogList = query.list();

需調整為

import javax.persistence.TypedQuery;
...
TypedQuery<WABlog> query = session.createQuery(" FROM WABlog c Order By blogId desc");
query.setMaxResults(iMaxRecord);
query.setFirstResult(0);
List<WABlog> waBlogList = query.getResultList();

程式分享

java restful Demo code with spring + hibernate

發表於2017/03/222017/03/22 由Grace撰寫

github : https://github.com/yahuihuang/java/tree/master/restfulTest

1.create table and stored procedure in mysql database
1) DB/1.cr_table.sql
2) DB/2.cr_SP.sql

2.maven command for pom.xml

3.change config
1) src/sysConfig.xml : modify pwd.deskey value , the value you can edit for your prefer
<entry key="pwd.deskey">XXXXXX</entry>

2) WebContent/WEB-INF/applicationContext_WA.xml
a.change mysql db connection
<property name="jdbcUrl" value="jdbc:mysql://XXX.XX.XX.XX:3306/XXXXXX?characterEncoding=utf-8&autoReconnect=true" />
b.change mysql db user and password,
the password should be encrypt, you can edit WebContent/DesTest.jsp sIn variable,
and get output string , then put in password property.
<bean id="dataSourceProperties" class="info.codingfun.restful.util.PropertiesEncryptFactoryBean">
<property name="properties">
<props>
<prop key="user">XXXXXXX</prop>
<prop key="password">XXXXXXX</prop>
</props>
</property>
</bean>

4.insert some data in mysql table : WABlog

5.test
1) http://127.0.0.1:8080/restfulTest/services/blogservice/getpost/1
http://127.0.0.1:8080/restfulTest/services/blogservice/getpost/1.xml
@GET Request: None
Content-Type: application/x-www-form-urlencoded
accept: application/json

2) http://127.0.0.1:8080/restfulTest/services/blogservice/getallpost
http://127.0.0.1:8080/restfulTest/services/blogservice/getallpost.xml
@GET Request: None
Content-Type: application/x-www-form-urlencoded
accept: application/json

3) http://127.0.0.1:8080/restfulTest/services/blogservice/addpost
@POST Request:
<?xml version="1.0″ encoding="UTF-8″ standalone="yes"?>
<BlogPostType xmlns="http://codingfun.info/restful/xsd">
<title>title-1</title>
<slogan>slogan-1</slogan>
<description>description-1</description>
<status>1</status>
<modifyEmp>grace</modifyEmp>
</BlogPostType>
Content-Type: application/xml
accept: application/x-www-form-urlencoded

4) http://localhost:8080/restfulTest/services/blogservice/updatepost
@PUT Request:
{
“blogId": 1,
“title": “title-2″,
“slogan": “slogan-2″,
“description": “description-2″,
“status": 1,
“modifyTime": “2017-03-06T09:05:34.000+08:00″,
“modifyEmp": “grace"
}
Content-Type: application/json
accept: application/x-www-form-urlencoded

5) http://localhost:8080/restfulTest/services/blogservice/deletepost
@DELETE Request:
{
“blogId": 1
}
Content-Type: application/json
accept: application/x-www-form-urlencoded

一	二	三	四	五	六	日
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

月份: 三月 2017

chrome查到網頁request的流量的方式

多個查詢及執行由同一組程式執行

java產生縮圖

使用iText將word功能變數convert 成 pdf

javascript股票走勢圖繪圖及好用的Timeline介紹

java取得package下的class及function清單，供前端網頁選取時使用

eclipse內import github專案

eclipse新增svn : 使用subclipse

Hibernate 5.2 version -> org.hibernate.Query class and methods deprecate?

java restful Demo code with spring + hibernate

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：

分享此文：