I have a project named "Design of execution manager in distributed database". I have stored a query(SQL) in text file. Can neone tell me a java code inorder to extraxt the query from the text file such as table name, attributed etc..plz help immediately

How is this file?
You can use I/O classes.
You may also use a .xml file and read it from Java.
Dimis

i used java csvreader and read line by line, or just normail java io library

CSVreader
sample.sql
INSERT INTO.....;
UPDATE TABNNLE ....;

in java

PreparedStatement pst=null;
Connection conn=
.....
CsvReader reader = new CsvReader("c:/sample.sql");
while (reader.readRecord())
{
String sql = reader.get(0);
pst.executeQuery(sql);


// perform program logic here

}

don't forget the try and catch block and finnally block