Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Saturday, December 1, 2007

How to use Table Metadata in java

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>



Using Table Metadata



Using Table Metadata



<%
Connection connection = DriverManager.getConnection(
"jdbc:odbc:data", "userName", "password");

Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from tableName") ;
%>









<% while(resultset.next()){ %>







<% } %>
<%= resultset.getMetaData().getColumnName(1)%> <%= resultset.getMetaData().getColumnName(2)%> <%= resultset.getMetaData().getColumnName(3)%> <%= resultset.getMetaData().getColumnName(4)%> <%= resultset.getMetaData().getColumnName(5)%>
<%= resultset.getString(1) %> <%= resultset.getString(2) %> <%= resultset.getString(3) %> <%= resultset.getString(4) %> <%= resultset.getString(5) %>


No comments: