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

class FillDatabase
{
	private String line;
	private BufferedReader reader;
	private BufferedWriter writer;

	public FillDatabase()
	{
		String phonenumber, name, address, zipcode, city;
		int customerID = 1;

		String newline;

		try
		{
			reader = new BufferedReader(new FileReader("zeist.csv"));
			writer = new BufferedWriter(new FileWriter("zeist.sql"));

			while((line = reader.readLine()) != null)
			{
				StringTokenizer st = new StringTokenizer(line, ",");
				phonenumber = st.nextToken();
				name 		= st.nextToken();
				address 	= st.nextToken();
				zipcode 	= st.nextToken();
				city 		= st.nextToken();
				newline 	= "INSERT INTO customers(cus_id, cus_name, cus_address, cus_zipcode, cus_city)"
				+ " VALUES ("
				+ customerID++ + ", " + name + ", " + address + ", " + zipcode + ", " + city
				+ ");";

				writer.write(newline);
				writer.newLine();
				writer.flush();
			}
			reader.close();
			writer.close();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
	}
	public static void main(String args[])
	{
			FillDatabase fillDB = new FillDatabase();
	}
}

#include <algorithm>
#include <iostream>
#include <iterator>
#include <string>
#include <vector>

using namespace std;

vector<string> csv_parse ( const string& s );

int main()
{
  string line ( "\"1\",868000,3917200,\"(868000.0,3917200.0)\"" );

  cout<<"Original line: "<< line <<'\n';
  cout<<"CSV separated line:\n";

  vector<string> v = csv_parse ( line );

  copy ( v.begin(), v.end(), ostream_iterator<string> ( cout, "\n" ) );
}

vector<string> csv_parse ( const string& s )
{
  string::const_iterator first = s.begin();
  string::const_iterator last = s.end();
  vector<string> v;
  string field;

  while ( first != last ) {
    switch ( *first ) {
    case ',':
      v.push_back ( field );
      field.clear();
      break;
    case '"':
      while ( ++first != last && *first != '"' )
        field.push_back ( *first );
      break;
    default:
      field.push_back ( *first );
      break;
    }

    ++first;
  }

  if ( field != "" )
    v.push_back ( field );

  return v;
}