/* package whatever; // don't place package name! */
import java.util.* ;
import java.lang.* ;
import java.io.* ;
/* Name of the class has to be "Main" only if the class is public. */
class Ideone
{
public static void testeDeConcatenacaoComFiltroDentroDasAspas( ) {
// PRIMEIRO TESTE : com "concatenacao dentro das aspas"
String filtro
= " where condicao = ? " ;
String sql
= "select * from nome_da_tabela filtro" ;
System .
out .
println ( "Primeiro caso, vai imprimir a palavra filtro junto do sql:" ) ; }
public static void testeDeConcatenacaoComFiltroForaDasAspas( ) {
// PRIMEIRO TESTE : com "concatenacao dentro das aspas"
String filtro
= " where condicao = ? " ;
String sql
= "select * from nome_da_tabela" + filtro
;
System .
out .
println ( "Segundo caso, vai imprimir o sql devidamente concatenado:" ) ; }
{
testeDeConcatenacaoComFiltroDentroDasAspas( ) ;
testeDeConcatenacaoComFiltroForaDasAspas( ) ;
}
}
LyogcGFja2FnZSB3aGF0ZXZlcjsgLy8gZG9uJ3QgcGxhY2UgcGFja2FnZSBuYW1lISAqLwoKaW1wb3J0IGphdmEudXRpbC4qOwppbXBvcnQgamF2YS5sYW5nLio7CmltcG9ydCBqYXZhLmlvLio7CgovKiBOYW1lIG9mIHRoZSBjbGFzcyBoYXMgdG8gYmUgIk1haW4iIG9ubHkgaWYgdGhlIGNsYXNzIGlzIHB1YmxpYy4gKi8KY2xhc3MgSWRlb25lCnsKCXB1YmxpYyBzdGF0aWMgdm9pZCB0ZXN0ZURlQ29uY2F0ZW5hY2FvQ29tRmlsdHJvRGVudHJvRGFzQXNwYXMoKSB7CgkJLy8gUFJJTUVJUk8gVEVTVEUgOiBjb20gImNvbmNhdGVuYWNhbyBkZW50cm8gZGFzIGFzcGFzIiAKCQlTdHJpbmcgZmlsdHJvID0gIiB3aGVyZSBjb25kaWNhbyA9ID8gIjsKCgkJU3RyaW5nIHNxbCA9ICJzZWxlY3QgKiBmcm9tIG5vbWVfZGFfdGFiZWxhIGZpbHRybyI7CgkKCQlTeXN0ZW0ub3V0LnByaW50bG4oIlByaW1laXJvIGNhc28sIHZhaSBpbXByaW1pciBhIHBhbGF2cmEgZmlsdHJvIGp1bnRvIGRvIHNxbDoiKTsKCQlTeXN0ZW0ub3V0LnByaW50bG4oc3FsKTsKCX0KCQoJcHVibGljIHN0YXRpYyB2b2lkIHRlc3RlRGVDb25jYXRlbmFjYW9Db21GaWx0cm9Gb3JhRGFzQXNwYXMoKSB7CgkJLy8gUFJJTUVJUk8gVEVTVEUgOiBjb20gImNvbmNhdGVuYWNhbyBkZW50cm8gZGFzIGFzcGFzIiAKCQlTdHJpbmcgZmlsdHJvID0gIiB3aGVyZSBjb25kaWNhbyA9ID8gIjsKCgkJU3RyaW5nIHNxbCA9ICJzZWxlY3QgKiBmcm9tIG5vbWVfZGFfdGFiZWxhIiArIGZpbHRybzsKCgkJU3lzdGVtLm91dC5wcmludGxuKCJTZWd1bmRvIGNhc28sIHZhaSBpbXByaW1pciBvIHNxbCBkZXZpZGFtZW50ZSBjb25jYXRlbmFkbzoiKTsKCQlTeXN0ZW0ub3V0LnByaW50bG4oc3FsKTsKCX0KCglwdWJsaWMgc3RhdGljIHZvaWQgbWFpbiAoU3RyaW5nW10gYXJncykgdGhyb3dzIGphdmEubGFuZy5FeGNlcHRpb24KCXsKCQl0ZXN0ZURlQ29uY2F0ZW5hY2FvQ29tRmlsdHJvRGVudHJvRGFzQXNwYXMoKTsKCQkKCQlTeXN0ZW0ub3V0LnByaW50bG4oIiIpOwoJCQoJCXRlc3RlRGVDb25jYXRlbmFjYW9Db21GaWx0cm9Gb3JhRGFzQXNwYXMoKTsKCX0KfQ==