public List findByName(String name) {
List tarefas = new ArrayList();
try {
connection = Factory.getConnection();
sql = "SELECT id_tarefa,tx_descricao,nb_hora,cs_tipo FROM tarefa "
+ “WHERE tx_descricao ILIKE CONCAT(’%’,?,’%’)”;
ps = connection.prepareStatement(sql);
ps.setString(1, name);
rs = ps.executeQuery();
while (rs.next()) {
tarefas.add(new Tarefa(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getString(4)));
}
} catch (SQLException e) {
e.printStackTrace();
}
return tarefas;
}