it.ssc.metadata.sql.CreateFieldsFromResultset Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jsr331-ssc Show documentation

This is a JSR331 interface for SSC (Software for the Calculation of the Simplex) is a java library for solving linear programming problems v. 3.0.1. SSC was designed and developed by Stefano Scarioli.

The newest version!

package it.ssc.metadata.sql;

import it.ssc.metadata.FieldInterface;
import it.ssc.metadata.exception.ReadMetadataSqlException;
import it.ssc.metadata.exception.TypeSqlNotSupported;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class CreateFieldsFromResultset extends AbstractCreateFileds {
	private ArrayList list_fields;
	
	public CreateFieldsFromResultset(ResultSet rsmeta, String name_tabella) throws SQLException, TypeSqlNotSupported, ReadMetadataSqlException {
		 list_fields=new ArrayList ();
		 boolean entrato=false;
		 while(rsmeta.next()) 	{
			 entrato=true;
			 String name=rsmeta.getString("COLUMN_NAME").toUpperCase();
			 int size=rsmeta.getInt("COLUMN_SIZE");
			 String type_s_sql=rsmeta.getString("TYPE_NAME");
			 int type_sql=rsmeta.getInt("DATA_TYPE");
			 int scale =rsmeta.getInt("DECIMAL_DIGITS");
			 
			 //System.out.println("medi--> "+name+" "+size + " "+type_sql+ " "+type_s_sql);
			 //System.out.println("medi--> Precision:"+size ); //per i numerici rappresenta la precisione 
			 //System.out.println("medi--> Scale:"+scale); 
			 
			 
			 list_fields.add(createSingleField(name,size,type_sql,type_s_sql,size,scale));
		 }
		 if(!entrato) throw new ReadMetadataSqlException("ERRORE ! Non sono riuscito a leggere i metadati della tabella "+name_tabella +" o nome tabella inesistente");
	}
	public ArrayList getFieldsdCreated() {
		return list_fields;
	}	

}