Ajuda com hibernate

18 de junho de 2009 5 respostas

juniorribeiroPJ 18 de junho de 2009

O que estou fazendo errado? ja pesquisei em outros tópicos, mas até agora não obtive sucesso!

Meu código DAO:

public List&lt;RamalBean&gt; busca(RamalBean ramalBean) {	
		this.session = MySQLDAOFactory.getSession();

		Criteria criteria = session.createCriteria(RamalBean.class)
			.add(Restrictions.like("busca", ramalBean.toString(), MatchMode.ANYWHERE).ignoreCase()); 
			criteria.addOrder(Order.asc("setor").ignoreCase());

		this.session.close();	
		return criteria.list();  
	}

Meu JSP index.jsp:

&lt;table&gt;
	&lt;tr&gt;
		&lt;td align="center"&gt;
                        &lt;s:form action="select" method="post"&gt;
			&lt;s:textfield required="true" theme="ajax" id="busca" name="" label="Busca" size="25" /&gt;
			&lt;s:submit action="select" value="Buscar" name="aux" notifyTopics="buscaTopic" /&gt;
		&lt;/s:form&gt;&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;
&lt;s:div id="buscaList" href="select.action" listenTopics="buscaTopic"
	theme="ajax" /&gt;

Struts.xml:

&lt;action name="select" method="busca"
			class="br.com.listafag.actions.RamalAction"&gt;
			&lt;result name="true"&gt;/busca.jsp&lt;/result&gt;
		&lt;/action&gt;

Na minha Action tenho o seguinte código:

private List&lt;RamalBean&gt; select = new ArrayList&lt;RamalBean&gt;();

	public String busca() {
		setListaRamal(ramalDAO.busca(getRamalBean()));
		return "true";
	}

Meu JSP busca.jsp:

&lt;table&gt;
&lt;tr&gt;
		&lt;td width="135px" style="color: red"&gt;<b>Bloco</b>&lt;/td&gt;
		&lt;td width="135px" style="color: red"&gt;<b>Ramal</b>&lt;/td&gt;
		&lt;td width="135px" style="color: red"&gt;<b>Setor</b>&lt;/td&gt;
		&lt;td width="135px" style="color: red"&gt;<b>Colaborador</b>&lt;/td&gt;
	&lt;/tr&gt;
	&lt;s:iterator value="select"&gt;
		&lt;tr&gt;
			&lt;td&gt;&lt;s:property value="bloco" /&gt;&lt;/td&gt;
			&lt;td&gt;&lt;s:property value="ramal" /&gt;&lt;/td&gt;
			&lt;td&gt;&lt;s:property value="setor" /&gt;&lt;/td&gt;
			&lt;td&gt;&lt;s:property value="colaborador" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
	&lt;/s:iterator&gt;
&lt;/table&gt;

No browser dá o seguinte erro: “Error loading ‘select.action’ (500 Internal Server Error)”

5 Respostas

juniorribeiroPJ 18 de jun. de 2009

Eu quero fazer uma pesquisa no banco e retornar em um List.
Não sei se estou passando os parâmetros de forma correta.
Eu ja consigo listar todos os dados do banco, e mostrar na tela!
assim:

public List&lt;RamalBean&gt; getRamais() {
		this.session = MySQLDAOFactory.getSession();
		List&lt;RamalBean&gt; listaRamal = this.session.createCriteria(
				RamalBean.class).addOrder(Order.asc("setor").ignoreCase()).list();
		this.session.close();
		return listaRamal;
	}

juniorribeiroPJ 19 de jun. de 2009

Consegui rodar sem erros assim:

public List&lt;RamalBean&gt; busca(RamalBean ramalBean) {	
		this.session = MySQLDAOFactory.getSession();		
		List&lt;RamalBean&gt; select = this.session.createCriteria(RamalBean.class).
		add(Restrictions.like("setor", "%"+ramalBean.getSetor()+"%").ignoreCase()).list();
		
		this.session.close();
		return select;  
	}

Mas não está me retornando nada!
Se alguém tiver uma idéia do que pode ser, por favor poste.

juniorribeiroPJ 24 de jun. de 2009

Consegui, meu método de busca ficou assim:

public List&lt;ListaBean&gt; busca(ListaBean listaBean) {
		this.session = MySQLDAOFactory.getSession();

		Disjunction disjunction = Restrictions.disjunction();
		disjunction.add(Restrictions.like("colaborador",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("bloco",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("ramal",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("telefone",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("email",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("setor",
				"%" + listaBean.getSetor() + "%").ignoreCase());		

		List&lt;ListaBean&gt; busca = this.session.createCriteria(ListaBean.class)
				.addOrder(Order.asc("setor")).add(disjunction).list();

		this.session.close();
		return busca;
	}

O SQL da consulta:

select
        this_.id as id0_0_,
        this_.bloco as bloco0_0_,
        this_.colaborador as colabora3_0_0_,
        this_.email as email0_0_,
        this_.ramal as ramal0_0_,
        this_.setor as setor0_0_,
        this_.telefone as telefone0_0_ 
    from
        lista this_ 
    where
        (
            lower(this_.colaborador) like ? 
            or lower(this_.bloco) like ? 
            or lower(this_.ramal) like ? 
            or lower(this_.telefone) like ? 
            or lower(this_.email) like ? 
            or lower(this_.setor) like ?
        ) 
    order by
        this_.setor asc

juniorribeiroPJ 24 de jun. de 2009

Consegui, meu método de busca ficou assim:

public List&lt;ListaBean&gt; busca(ListaBean listaBean) {
		this.session = MySQLDAOFactory.getSession();

		Disjunction disjunction = Restrictions.disjunction();
		disjunction.add(Restrictions.like("colaborador",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("bloco",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("ramal",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("telefone",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("email",
				"%" + listaBean.getSetor() + "%").ignoreCase());
		disjunction.add(Restrictions.like("setor",
				"%" + listaBean.getSetor() + "%").ignoreCase());		

		List&lt;ListaBean&gt; busca = this.session.createCriteria(ListaBean.class)
				.addOrder(Order.asc("setor")).add(disjunction).list();

		this.session.close();
		return busca;
	}

O SQL gerado:

select
        this_.id as id0_0_,
        this_.bloco as bloco0_0_,
        this_.colaborador as colabora3_0_0_,
        this_.email as email0_0_,
        this_.ramal as ramal0_0_,
        this_.setor as setor0_0_,
        this_.telefone as telefone0_0_ 
    from
        lista this_ 
    where
        (
            lower(this_.colaborador) like ? 
            or lower(this_.bloco) like ? 
            or lower(this_.ramal) like ? 
            or lower(this_.telefone) like ? 
            or lower(this_.email) like ? 
            or lower(this_.setor) like ?
        ) 
    order by
        this_.setor asc

juniorribeiroPJ 24 de jun. de 2009

Criado 18 de junho de 2009

Ultima resposta 24 de jun. de 2009

Respostas 5

Participantes 1

5 Respostas

Topicos relacionados