以前Java读取.mdb文件,太依赖JDK的位数了,必须用32位的;
现在运用jackcess来解析.mdb文件,这样不被限制;
pom.xml文件:
commons-io
commons-io
2.3
com.healthmarketscience.jackcess
jackcess
2.1.10
net.sf.ucanaccess
ucanaccess
4.0.0
com.healthmarketscience.jackcess
jackcess-encrypt
2.1.4
代码如下:
package com.accord.utils;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import net.ucanaccess.jdbc.JackcessOpenerInterface;
import com.accord.entity.Corp;
import com.healthmarketscience.jackcess.CryptCodecProvider;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Row;
impo