/*
 * Created on 29-Apr-2010
 *
 * TODO 
 */
package uk.ac.roe.wfau;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Vector;

/**
 * @author mar
 *
 */
public class UserDB {

    public static boolean [] getDuplicates(ResultSetMetaData rsmd) throws SQLException {
        //Hashtable ht=new Hashtable();
        Vector ht=new Vector();
        
        boolean [] isDuplicate = new boolean [rsmd.getColumnCount()];
        for (int i=0;i < rsmd.getColumnCount();i++) {
            if (!ht.contains(rsmd.getColumnName(i+1).toLowerCase())) {
                ht.add(rsmd.getColumnName(i+1).toLowerCase());
                isDuplicate[i]=false;
            }
            else {
                isDuplicate[i]=true;
            }
          
        }
        return isDuplicate;
    }
    public static void main(String[] args) {
        Connection conn=null;
        try {
            Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");
           Class.forName("net.sourceforge.jtds.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            System.out.println ("Could not load the driver");
        }
        try {
            String durl="jdbc:jtds:sqlserver://ifa33p:1433/" + "ukidssdr1plus"+";user="+"wsaro"+";password="+"wsaropw";
         conn = DriverManager.getConnection(durl);
         Statement stmt=conn.createStatement();
         ResultSet rs= stmt.executeQuery("select top 1 rabase,multiframeid,decbase,multiframeid,multiframeid,multiframeid from multiframe as m ");
         ResultSetMetaData rsmd=rs.getMetaData();
         boolean [] isR=getDuplicates(rsmd);
         for (int i=0;  i<rsmd.getColumnCount();i++) {
             System.out.println(rsmd.getColumnName(i+1)+":"+isR[i]);
         }
         System.out.println("DONE");
         
        }
        catch (Exception e) {
            
        }
    }
        
}