| gvSIG desktop 1

package org.gvsig.remoteservices.conf.mapserver.test;

import java.io.DataInputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileWriter;

import java.io.IOException;

import java.util.Vector;

public class DDF2postgres{

	public static void main(String[] args){

		String path="/home/david/pruebas";

		String squema="";

		File f=new File(path);

		File sql=null;

		DataInputStream read = null;

		FileWriter write = null;

		File aux[]=f.listFiles();

		int i;

		sql=new File(path+"/sql");

		sql.deleteOnExit();

		sql.mkdir();

		for(i=0;i<aux.length;i++){

			Vector data=new Vector();

			String s3=null;

			int contd=0;

			int contf=0;

			sql=new File(path+"/"+"sql/"+aux[i].getName().split(".ddf")[0]+".sql");

			String table=sql.getName().split(".sql")[0];

			System.out.println(table);

			System.out.println(sql.getName());

			try{

				read = new DataInputStream(new FileInputStream(aux[i]));

				write = new FileWriter(sql);

				String s=read.readLine();

				String s2[]=null;

				if(args[0]==null){

					s3="INSERT INTO "+table.toLowerCase()+"(";

				}

				else{

					s3="INSERT INTO "+args[0]+"."+table.toLowerCase()+"(";

				}

				String s4="";

				String s5=null;

				while(s.compareTo("[FIELDS]")!=0){

					s=read.readLine();

				}

				s=read.readLine();

				while(s.compareTo("")!=0){

					s2=s.split(",");

					contd++;

					data.addElement(s2[0]);

					System.out.println(s2[0]);

					s=read.readLine();

				}

				s4=s3;

				int j;

				for(j=0;j<data.size()-1;j++){

					s4=s4+data.elementAt(j)+",";

				}

				s4=s4+data.elementAt(data.size()-1)+") VALUES(";

				while(s.compareTo("[DATA]")!=0){

					s=read.readLine();

				}

				s=read.readLine();

				s5=s4;

				while(s!=null){

					s2=s.split("\t");

					contf=s2.length;

					int k;

					write.write(s5);

					for(k=0;k<s2.length-1;k++){

						if(s2[k].compareTo("")==0){

							write.write("null,");

							System.out.print(s2[k]);

						}

						else{

							write.write("\'"+s2[k]+"\',");

							System.out.print(s2[k]);

						}

					}

					write.write("\'"+s2[s2.length-1]+"\'");

					if(contd-contf>0){

						int l;

						write.write(",");

						for(l=0;l<(contd-contf)-1;l++){

							write.write("null,");

						}

						write.write("null");

					}

					write.write(");\n");

					System.out.println();

					s=read.readLine();

					if(s!=null){

						if(s.compareTo("")==0){

							s=read.readLine();

						}

					}

				}

				write.close();

			}

			catch(FileNotFoundException e1){

				System.out.println("File not found.");

			}

			catch(IOException e){

				System.out.println("I/O error.");

			}

		}

	}

}