extract SQL statements from Java source

1. $KCODE='SJIS'
2. d=""
3. deappend=false
4. i=0
5. File.open("in.txt").each_line{|l|
6.         l.strip!
7.         i+=1
8.         if(i==1)
9.             if(l.include?(".append") || l.include?("StringBuffer"))
10.                     deappend=true
11.             end
12.         end
13.         if(!deappend)
14.             if (l.strip.rindex("--") ==0)
15.                 d << "      // #{l.strip}/n"
16.             elsif (l.strip=="")
17.                 next
18.             else
19.                 d <<"       sql.append(/"#{l.strip} /");/n"
20.             end
21.         end
22.         if(deappend)
23.             if(l=~/^(.*)/)
24.                 d << "-- #{$1.delete("--")}/n"
25.             elsif(l.strip=~/^.*/.append/s*/((.*)/)/s*;/)                
26.                 d << $1.strip.delete("/"") << "/n"
27.             else
28.                 puts "-- ignore >> #{l.chomp.strip}"
29.             end
30.         end
31. }
32. puts d