|
|
| java |
Expert:srikala
i need output as tablename;coloumn1;coloumn2,;coloumn3,fieldvalue1,fieldvalue2,and so on.
please tel me the javacode for this using resultset metadata |
| Answers |
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.shtml
Thanks.
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
