how to check if a data exist on a table using hibernate

Question

im using hibernate with my jsp page and mySQL ,how can i do that select * from student wher userName = *** with HQL

and how i chek if that username exist in 'Student' table ?

in my sql i use that

ResultSet resultat = statement.executeQuery();

if (resultat.next()) { ....}

i try this

Session hibernateSession = MyDB.HibernateUtil.currentSession(); 
hibernateSession.find("select xxx from Etudinat where p.Nom=xxxx");

its give me a list but

i have a login form send me a username and password

i want to chek if that username exist in the table Student to set the user on a session

what is the safty way to do that

Olaf · Accepted Answer · 2011-06-24 15:39:07Z

3

I could not paste code into the comment. Try the following HQL:

from Etudinat where Nom = 'xxxx'

Even better, pass the username as a parameter.

Per OP request, code snippet based on the comments:

    Query q = hibernateSession.createQuery("from Etudinat where Nom = :username");
q.setParameter("username", xxxx);       
Etudinat e = q.uniqueResult();

edited Jun 24, 2011 at 15:39

answered Jun 24, 2011 at 14:36

Olaf

6,2991 gold badge21 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Olaf Over a year ago

@David: absolutely not. This why I suggest passing username as a parameter. You can tell session to create a Query using HQL with parameter (where Nom = :username) and set parameter username to the value passed to your DAO. Then you can call uniqueResult() method on your query.

David Over a year ago

thank you , plz give me a ligne how to use the uniqueResult() i'v to that for tomorow

Collectives™ on Stack Overflow

how to check if a data exist on a table using hibernate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related