分類: 程式分享

1.先使用Adobe Acrobat Pro DC 產生 Field Properties(Edit PDF => Prepare Form)

2.下載iText7

http://developers.itextpdf.com/itext-7-java

3.程式如下

import com.itextpdf.forms.PdfAcroForm;
import com.itextpdf.forms.fields.PdfFormField;
import com.itextpdf.io.font.PdfEncodings;
import com.itextpdf.kernel.color.Color;
import com.itextpdf.kernel.font.PdfFont;
import com.itextpdf.kernel.font.PdfFontFactory;
import com.itextpdf.kernel.pdf.*;

ublic class testPDF { 
    public static final String SRC = "pdf/src/subscribe.pdf";
    public static final String DEST = "pdf/dest/subscribe_result.pdf";
 
    public static void main(String args[]) throws IOException {
        new testPDF().manipulatePdf(SRC, DEST);
    }
 
    public void manipulatePdf(String src, String dest) throws IOException {
        //Initialize PDF document
        PdfDocument pdfDoc = new PdfDocument(new PdfReader(src), new PdfWriter(dest)); 
 
        PdfAcroForm form = PdfAcroForm.getAcroForm(pdfDoc, true);
        Map<String, PdfFormField> fields = form.getFormFields();
        //中文字issue 
        PdfFont font = PdfFontFactory.createFont("font/kaiu.ttf", PdfEncodings.IDENTITY_H, true);
        fields.get("personal.name").setFont(font); 
        fields.get("personal.loginname").setFont(font);
        fields.get("personal.password").setFont(font);
        fields.get("personal.reason").setFont(font);
        
        fields.get("personal.name").setValue("測試名字").setBackgroundColor(Color.ORANGE);
        fields.get("personal.loginname").setValue("NickName").setBackgroundColor(Color.WHITE);
        fields.get("personal.password").setValue("a12345678").setBackgroundColor(Color.WHITE);
        fields.get("personal.reason").setValue("原因是...").setBackgroundColor(Color.WHITE);
        
        form.flattenFields();
        pdfDoc.close();
    }
}

4.執行後產生之PDF如下圖

