欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

java解析dbf文件,java解析dbf,/** * 解析

来源: javaer 分享于  点击 46897 次 点评:173

java解析dbf文件,java解析dbf,/** * 解析


/**     * 解析DBF文件     * @param in     * @return List<Map<String,String>> columns通过AMF编码之后的字符串     * @throws Exception     */    public static String parseDbf2Map(InputStream in)throws Exception {        DBFReader dbfreader = new DBFReader(in);        dbfreader.setCharactersetName("GB2312");        List<Map<String,String>> columns = new ArrayList<Map<String,String>>();        Map<String,String> head = new HashMap<String,String>();        //解析DBF表头的信息        Map dataType = new HashedMap();        for(int i = 0; i < dbfreader.getFieldCount(); i++) {            DBFField field = dbfreader.getField(i);            byte type = field.getDataType();            int decimal = 0;            int length = 0;            String formatString = "";            if(DBFField.FIELD_TYPE_N == type || DBFField.FIELD_TYPE_F == type){                 decimal = field.getDecimalCount();                 length = field.getFieldLength();                 for (int j = 0; j < (length - decimal); j++) {                     formatString +="#";                 }                 if(decimal != 0){                     formatString = formatString + "0.";                 }                 for (int jj = 0; jj < decimal; jj++) {                     formatString +="0";                }                 dataType.put(""+i, formatString);            }            if(DBFField.FIELD_TYPE_D == type){                formatString = "yyyy/MM/dd";                dataType.put(""+i, formatString);            }            String name = field.getName();            head.put(""+i, name);        }        columns.add(head);        Object[] rowObj = null;        int k = 1;        while ((rowObj = dbfreader.nextRecord()) != null) {            Map<String,String> data = new HashMap<String,String>();            for (int i = 0; i < rowObj.length; i++) {                Object temp = rowObj[i];                String dataTypeFormat = (String)dataType.get(""+i);                if(dataTypeFormat != null){                    if(dataTypeFormat.indexOf("yyyy") !=-1){                        SimpleDateFormat format = new SimpleDateFormat(dataTypeFormat);                        temp = format.format((Date)temp);                    }else {                        DecimalFormat format = new DecimalFormat(dataTypeFormat);                        temp = format.format(temp);                    }                }                data.put(dbfreader.getField(i).getName(), temp.toString());            }            columns.add(data);            k++;        }        //编码:        AmfSerializer amfSerializer = new AmfSerializer();        String str = amfSerializer.toAmf(columns);        return str;    }//该片段来自于http://byrx.net
相关栏目:

用户点评