Shell Programming and Scripting

I need to run sql script from shell script which takes the input from a file and contents of file will be like :

12345
34567
78657

and query will be like :

select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr from bus_event where event_nbr='78657';

the letters in bold will be taken from file..

Can anyone please help me out in this..

Code:

$ cat fil
12345
34567
78657

Query output:

Code:

$ awk '{print "select seq_nbr from bus_event where event_nbr="q$0q";";}' q="'" fil
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr from bus_event where event_nbr='78657';

Guru.