import java.io.FileOutputStream;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
 
class SelToFile {
 
	public static void main(String[] args) throws Exception 
	{
		String url = "jdbc:firebirdsql://host[:port]/<database>";
		String username = "user";
		String password = "password";
		String filename = "result.txt";
		String sql = "select F1 from mytable";
 
		PrintWriter out = new PrintWriter(new OutputStreamWriter(new FileOutputStream(filename), "UTF-8"));
		Connection con = DriverManager.getConnection(url, username, password);
		Statement stmt = con.createStatement();
		ResultSet rs = stmt.executeQuery(sql);
		while (rs.next()) out.println(rs.getString(1));
		rs.close();
		stmt.close();
		con.close();
		out.close();
	}
}
 

aW1wb3J0IGphdmEuaW8uRmlsZU91dHB1dFN0cmVhbTsKaW1wb3J0IGphdmEuaW8uT3V0cHV0U3RyZWFtV3JpdGVyOwppbXBvcnQgamF2YS5pby5QcmludFdyaXRlcjsKaW1wb3J0IGphdmEuc3FsLkRyaXZlck1hbmFnZXI7CmltcG9ydCBqYXZhLnNxbC5Db25uZWN0aW9uOwppbXBvcnQgamF2YS5zcWwuUmVzdWx0U2V0OwppbXBvcnQgamF2YS5zcWwuU3RhdGVtZW50OwoKY2xhc3MgU2VsVG9GaWxlIHsKCglwdWJsaWMgc3RhdGljIHZvaWQgbWFpbihTdHJpbmdbXSBhcmdzKSB0aHJvd3MgRXhjZXB0aW9uIAoJewoJCVN0cmluZyB1cmwgPSAiamRiYzpmaXJlYmlyZHNxbDovL2hvc3RbOnBvcnRdLzxkYXRhYmFzZT4iOwoJCVN0cmluZyB1c2VybmFtZSA9ICJ1c2VyIjsKCQlTdHJpbmcgcGFzc3dvcmQgPSAicGFzc3dvcmQiOwoJCVN0cmluZyBmaWxlbmFtZSA9ICJyZXN1bHQudHh0IjsKCQlTdHJpbmcgc3FsID0gInNlbGVjdCBGMSBmcm9tIG15dGFibGUiOwoJCQoJCVByaW50V3JpdGVyIG91dCA9IG5ldyBQcmludFdyaXRlcihuZXcgT3V0cHV0U3RyZWFtV3JpdGVyKG5ldyBGaWxlT3V0cHV0U3RyZWFtKGZpbGVuYW1lKSwgIlVURi04IikpOwoJCUNvbm5lY3Rpb24gY29uID0gRHJpdmVyTWFuYWdlci5nZXRDb25uZWN0aW9uKHVybCwgdXNlcm5hbWUsIHBhc3N3b3JkKTsKCQlTdGF0ZW1lbnQgc3RtdCA9IGNvbi5jcmVhdGVTdGF0ZW1lbnQoKTsKCQlSZXN1bHRTZXQgcnMgPSBzdG10LmV4ZWN1dGVRdWVyeShzcWwpOwoJCXdoaWxlIChycy5uZXh0KCkpIG91dC5wcmludGxuKHJzLmdldFN0cmluZygxKSk7CgkJcnMuY2xvc2UoKTsKCQlzdG10LmNsb3NlKCk7CgkJY29uLmNsb3NlKCk7CgkJb3V0LmNsb3NlKCk7Cgl9Cn0K