| | |
| | | import java.sql.*; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * Access帮助类 |
| | | * @author WWW |
| | | */ |
| | | @SuppressWarnings("ALL") |
| | | public class AccessHelper { |
| | | private final static Log log = LogFactory.getLog(AccessHelper.class); |
| | | |
| | | /** |
| | | * 读取.mdb文件 |
| | | * |
| | | * @param mdbPath mdb文件地址 |
| | | * @param username 用户名 |
| | | * @param password 密码 |
| | | */ |
| | | public static List<Map<String, Object>> readMdb(String mdbPath, String username, String password) { |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | | |
| | |
| | | return list; |
| | | } |
| | | |
| | | /** |
| | | * 关闭所有的资源链接 |
| | | * |
| | | * @param conn 连接 |
| | | * @param ps 执行语句 |
| | | * @param tables 结果集 |
| | | * @param rs 结果集 |
| | | */ |
| | | private static void closeA1l(Connection conn, PreparedStatement ps, ResultSet tables, ResultSet rs) { |
| | | try { |
| | | if (null != rs) { |