skip to main | skip to sidebar

Java Programs and Examples with Output

Pages

▼
 
  • RSS
  • Twitter
Wednesday, September 19, 2012

Getting Column Names in Java

Posted by Admin at 9:58 AM – 0 comments
 

This is a reusable code written in Java with a simple User Defined Method. User can just call the methods with the proper inputs and return values.



import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;


public class UserHelper {



private ArrayList getFieldNames(String tableName) throws CCDBException {
  String SchemaName ="OPTUAT";
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  DatabaseMetaData dmd = null;
  ArrayList fieldNames = new ArrayList();
  try {
   conn = DBManager.getConnection();
   dmd = conn.getMetaData();
   rs = dmd.getColumns(null,null,tableName,null);
   while(rs.next()){
    String d = rs.getString(4);
    fieldNames.add(d);
   }
  } catch (Exception e) {
   e.printStackTrace();
  }finally {
  DBManager.cleanUp(rs, stmt, conn);
 }
  return fieldNames;
}

 public static void main(String[] args) throws CCDBException{

 }
}


Leave a Reply

Newer Post Older Post
Subscribe to: Post Comments ( Atom )
  • Popular
  • Recent
  • Archives
Powered by Blogger.
 
 
 
© 2011 Java Programs and Examples with Output | Designs by Web2feel & Fab Themes

Bloggerized by DheTemplate.com - Main Blogger