java 操作mdb文件

朱雀 2022-06-17 07:21 654阅读 0赞

默认先在目录下生成common.mdb文件

/\*\*

\* Project Name:MonitoringPlatform-commons-util  
 \* File Name:MdbUtils.java  
 \* Package Name:com.monitoring.common.util  
 \* Date:2017年4月20日上午10:40:50  
 \* Copyright (c) 2017, chenzhou1025@126.com All Rights Reserved.  
 \*  
\*/  
  
package com.monitoring.common.util;  
  
import java.io.File;  
import java.sql.Types;  
import java.util.Map;  
  
  
  
import org.apache.commons.io.Charsets;  
  
import com.healthmarketscience.jackcess.ColumnBuilder;  
import com.healthmarketscience.jackcess.Database;  
import com.healthmarketscience.jackcess.Database.FileFormat;  
import com.healthmarketscience.jackcess.Table;  
import com.healthmarketscience.jackcess.TableBuilder;  
  
/\*\*  
 \* ClassName:MdbUtils <br/>  
 \* Function:  ADD FUNCTION. <br/>  
 \* Reason:      ADD REASON. <br/>  
 \* Date:     2017年4月20日 上午10:40:50 <br/>  
 \* @author   wpengfei  
 \* @version    
 \* @since    JDK 1.6  
 \* @see       
 \*/  
public class MdbUtils \{  
    public static void operator() throws Exception \{    
        File mdbFile = new File("E:\\\\hospital\\\\trunk\\\\MonitoringPlatform-commons-util\\\\src\\\\main\\\\java\\\\com\\\\monitoring\\\\common\\\\util\\\\common.mdb");    
        if (mdbFile.exists()) \{    
            Database dbin = Database.open(mdbFile);    
        
            Table table = dbin.getTable("InfoTable");    
            /\*for (Map<String, Object> map : table) \{  //打印原先该文件中的数据  
                System.out.println(map);    
            \}  \*/  
        \}    
        Database db = Database.create(FileFormat.V2000, mdbFile, true,    
                Charsets.UTF\_16LE, null);    
        Table newTable = new TableBuilder("InfoTable")    
                .addColumn(    
                        new ColumnBuilder("名称").setSQLType(Types.VARCHAR)    
                                .toColumn())    
                .addColumn(    
                        new ColumnBuilder("年龄112").setSQLType(Types.VARCHAR)    
                                .toColumn()).toTable(db);    
        newTable.addRow("2鹏23", "123423");    
        System.out.println(true  
                );  
    \}  
      
    public static void main(String\[\] args) throws Exception \{  
        operator();  
    \}  
\}

maven依赖

1.  <dependency>  
2.      <groupId>org.hsqldb</groupId>  
3.      <artifactId>hsqldb</artifactId>  
4.      <version>2.2.8</version>  
5.      <type>jar</type>  
6.      <optional>false</optional>  
7.  </dependency>  
8.  <dependency>  
9.      <groupId>com.healthmarketscience.jackcess</groupId>  
10.     <artifactId>jackcess</artifactId>  
11.     <version>1.2.14.2</version>  
12.     <type>jar</type>  
13.     <optional>false</optional>  
14. </dependency>