I am ignoring views/procedures from db.sql file by appending "-- " if condition found true.But views/procedures usually take many lines of code.
After this condition true i have to ignore all respective lines till i found ";" in end of the view/procedure.

SO i have written some code please modify this if someone can to achive the target.

try {

// open the file for reading

FileReader inputstream = new FileReader (sqlFileName);

BufferedReader rdr = new BufferedReader( inputstream );



// the StringBuilder which stores the processed lines

StringBuffer dataLines = new StringBuffer();



// read the file line by line

String dataLine;

while( ( dataLine = rdr.readLine() ) != null ) {



// split the input data into words upto first 3 words only

String[] tokens = dataLine.split( " ", 3 );



// if the line starts with 'create' and a 'view' follows it,

// then add a "--" to the beginning of the line

if( tokens[ 0 ].equalsIgnoreCase( "create" ) &&

tokens[ 1 ].equalsIgnoreCase( "view" ) ||

tokens[ 0 ].equalsIgnoreCase( "create" ) &&

tokens[ 1 ].equalsIgnoreCase( "procedure" )

)

dataLines.append( "-- " );

dataLines.append( dataLine ).append( '
' );

}

rdr.close(); // close the file

inputstream.close();



// open the file for writing new data to it

FileWriter outputstream=new FileWriter( sqlFileName );

BufferedWriter writer = new BufferedWriter(outputstream);



// write the new StringBuilder's data back to the file.

writer.write( dataLines.toString(), 0, dataLines.length() );

writer.close(); // close the file

outputstream.close();



_stream = new FileReader (sqlFileName);



} catch( IOException e ) {

e.printStackTrace();

}