public class ValidarUsuario {
public static void main(String[] args)
{
Consultar consulta = new Consultar ();
EntityManager obconsulta = consulta.getEntityManager();
String query = "select count(U) from CADASTRO_USUARIO U where U.USR_EMAIL=:email and U.USR_SENHA=:senha";
TypedQuery<Usuario> usuario = obconsulta.createQuery(query,Usuario.class);
usuario.setParameter("email", "cleitonesc3@gmail.com");
usuario.setParameter("senha", "1");
List<Usuario> resultado = usuario.getResultList();
obconsulta.close();
for (Usuario usuarios : resultado){
System.out.println("Usuario:" + usuarios);
}
public class ValidarUsuario {
public static void main(String[] args)
{
Consultar consulta = new Consultar ();
EntityManager obconsulta = consulta.getEntityManager();
TypedQuery<Long> query = obconsulta.createQuery( "SELECT COUNT() FROM CADASTRO_USUARIO U WHERE U.USR_EMAIL=:email and U.USR_SENHA=:senha", Long.class);
long total = query.getSingleResult();
query.setParameter("email", "cleitonesc3@gmail.com");
query.setParameter("senha", "1");
if(total>=0){
System.out.println("entrou");
}
System.out.println("não entrous");
Exception in thread “main” java.lang.IllegalArgumentException: org.hibernate.QueryException: Named parameter [senha] not set
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:133)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1471)
at com.cleiton.consultas.ValidarUsuario.main(ValidarUsuario.java:21)
Caused by: org.hibernate.QueryException: Named parameter [senha] not set
at org.hibernate.query.internal.QueryParameterBindingsImpl.verifyParametersBound(QueryParameterBindingsImpl.java:251)
at org.hibernate.query.internal.AbstractProducedQuery.beforeQuery(AbstractProducedQuery.java:1313)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1412)
at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1463)
… 1 more
TypedQuery<Long> query = obconsulta.createQuery("SELECT COUNT(U) FROM CADASTRO_USUARIO U WHERE U.USR_EMAIL=:email and U.USR_SENHA=:senha", Long.class);
query.setParameter("email", "cleitonesc3@gmail.com");
query.setParameter("senha", "1");
long total = query.getSingleResult();
...