获取数据库表中的字段名和字段描述（用于导出数据为csv文件）

最新推荐文章于 2024-04-07 15:04:33 发布

原创最新推荐文章于 2024-04-07 15:04:33 发布 · 1.7k 阅读

1 ·

CC 4.0 BY-SA版权

本文介绍如何在Java中获取数据库表的字段名及字段描述，以用于数据导出到CSV文件。

import javax.persistence.Column;
import java.util.Comparator;

//@JsonPropertyOrder({“model_type”,“Test_name”})
public class FieldVO{

/**
 * 字段名称
 */
@Column(name = "column_name")
private String columnName;

/**
 * 字段描述
 */
@Column(name = "column_comment")
private String columnComment;

public String getColumnName() {
    if("file_path".equals(columnName) || "otime".equals(columnName) || "operator".equals(columnName)){
        return "";
    }
    if("dd1".equals(columnName)){
        columnName = "D1";
    }else if("dd2".equals(columnName)){
        columnName = "D2";
    }else if("dd3".equals(columnName)){
        columnName = "D3";
    }
    /*else{
        String tmp =columnName.toLowerCase();
        if(tmp.contains("_")){
            String left = tmp.substring(0,tmp.indexOf("_"));
            String right = tmp.substring(tmp.indexOf("_")+1);
            String center1 = right.substring(0,1).toUpperCase();
            String center2 = right.substring(1);
            columnName = left+center1+center2;
        }
    }*/


    return columnName;
}

public void setColumnName(String columnName) {
    this.columnName = columnName;
}

public String getColumnComment() {
    return columnComment;
}

public void setColumnComment(String columnComment) {
    this.columnComment = columnComment;
}

}

获取数据库表中的字段名和字段描述

select column_name,column_comment from information_schema.COLUMNS where TABLE_SCHEMA = (select database()) and TABLE_NAME=#{tableName}