package training_proj_2;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.InputStreamReader;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLConnection;
import java.util.Map;
import java.util.Scanner;

public class Main {

	public static void main(String[] args) throws MalformedURLException {
		// TODO Auto-generated method stub

		try {

			String urlparam = "";

			 URL url = new URL(urlparam);
	         URLConnection urlConnection = url.openConnection();

	         BufferedReader in = new BufferedReader(
	            new InputStreamReader(urlConnection.getInputStream()));

	         String catch_str = "";
	         String current;

	         int cnt = 0;


	         String driver_classname = "org.gjt.mm.mysql.Driver";
	    	String server_url = "jdbc:mysql://ip address:port number/your database schema name";
	    	String login_id = "";
	    	String login_pw = "";

            java.lang.Class.forName( driver_classname );
        	java.sql.Connection con = java.sql.DriverManager.getConnection( server_url, login_id, login_pw );

        	java.sql.PreparedStatement stmt = null;

        	con.setAutoCommit(true);

        	String insert_str =
        			"insert into schema name.table name " +
        				"( col1, col2, col3, col4 ) values ( " +
        				"?, ?, ?, ? ) ";

        //	System.out.print( insert_str );

	         while((current = in.readLine()) != null) {

	        	 cnt = cnt + 1;

	        	 System.out.println(current);

	        	 if ( cnt < 4 )
	        		 continue;

	        	 String[] parts = current.split(",");

	        	 stmt = con.prepareStatement( insert_str );
	         	 stmt.setString(1, parts[0].trim());
	         	 stmt.setString(2, parts[1].trim());
	         	 stmt.setString(3, parts[2].trim());
	         	 stmt.setString(4, parts[3].trim());

	         	 stmt.execute();

	         }

	         stmt.close();
		     con.close();


	      }catch(Exception e) {
	         e.printStackTrace();

	      }



	}

}