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;

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 | |
Have Questions? Post them here!
- Create a Zip file using Java Code programmatically
- Eclipse : A java Runtime Environment (JRE) or Java Development kit (JDK) must be available
- How to Sort a LinkedList in Java
- Loading class com.mysql.jdbc.Driver. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver
- How to declare and initialize Array in Java Programming
- [Fix] java: integer number too large compilation error
- Java JDBC Connection with MySQL Driver in VS Code + Troubleshooting
- Reading .xls and .xlsx Excel file using Apache POI Java Library
- IntelliJ: Error: Could not find or load main class, java.lang.ClassNotFoundException
- How to get Client IP address using Java Code Example
- Truncate table using Java JDBC Example
- Struts 2 : There is no Action mapped for namespace [/] and action name [form] associated with context path [/proj]
- How to get file path in Idea IntelliJ IDE
- Java Generics explained with simple definition and examples
- Java SE 8 Update 301 available with various bug fixes and security improvements
- Java: Collect Stream as ArrayList or LinkedList
- Java JDBC Connection with PostgreSQL Driver Example
- How to check if Java main thread is alive
- How to fix Java nio NoSuchFileException wile reading a file
- Java 8+ get Day of the Week Examples with LocalDateTime, DateTime, ZonalDateTime and Instant classes
- Ways to Convert Integer or int to Long in Java
- [Java] How to throws Exception using Functional Interface and Lambda code
- [Fix] Spring Boot: mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
- Java: The value of the local variable string is not used
- Java JDBC: Insert Java 8 LocalDate and Time using PreparedStatement
- Power BI error Something went wrong, unable to read the application metadata - Microsoft
- How to open new tabs macOS Terminal - MacOS
- Read a file line by line in Python Program - Python
- How to Insert an Inverted Question Mark on Mac ¿ - MacOS
- Center Align TextView Android Horizontally or Vertically - Android
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix] - MySQL
- How to know the version of OpenSSL - HowTos
- Python print() function without a newline using the end parameter - Python