problem in insert mulpitle rows

[chain singh]

Hello

i am inserting multiple row in sqlserver. this query return in a text file
i have to separately insert each row so i have to tokenize the data from query

please help me to tokenize the query which is following

insert into Employee values
('chain','singh','bika.gmailll'),
('chain','singh','bikaccccc.gmailll');


and i wanted by code to make

insert into Employee values ('chain','singh','bika.gmailll')
insert into Employee values ('chain','singh','bikaccccc.gmailll')

[Eduardo Moranchel]

actually you only need a lot of string parsing.
But here it is how you usually do this:

		String incrediblyComplexInsert = "insert into Employee values\n"
				+ "('chain','singh','bika.gmailll'),\n"
				+ "('chain','singh','bikaccccc.gmailll');\n";

		// we usually get this data from a stream or a reader so shall it be
		BufferedReader reader = new BufferedReader(new StringReader(
				incrediblyComplexInsert));
		String line = reader.readLine();
		String currentTableInsert = "";
		while (line != null) {
			line = line.trim(); // remove spaces just in case...
			if (!line.equals("")) { // the line is not empty
				if (line.startsWith("insert")) {
					currentTableInsert = line;
				} else {
					String doInsertWith = currentTableInsert;
					// The line minus the last , or ;
					doInsertWith += line.substring(0, line.length() - 1);
					doInsertWith += ";";
					System.out.println(doInsertWith);
				}
			}
			line = reader.readLine();
		}
		reader.close();

is not the best code (i know) but should point you in the right direction
Also where the system.out.println is is where you need yo add the string to a collection to return it or call directly the insert in the jdbc.