Java获取MYSQL表的列名

最新推荐文章于 2023-06-06 10:14:22 发布

凭阑偏偏

最新推荐文章于 2023-06-06 10:14:22 发布

阅读量942

点赞数 1

分类专栏： JAVA 文章标签： mysql java 获取列名，mysql，java

本文链接：https://blog.csdn.net/yliyp/article/details/106442701

版权

JAVA 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

  /**
     * @use 获取某张表的列名
     * @return ArrayList
     */
    public ArrayList<String> getColumnNames(){
        ArrayList<String> tableNames = null;
        Connection con = null;
        Statement stmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql:///library", "root", "root");
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT *FROM library.book");
            ResultSetMetaData rsmd = rs.getMetaData();
            int count = rsmd.getColumnCount();
            tableNames = new ArrayList<String>(count);
            for(int i=0;i<count;i++){
                tableNames.add(rsmd.getColumnName(i + 1));
               // System.out.println(tableNames.get(i));
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return tableNames;
    }