DBF菜单驱动程序：LibraryDatabaseProject

本程序已经上传到GitHub：https://github.com/ztreble/LibraryDatabaseProject

说明

菜单驱动程序，实现效果如下图，也就是对于DBF文件的增删改查。第一可以练习JAVA文件操作，第二可以练习集合类的使用，第三可以学学JAVA DBF。
DBF是可以用EXCEL打开的一种古老的关系型数据库，或许可以用于快速的数据处理？
总的来说还是没什么用，超过三个小时就是浪费时间。

需求

把需求放上来，基本上实现了，但是那个#号操作不会弄。好像需要JAVA Robot 定义鼠标事件。具体参考StackOveflow

代码

因为javadbf包没有提供DBF删除的操作，所以使用file.delete+createTable(String tablename,DBFField[] fields,List<String> fieldsList,List<String> outList,int del)来完成修改的操作。
值得注意的是，不要对一个文件同时执行OutputStream与InputStream的打开操作。这样会导致文件损坏。

package domain;
import com.linuxense.javadbf.*;

import java.io.*;
import java.util.*;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import com.linuxense.javadbf.DBFField;
import com.linuxense.javadbf.DBFReader;
import com.linuxense.javadbf.DBFWriter;


public class TableOperation {
    public static void createTable(){
        String tablename;
        LinkedHashMap<String,Integer> map = new LinkedHashMap<String,Integer>();
        Scanner scanner = new Scanner(System.in);
        System.out.print("\tenter table name:");
        tablename = scanner.nextLine();
        DBFWriter writer=null;
        while(true){
            String name;
            int length;
            System.out.print("\tenter column name and its length(quit by type -1):");
            name = scanner.next();
            if(name.equals("-1")) break;
            length = scanner.nextInt();
            map.put(name,length);
        }

        if(!tablename.equals("")){
            String path = "D:\\dbFiles\\"+tablename+".dbf";
            File file = new File(path);

            try{
                if(!file.exists())
                    file.createNewFile();
                DBFField[] fields = new DBFField[map.size()];
                Iterator iterator = map.entrySet().iterator();
                int i=0;
                while(iterator.hasNext()){
                    Map.Entry<String,Integer> entry = (Map.Entry<String,Integer>)iterator.next();
                    fields[i] = new DBFField();
                    fields[i].setName(entry.getKey());
                    int tmp = entry.getValue();
                    fields[i].setType(DBFDataType.CHARACTER);
                    fields[i].setLength(tmp);
                    i++;
                }
                writer = new DBFWriter(file);
                writer.setFields(fields);

                System.out.println("The dbf file product success!");
            }catch (IOException e) {
                System.out.println("The dbf file product failed!");
                e.printStackTrace();
            }finally {
                DBFUtils.close(writer);
            }
        }
    }
    public static void insert(){
        File f;
        Scanner scanner = new Scanner(System.in);
        String filename;
        OutputStream fos=null;
        InputStream fis =null;
        DBFReader reader  =null;
        DBFWriter writer =null;

        while(true){
            System.out.print("\tenter file name:");
            filename = scanner.next();
            filename = "d:\\dbFiles\\"+filename+".dbf";
            f = new File(filename);
            if(f.exists()) break;
            else System.out.println("\tPlease type right filename!");
        }


        try {
            boolean mark = true;
            List<String> fieldsList = new ArrayList<>();
            fis = new FileInputStream(filename);
            reader  = new DBFReader(fis);
            int fieldsCount = reader.getFieldCount();
            for(int i=0;i<fieldsCount;i++){
                fieldsList.add(reader.getField(i).getName());
            }

            DBFUtils.close(reader);
            fis.close();

            writer = new DBFWriter(new File(filename));

            do{
                Object[] rowData = new Object[fieldsCount];
                String tmpString = null;
                for(int i=0;i<fieldsCount;i++){
                    System.out.printf("\t"+fieldsList.get(i)+":");
                    tmpString = scanner.next();
                    rowData[i] = tmpString;
                }
                writer.addRecord(rowData);
                while(true){
                    System.out.printf("\tMore entries (Y/n):");
                    tmpString = scanner.next();
                    if(tmpString.equals("Y")||tmpString.equals("y")){
                        break;
                    }
                    else if(tmpString.equals("n")||tmpString.equals("N")){
                        mark = false;
                        break;
                    }
                    else{
                        System.out.println("\tYour Type wrong!");
                    }
                }

            }while(mark);
            writer.write();
            DBFUtils.close(writer);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
        }
    }


    public static void createTable(String tablename,DBFField[] fields,List<String> fieldsList,List<String> outList,int del){

        File file = new File(tablename);
        DBFWriter writer=null;
        writer = new DBFWriter(new File(tablename));
        writer.setFields(fields);
        DBFUtils.close(writer);
        writer = new DBFWriter(new File(tablename));
        Object[] rowData = new Object[fieldsList.size()];
        for(int i=0;i<outList.size()/fieldsList.size();i++){
            if(i==del) continue;
            for(int j=0;j<fieldsList.size();j++){
                rowData[j]=outList.get(i*fieldsList.size()+j);
            }
            writer.addRecord(rowData);
        }
        writer.write();
}
    public static void remove() {
        File f;
        Scanner scanner = new Scanner(System.in);
        String filename;
        OutputStream fos=null;
        InputStream fis =null;
        DBFReader reader  =null;
        DBFWriter writer =null;

        while(true){
            System.out.print("\tenter file name:");
            filename = scanner.next();
            filename = "d:\\dbFiles\\"+filename+".dbf";
            f = new File(filename);
            if(f.exists()) break;
            else System.out.println("\tPlease type right filename!");
        }

        while(true){
            print(filename);
            System.out.print("Please enter the number of lines to delete(quit by type -1):");
            int num = scanner.nextInt();

            if(num==-1) break;

            else try {
                List<String> fieldsList = new ArrayList<>();
                List<String> outList = new ArrayList<>();
                fis = new FileInputStream(filename);

                reader  = new DBFReader(fis);
                int fieldsCount = reader.getFieldCount();
                DBFField[] fields = new DBFField[fieldsCount];
                for(int i=0;i<fieldsCount;i++){
                    fields[i]=reader.getField(i);
                    fieldsList.add(reader.getField(i).getName());
                }
                Object[] rowValues;
                while ((rowValues = reader.nextRecord()) != null) {
                    for (int i = 0; i < rowValues.length; i++) {
                        outList.add((String) rowValues[i]);
                    }
                }
                DBFUtils.close(reader);
                fis.close();
                f.delete();

                createTable(filename,fields,fieldsList,outList,num-1);

            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
            }
        }



    }
    public static void print(String filename) {

        InputStream fis = null;
        try {
            fis = new FileInputStream(filename);
            DBFReader reader = new DBFReader(fis);
            int fieldsCount = reader.getFieldCount();
            System.out.printf("#\t");
            for (int i = 0; i < fieldsCount; i++) {
                DBFField field = reader.getField(i);
                System.out.print(" "+field.getName());
            }
            System.out.println("");
            Object[] rowValues;
            int  j=1;
            while ((rowValues = reader.nextRecord()) != null) {
                System.out.printf("#"+j+"\t");
                j++;
                for (int i = 0; i < rowValues.length; i++) {
                    System.out.print(" "+rowValues[i]);
                }
                System.out.println("");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                fis.close();
            } catch (Exception e) {
            }
        }

    }
}