/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package test2;

import java.util.Vector;
import java.awt.Color;
import java.awt.Image;
import java.awt.image.BufferedImage;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.imageio.ImageIO;
import javax.swing.ImageIcon;

/**
 *
 * @author Pieter-Jan Bijnens
 *
 * Type 12 = Varchar(255)
 * Type 4 = Int(255)
 * Type -4 = LongBlob
 */
public class Data {
    FlexData flex;
    Vector mijnData=new Vector();
    Vector mijnKolommen =new Vector();
    //public Vector dataToTransfer;

    public Data() throws Exception{
        this.flex = new FlexData();
    }
    public Vector getMijnKolommen(){
        return  mijnKolommen;
    }
    public String getID(int rij){
        Vector huidigerij=(Vector)mijnData.elementAt(rij);
        int id= (int)(huidigerij.elementAt(0));
         return id+"";

    }

    public void DataMaken() throws Exception
    {
        ResultSet rs = flex.getTableData();
        ResultSetMetaData meta = rs.getMetaData();
        flex.getMetaData();
        System.out.println("Aantal Columns/Rows succesvol opgehaald");

        int aantalKolommen = (flex.aantalColumns);
        int aantalRows = (flex.aantalRows);

        for(int i = 1; i < meta.getColumnCount() + 1;i++) {
            mijnKolommen.addElement(meta.getColumnName(i));
        }

        while(rs.next()){
            Vector rij = new Vector();
            for(int i = 1; i < meta.getColumnCount() + 1; i++) {
                System.out.println("KolomType: " + meta.getColumnType(i));
                switch(meta.getColumnType(i)) {
                    case 12:
                        rij.addElement(rs.getString(i) == null ? "": rs.getString(i));
                        break;
                    case 4:
                        rij.addElement(rs.getInt(i));
                        break;
                    case -4:
                        if(rs.getBlob(i) != null) {
                            java.sql.Blob blob = rs.getBlob(i);
                            InputStream in = blob.getBinaryStream();
                            BufferedImage image = ImageIO.read(in);
                            Foto f = new Foto(image, null);
                            rij.addElement(f);
                        } else {
                            rij.addElement(new Foto(null));
                        }
                        break;
                    case 1:
                        String ColorData = rs.getString(i);
                        rij.addElement(Color.decode(ColorData));

                }
            }
            mijnData.addElement(rij);
        }
        System.out.println("Database succesvol uitgelezen!");
        //this.dataToTransfer = mijnData;

    }
    int addRecord() throws Exception
    {
       Vector mijnRij=new Vector();
        mijnData.addElement(mijnRij);
        try {
        ResultSet rs = flex.getTableData();
        ResultSetMetaData meta = rs.getMetaData();
        rs.next();
        for(int i = 1; i < meta.getColumnCount() + 1; i++) {
                //System.out.println(meta.getColumnType(i));
                switch(meta.getColumnType(i)) {
                    case 12:
                        mijnRij.addElement("");
                        break;
                    case 4:
                        mijnRij.addElement(0);
                        break;
                    case -4:
                        Image image = new ImageIcon(this.getClass().getResource("/images/41.jpg")).getImage();
                        mijnRij.addElement(new Foto(image,null));
                        break;
                    case 1:
                        mijnRij.addElement(Color.RED);
                        break;
                }
            }
        } catch (Exception e) {

        }
        return mijnData.size();

    }

    Object mijnData(Vector vector) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

}