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