Get Desc of Table using Java JDBC


If you want to get the desc (description) of a table using Java JDBC, you can do that by running a Statment query,

Query:
desc students;
Desc Table Query
Java Code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;


public class JDBCTableDescExample {
    
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        String url ="jdbc:mysql://localhost:3306/my_uat";
        String userName="root";
        String password ="root123";
        String insertQuery ="desc students";
        Connection connection = DriverManager.getConnection(url,userName,password);
        PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
        ResultSet rs = preparedStatement.executeQuery();
    
        ResultSetMetaData resultSetMetaData = rs.getMetaData();
        int colCount = resultSetMetaData.getColumnCount();

        for(int i=1;i<=colCount;i++) {
            System.out.print(resultSetMetaData.getColumnName(i)+"\t |");
        }
        System.out.println("");
        while(rs.next()) {
        for(int i=1;i<=colCount;i++) {
            System.out.print(rs.getString(i)+"\t |");
            
        }
        System.out.println("");
    }
    }
}
Output:
Field           |Type                |Null   |Key    |Default        |Extra                     |
student_id       |int                   |NO     |PRI    |null              |auto_increment         |
student_name     |varchar(45)    |NO     |         |null             |       |
student_dob       |datetime          |NO     |PRI   |null             |       |
student_address |varchar(45)    |NO     |         |null             |       |
-

Facing issues? Have Questions? Post them here! I am happy to answer!


Author Info:

Rakesh (He/Him) is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap