My SQL获取某个表的列名

最新推荐文章于 2024-09-09 15:24:07 发布

ithouse

最新推荐文章于 2024-09-09 15:24:07 发布

阅读量1.5w

点赞数 1

分类专栏：数据库文章标签： mysql列 mysql获取列数据库查询列 mysql查询列 mysql列数据

数据库专栏收录该内容

5 篇文章 0 订阅

订阅专栏

MySQL取得一个表的列名方法为：
DESCRIBE TableName

缩写为：
DESC TableName

SHOW COLUMNS FROM TableName

select COLUMN_NAME from information_schema.columns where table_name='TableName'

也可以实现相同的功能

实战：

package com.ms.onlineexcel.dao.impl;

import com.ms.onlineexcel.dao.IExcelDao;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.*;

/**
 * Created by lenovo on 2014/8/23.
 */
@Repository("excelDao")
public class ExcelDao implements IExcelDao {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public List<String> getStudentData() {
        Session session;
        try {
            session = sessionFactory.getCurrentSession();
        } catch (Exception e) {
            session = sessionFactory.openSession();
        }
        String getColumnSql = "SELECT COLUMN_NAME FROM information_schema.columns WHERE table_name='studentdata'";
        List<String> excelColumnList = session.createSQLQuery(getColumnSql).list();

       /* String getStudentDataSql = "SELECT * FROM studentdata";
        List<Map<Object,Object>> studentDataList = session.createSQLQuery(getStudentDataSql).list();
        另外开一个类来取。
        */

        return excelColumnList;
    }
}