查询Oracle某个表的字段

1、配置实体类

package com.xxx.xxx.pojo;

import java.io.Serializable;

public class TabColumns implements Serializable {
    private static final long serialVersionUID = -6737915816681920801L;
    private String column_name;
    private String data_type;
    private String data_length;
    private String nullable;

    public TabColumns() {
    }

    public String getColumn_name() {
        return this.column_name;
    }

    public void setColumn_name(String column_name) {
        this.column_name = column_name;
    }

    public String getData_type() {
        return this.data_type;
    }

    public void setData_type(String data_type) {
        this.data_type = data_type;
    }

    public String getData_length() {
        return this.data_length;
    }

    public void setData_length(String data_length) {
        this.data_length = data_length;
    }

    public String getNullable() {
        return this.nullable;
    }

    public void setNullable(String nullable) {
        this.nullable = nullable;
    }

    public String toString() {
        return "TabColumns [column_name=" + this.column_name + ", data_type=" + this.data_type + ", data_length=" + this.data_length + ", nullable=" + this.nullable + "]";
    }
}

2、DAO层

package com.xxx.xxx.dao.oracle;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.xxx.xxx.pojo.TabColumns;

@Mapper
public interface QueryTabColumnsDao {

    @Select("select column_name,data_type ,data_length,nullable from all_tab_columns where table_name = #{tableName} AND OWNER = 'xxxxxDATA'")
    List<TabColumns> queryTabColumns(String tableName);

}