Hi friend,
1. First import the java packages
import java.sql.*;
2. Loading a database driver
String driver = "com.mysql.jdbc.Driver";
3.Creating a jdbc Connection
String url = "jdbc:
mysql://localhost:3306/";;
String username = "root";
String password = "root";
String dbName= "dbname";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url+dbName, username, password);
4. Creating a jdbc Statement object
Statement st = conn.createStatement();
5. Executing a statement with the Statement object, and returning a jdbc resultSet
ResultSet rs = st.executeQuery("SELECT * FROM tablename");
6. ResultSet has method getMetaData() which returns the ResultSet MetaData object which provides
meta information of the result set.
ResultSetMetaData rsmd = rs.getMetaData();
7. getColumnCount() method on ResultSetMetaData object returns the number of columns
for the result set returned from the query.
int totalCol=rsmd.getColumnCount();
System.out.println("Number of Columns="+totalCol);
8. getTableName() method on ResultSetMetaData object returns the name of table.
System.out.println("Table Name = " + rsmd.getTableName(int column));
9. getColumnName() method on ResultSetMetaData object returns the name of column table.
and getString(int column) method returns the value of column table.
while(rs.next())
{
for(int i=1;i<=totalCol;i++)
{
System.out.println("Column Name" +rsmd.getColumnName(i));
System.out.println("Field Value " + rs.getString(i));
}
}
For read more information :
http://www.roseindia.net/jdbc/get-column-count-using-result-set.shtmlThanks.