try {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con = DriverManager.getConnection("jdbc:odbc:database");
}Catch (Exception ex) {}

try {
     Statement stmt = con.createStatement();
     ResultSet rs = stmt.executeQuery("select * from table");
     while(rs.next()) {
          String thedata = rs.getString("columnname");
     }
}catch (Exception exc) {}

/*	DSN.java
*/

import java.io.*;
import java.util.*;

/**	Produces lists of User DSNs and System DSNs.
*	Warning: This program will only function on a Windows Platform 
*	since ODBC DSN lists are Windows operating system specific.
*/
public class DSN{
	
	
	private String userDSNCommand = "regedit /e "  
		+ "\"c:\\temp1.reg\" " 
		+ "\"HKEY_CURRENT_USER\\Software\\ODBC\\ODBC.INI\\ODBC Data Sources\" ";
	
	private String systemDSNCommand = "regedit /e " 
		+ "\"c:\\temp2.reg\" " 
		+ "\"HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBC.INI\\ODBC Data Sources\" ";
	
	private boolean debug = false;
		
	
	/** Instantiates a class and runs the commands passed in the aguments.
	*/
	public static void main(String[] args){
		DSN dsn = new DSN();
		Vector userDSNList = dsn.getUserDSNList();
		ListIterator userIterator = userDSNList.listIterator();
		System.out.println("User DSN List");
		while (userIterator.hasNext()){
			System.out.println((String)userIterator.next());
		}
		Vector systemDSNList = dsn.getSystemDSNList();
		ListIterator systemIterator = systemDSNList.listIterator();
		System.out.println("System DSN List");
		while (systemIterator.hasNext()){
			System.out.println((String)systemIterator.next());
		}
	}

	public Vector getUserDSNList(){
		runCommand(userDSNCommand.split(" "));
		Vector dsnList = new Vector();
		try{
			FileReader fr = new FileReader("c:\\temp1.reg");
			BufferedReader br = new BufferedReader(fr);
			String lineRead = "";
			while ((lineRead = br.readLine()) != null){
				if (lineRead.indexOf("=") > 0){
					/*	Extract the key portion of a string which looks like: 
					*	"Demo"="Microsoft Access Driver (*.mdb)" 
					*	This would extract the string Demo from the above.
					*/
					String key = lineRead.substring(1,lineRead.indexOf("\"", 1));
					dsnList.add(key);
				}
			}
		}catch(FileNotFoundException fnfe){
			System.err.println("FileNotFoundException: " + fnfe.getMessage());
		}catch(IOException ioe){
			System.err.println("IOException: " + ioe.getMessage());
		}
		return dsnList;
	}
	
	public Vector getSystemDSNList(){
		runCommand(systemDSNCommand.split(" "));
		Vector dsnList = new Vector();
		try{
			FileReader fr = new FileReader("c:\\temp2.reg");
			BufferedReader br = new BufferedReader(fr);
			String lineRead = "";
			while ((lineRead = br.readLine()) != null){
				if (lineRead.indexOf("=") > 0){
					/*	Extract the key portion of a string which looks like: 
					*	"Demo"="Microsoft Access Driver (*.mdb)" 
					*	This would extract the string Demo from the above.
					*/
					String key = lineRead.substring(1,lineRead.indexOf("\"", 1));
					dsnList.add(key);
				}
			}
		}catch(FileNotFoundException fnfe){
			System.err.println("FileNotFoundException: " + fnfe.getMessage());
		}catch(IOException ioe){
			System.err.println("IOException: " + ioe.getMessage());
		}
		return dsnList;
	}