5.若使用iText5，中文字的處理如下範例

        PdfReader reader = new PdfReader(src);
        PdfStamper stamper = new PdfStamper(reader,
                new FileOutputStream(dest));
        
        AcroFields fields = stamper.getAcroFields();
        //中文字處理
        BaseFont font = BaseFont.createFont("font/kaiu.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED );
        fields.setFieldProperty("name","textfont",font,null);        
        fields.setField("name", "ROC 台灣");

        stamper.setFormFlattening(true);
        stamper.close();
        reader.close();

期望的畫面如下

畫面的html如下

1.jquery bootstrapValidator如何驗證2個欄位只輸入其一即可

    //被授權人
    $('#rowAddAuthForm').bootstrapValidator({
        excluded: [':disabled'],
        fields: {
            telNo: {
                group: '.col-md-3',
                validators: {
                    callback: {
                        callback: function(value, validator, $field) {
                            var field_name = $($field).attr('name');
                            if (value.length == 0 && $('#mobileNo_auth').val() == '') {
                                return {
                                    valid: false,
                                    message: '連絡電話、手機請至少輸入其一'
                                }
                            }
                            
                            if ($('#mobileNo_auth').val() == '') {
                                $('#rowAddAuthForm').bootstrapValidator('resetField', 'mobileNo' )
                                     .bootstrapValidator('updateStatus', 'mobileNo', 'VALID');
                                $('#rowAddAuthForm').bootstrapValidator('disableSubmitButtons', false);
                            }
                            
                            $('#rowAddCommForm').data('bootstrapValidator').resetForm(true);
                            if (value.length != 0) {
                                var pattern = /^[0-9]+$/;        
                                if (value.length  8) {
                                    return {
                                        valid: false,
                                        message: '電話 長度需為6~8'
                                    }
                                } else if (pattern.test(value) == false) {
                                    return {
                                        valid: false,
                                        message: '電話 請輸入數字'
                                    }
                                } else {
                                    return true;
                                }                                
                            } else {
                                $('#rowAddAuthForm').bootstrapValidator('resetField', field_name )
                                     .bootstrapValidator('updateStatus', field_name, 'NOT_VALIDATED');
                                $('#rowAddAuthForm').bootstrapValidator('disableSubmitButtons', false);
                                return true;
                            }
                        }
                    }
                }
            },
            mobileNo: {
                group: '.col-md-3',
                validators: {
                    callback: {
                        callback: function(value, validator, $field) {
                            var field_name = $($field).attr('name');
                            if (value.length == 0 && $('#telNo_auth').val() == '') {
                                return {
                                    valid: false,
                                    message: '連絡電話、手機請至少輸入其一'
                                }
                            }
                            
                            if ($('#telNo_auth').val() == '') {
                                $('#rowAddAuthForm').bootstrapValidator('resetField', 'telNo' )
                                        .bootstrapValidator('updateStatus', 'telNo', 'VALID');  
                                $('#rowAddAuthForm').bootstrapValidator('disableSubmitButtons', false);
                            }
                            
                            if (value.length != 0) {
                                var pattern = /^[0-9]+$/;        
                                if (value.length != 10) {
                                    return {
                                        valid: false,
                                        message: '手機號碼 長度需為10'
                                    }
                                } else if (pattern.test(value) == false) {
                                    return {
                                        valid: false,
                                        message: '手機號碼 請輸入數字'
                                    }
                                } else {
                                    return true;
                                }                                
                            } else {
                                $('#rowAddAuthForm').bootstrapValidator('resetField', field_name )
                                        .bootstrapValidator('updateStatus', field_name, 'NOT_VALIDATED');  
                                $('#rowAddAuthForm').bootstrapValidator('disableSubmitButtons', false);
                                return true;
                            }
                            
                        }
                    }
                }
            }
        }
    }).on('success.form.bv', function(e) {
        e.preventDefault();
        myfootable.auth_save(e);
        $("#addAuthModal").modal("hide");
    });    

2.bootstrapValidator如何判斷A欄位有值，B欄位也應有值 (反之，若A欄位無值，則B欄位無需有值)

    //被授權人
    $('#rowAddAuthForm').bootstrapValidator({
        excluded: [':disabled'],
        fields: {
            ...
            telRC: {
                validators: {
                    stringLength: {
                        min: 2,
                        max: 4,
                        message: '電話區碼 長度需為2~4'
                    },
                    regexp: {
                        regexp: /^[0-9]+$/,
                        message: '電話區碼 請輸入數字'
                    },
                    callback: {
                        callback: function(value, validator, $field) {
                            var field_name = $($field).attr('name');
                            if (value.length == 0 && $('#telNo_auth').val().length > 0) {
                                return {
                                    valid: false,
                                    message: '請輸入電話區碼'
                                }
                            } else {
                                return true;
                            }
                        }
                    }
                }                
            },
            ...
        }
    }).on('success.form.bv', function(e) {
        e.preventDefault();
        myfootable.auth_save(e);
        $("#addAuthModal").modal("hide");
    });    

註：bootstrapValidator的相關文件可參考 http://bv.doc.javake.cn/api/

文章：Tomcat啟動很久才完成經過2週終於找到原因並成功解決了~

原因是hibernate的hbm.xml設定檔在Tomcat啟動時需先load至Tomcat memory，但是透過hbm.xml檔load至memory需要I/O及memory，故會花費許久，因table共70多個，而且有些table的欄位很多，故造成Tomcat需啟動許久。
我試了以下3種hbm.xml的設定均無法降低啟動時間：

<property name="mappingDirectoryLocations">
    <list>
        <value>classpath:com/xxx/bean/</value>
    </list>
</property>

<property name="mappingLocations">
    <list>
        <value>classpath:com/xxx/bean/*.hbm.xml</value>
        ...
    </list>
</property>

<property name="mappingResources">
    <list>
        <value>com/xxx/bean/PRCmdCfg.hbm.xml</value>
        ...
    </list>
</property> 

後來，試著將設定檔內sql調整成直接寫在程式內而不用hbm.xml設定的方式，啟動效能並未改善：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC    
  "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
  "http://hibernate.org/dtd/hibernate-mapping"> 
<hibernate-mapping> 
  <class name="com.xxx.bean.PRUnit" table="PRUnit"> 
   ...
  </class>
    <sql-query name="findPRUnitWithDetail">
        <return alias="t1" class="com.xxx.bean.PRUnit"/>
        <return alias="t2" class="com.xxx.bean.PRFuncCfg"/>
        <return alias="t3" class="com.xxx.bean.PRCmdCfg"/>
        <return alias="t4" class="com.xxx.bean.PRCode"/>
        <return alias="t5" class="com.xxx.bean.PRCode"/>
        <return alias="t7" class="com.xxx.bean.PRMenuCfg"/>
        <![CDATA[
        SELECT {t1.*}, {t2.*}, {t3.*}, {t4.*}, {t5.*}, {t7.*} 
          FROM PRUnit t1
          JOIN PRFuncCfg t2
            ON t1.platForm = t2.platForm
           AND t1.funcId   = t2.funcId
          JOIN PRCmdCfg t3
            ON t1.platForm = t3.platForm
           AND t1.funcId   = t3.funcId  
           AND t1.cmdId    = t3.cmdId      
          JOIN PRCode t4
            ON t4.CodeType = 'UNIT'
           AND t1.unitId   = t4.CodeId
          JOIN PRCode t5
            ON t5.CodeType = 'PLFM'
           AND t1.platForm = t5.CodeId  
          JOIN PRMenuCfg t7
            ON t2.platForm = t7.platForm
           AND t2.menuId   = t7.menuId                 
         WHERE t1.unitId 
               in (SELECT t8.unitId 
                     FROM PREmpUnit t8 
                    WHERE t8.empId=:EmpId AND t8.cmdEnable = 1)
           AND t1.cmdEnable = 1 
        ]]>
    </sql-query>
</hibernate-mapping>

最後，只好用最麻煩的方式，取消hbm.xml的設定，改為直接在class設定

...

@Entity
@Table(name = "PRUnit")
public class PRUnit implements Serializable {
    @EmbeddedId
    @AttributeOverrides({
        @AttributeOverride(
            name = "platForm",
            column = @Column(name = "platForm")),
        @AttributeOverride(
            name = "unitId",
            column = @Column(name = "unitId")),
        @AttributeOverride(
            name = "funcId",
            column = @Column(name = "funcId")),
        @AttributeOverride(
            name = "cmdId",
            column = @Column(name = "cmdId"))
    })
    private PRUnitPK PRUnitPK;
    @Column(name = "cmdEnable")
    private int cmdEnable;
    @Column(name = "cfgVal")
    private String cfgVal;
    @Column(name = "optVal")
    private String optVal;
    @Column(name = "modifyTime")
    private Date modifyTime;
    @Column(name = "modifyEmp")
    private String modifyEmp;

    public PRUnit() {
        
    }
    
    public PRUnit(PRUnitPK PK) {
        this.PRUnitPK = PK;
    }

    public PRUnitPK getPRUnitPK() {
        return PRUnitPK;
    }

    public void setPRUnitPK(PRUnitPK pRUnitPK) {
        PRUnitPK = pRUnitPK;
    }

    public int getCmdEnable() {
        return cmdEnable;
    }

    public void setCmdEnable(int cmdEnable) {
        this.cmdEnable = cmdEnable;
    }

    public String getCfgVal() {
        return cfgVal;
    }

    public void setCfgVal(String cfgVal) {
        this.cfgVal = cfgVal;
    }

    public String getOptVal() {
        return optVal;
    }

    public void setOptVal(String optVal) {
        this.optVal = optVal;
    }

    public Date getModifyTime() {
        return modifyTime;
    }

    public void setModifyTime(Date modifyTime) {
        this.modifyTime = modifyTime;
    }

    public String getModifyEmp() {
        return modifyEmp;
    }

    public void setModifyEmp(String modifyEmp) {
        this.modifyEmp = modifyEmp;
    }

    @Override
    public String toString() {
        return "PRUnit [PRUnitPK=" + PRUnitPK + ", cmdEnable=" + cmdEnable + ", cfgVal=" + cfgVal + ", optVal=" + optVal
                + ", modifyTime=" + modifyTime + ", modifyEmp=" + modifyEmp + "]";
    }   
}

而applicationContext.xml調整為下面任一方式，Tomcat均能在1、2分鐘內啟動完畢

<property name="packagesToScan">
    <list>
        <value>com.xxx.bean</value>
    </list>
</property>
<property name="mappingDirectoryLocations">
    <list>
        <value>classpath:com/xxx/bean/</value>
    </list>
</property>

究其原因，猜測是hibernate在load hbm.xml需要花費較多的I/O及memory，故造成啟動花費超久，
剛開始使用此架構因table尚少沒感覺，等系統愈來愈大就開始造成困擾了~還好調整後能修正此問題，
要不然整個架構大改，就不是花幾天能完成的~

1.在"catalina.sh"增加此行效果不大

JAVA_OPTS="$JAVA_OPTS -Xms1024m -Xmx1024m"

2.研究spring設定檔 “applicationContext.xml" 讀取hibernate hbm.xml，

因為似乎是加上新的db schema在設定了hbm.xml後才變慢的~~

原本設定是遞迴讀此目錄下的所有檔案，但此目錄下有其它的class (非hbm.xml)

<property name="mappingDirectoryLocations">
    <list>
        <value>classpath:com/test/bean/</value>
    </list>
</property>

改成如下

<property name="mappingLocations">
    <list>
        <value>classpath:com/test/bean/*.hbm.xml</value>
        <value>classpath:com/test/bean/derivadm/*.hbm.xml</value>
        <value>classpath:com/test/bean/futadm/*.hbm.xml</value>
        <value>classpath:com/test/bean/job/*.hbm.xml</value>
        <value>classpath:com/test/bean/warrantadm/*.hbm.xml</value>
    </list>
 </property>

收到不錯的效果，啟動時間由原本的10多分鐘，縮短至4分鐘，
但仍需有努力的空間…
hibernate設定hbm.xml還有一個方式就是逐檔設定，當初就是嫌麻煩才用路徑，
也這之後要改回這個方式再試試吧~

<property name="mappingResources">
    <list>
        <value>au/com/test/bean/Address.hbm.xml</value>
        <value>au/com/test/bean/Country.hbm.xml</value>
        <!-- repeat for their mapping files -->
    </list>
</property>

3.後來再調整applicationContext.xml
於bean加上lazy-init=true

<bean id="IFServiceDao" class="com.xxx.xxx.transactional.IFServiceImpl" 
        scope="singleton" lazy-init="true">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>

但效果不大
故於beans加上default-lazy-init=true

<beans xmlns="http://www.springframework.org/schema/beans"
        ....
        default-lazy-init="true">

看似有點效果，但tomcat啟動還是要5分鐘。

最後再將hibernate.hbm2ddl.auto整個移除Tomcat竟然1分鐘內就啟動好了，
雖然執行application的程式仍需要3~4分鐘，
但至少其它application可以早點執行了~

會想要調整這個參數是因每次都在log看到此行以後Tomcat才算啟動完成。
INFO [http-bio-80-exec-4] SchemaUpdate [execute] [101] HHH000228: Running hbm2ddl schema update

<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        ...
        <property name="hibernateProperties">
            <props>
                ...
                <!-- 
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                 -->
                ...         
            </props>
        </property>
    </bean>

前年為了給兒子寫個玩具app，

就寫了這個app，

稱玩具的原因是因為它沒有一般遊戲軟體計分的功能，

但可以選取手機或平版內的相簿圖片 或 真接照相後 就可以當成拼圖來源．

google play下載網址：https://play.google.com/store/apps/details?id=com.sweetlife.mypuzzle

youtube操作影片：https://www.youtube.com/watch?v=Pc5jSJjxkNg