	/**	Runs the commands in a process and displays the results.
	*/
	public void runCommand(String[] args){
		int number = args.length;
		try{
			String[] commands;
			String operatingsystem = System.getProperty("os.name");
			if (operatingsystem.toLowerCase().indexOf("windows") > 0){
				commands = new String[number + 2];
				commands[0] = "command.com"; //for Windows 95, 98, ME. etc.
				if (operatingsystem.toLowerCase().indexOf("nt") > 0){
					commands[0] = "cmd.exe"; //for Windows NT
				}
				commands[1] = "/c";
				for (int i = 0; i < number;i++){
					commands[i+2] = args[i];
				}
			}else{
				commands = new String[number];
				for (int i = 0; i < number;i++){
					commands[i] = args[i];
				}
				System.err.println("Microsoft Windows required.");
				System.exit(1);
				
			} 

			if (debug) System.out.print("Executing: ");
			for (int i = 0; i< commands.length;i++){
				 if (debug) System.out.print(commands[i] + " ");
			}
			if (debug) System.out.println();
			
			Runtime runtime = Runtime.getRuntime();
			Process process = runtime.exec(commands);
			// Because some native platforms only provide limited buffer size 
			// for standard input and output streams, failure to promptly write 
			// the input stream or read the output stream of the subprocess 
			// may cause the subprocess to block, and even deadlock.
			CheckStream csin = new CheckStream(process.getInputStream());
			CheckStream cserr = new CheckStream(process.getErrorStream());
			csin.start();
			cserr.start();
			
			if (debug) System.out.println("Waiting for command process to terminate...");
			int done = process.waitFor();
			if (done == 0){
				if (debug) System.out.println("Process terminated normally."); 
			}else{
				if (debug) System.out.println("Process terminated abnormally."); 
			}
			process.destroy();
               if (debug) System.out.println("... Done.");      
		}catch(InterruptedException ie){
            	System.err.println("InterruptedException: " + ie.getMessage());
		}catch(IOException ioe){
			System.err.println("IOException: " + ioe.getMessage());
		}
	}

	/**	Inner class for checking the results if any of an InputStream.
	*/
	class CheckStream extends Thread{

		BufferedReader br;
		String lineread = "";

		/** 	Constructor needs an InputStream to form an anonymous 
		*	InputStreamReader which is used to create a BufferedReader
		*	for reading the stream. 
		*/
		CheckStream(InputStream is){
			this.br = new BufferedReader(new InputStreamReader(is));		
		}

		/**	Reads the input stream and displays anything returned.
		*/
		public void run(){
			try{
				while ((lineread = br.readLine()) != null){
					if (debug) System.out.println(lineread);
				}
			}catch(IOException ioe){
				System.err.println("IOException: " + ioe.getMessage());
			}
		}
	}
}

void ShowDataSources()
{
   const int lenny = 255;
   char text[1024*16] = "Data Sources:\n";
 
   char serverName[lenny+1];
   int  serverNameLength = 0;
   char description[lenny+1];
   int  descriptionLength = 0;
 
   SQLHENV env;
   SQLAllocEnv( &env );
   SQLRETURN sqlRet = 0;
   sqlRet = SQLDataSources( env,
                            SQL_FETCH_FIRST,
                            (SQLCHAR *)serverName, 
                            lenny,  
                            (SQLSMALLINT *)&serverNameLength,                             
                            (SQLCHAR *)description, 
                            lenny, 
                            (SQLSMALLINT *)&descriptionLength );
 
   switch( sqlRet )
   {
      case SQL_SUCCESS:
         strcat( text, "SQL_SUCCESS!\n" );
         break;
      case SQL_SUCCESS_WITH_INFO:
         strcat( text, "SQL_SUCCESS_WITH_INFO!\n" );
         break;
      case SQL_NO_DATA:
         strcat( text, "SQL_NO_DATA!\n" );
         break;
      case SQL_ERROR:
         strcat( text, "SQL_ERROR!\n" );
         break;
      case SQL_INVALID_HANDLE:
         strcat( text, "SQL_INVALID_HANDLE!\n" );
         break;
      default:
         strcat( text, "Unknown return value!\n" );
         break;
   }
 
   while( sqlRet == SQL_SUCCESS || sqlRet == SQL_SUCCESS_WITH_INFO )
   {
      strcat( text, "\nServer Name: " );
      strcat( text, serverName );
      strcat( text, "\nDescription: " );
      strcat( text, description );
 
      sqlRet = SQLDataSources( env, 
                               SQL_FETCH_NEXT, 
                               (SQLCHAR *)serverName, 
                               lenny,  
                               (SQLSMALLINT *)&serverNameLength, 
                               (SQLCHAR *)description,
                               lenny,
                               (SQLSMALLINT *)&descriptionLength );
   }
 
   MessageBox( NULL, text, "ODBC Info", MB_OK );
}