1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
|
package com.form.BO;
import java.util.ArrayList;V// ERREUR
import java.util.Iterator;// ERREUR
import java.util.List;// ERREUR
import org.apache.log4j.Logger;// ERREUR
import org.hibernate.HibernateException;// ERREUR
import org.hibernate.Query;// ERREUR
import org.hibernate.Session; // erreur// ERREUR
import org.hibernate.Transaction;// ERREUR
import com.form.HibPersistance.config.HibernateUtil;
/**
* @author khadirs
* @version 1.0
*/
public class LoginBO {
private static org.apache.log4j.Logger log = Logger
.getLogger(LoginBO.class);
@SuppressWarnings("unchecked")
public List getUserLogPass(String login, String password) throws HibernateException {
Session session = HibernateUtil.getSessionFactory().openSession();//getCurrentSession();
Transaction tx = null;
List result = new ArrayList();
List tempo = new ArrayList();
try {
tx = session.beginTransaction();
log.debug("Session Ouverte");
Query q = session.createQuery(
" select username, password " +
" from User " +
" where username = :username " +
" and password = :password ");
q.setString("username", login);
q.setString("password", password);
result = q.list();
for (Iterator iterator = result.iterator(); iterator.hasNext();) {
Object o = (Object) iterator.next();
Object[] tmp = (Object[]) o;
for (int i = 0; i < tmp.length; i++) {
tempo.add(tmp[i]);
}
}
if(log.isDebugEnabled())
for (Iterator it = tempo.iterator();it.hasNext();)
log.debug("Username & Password " + (String) it.next());
tx.commit();
}
catch(HibernateException he){
if (tx!=null) tx.rollback();
throw he;
}
finally {
log.debug("Session Ferm�e");
session.close();
}
return tempo;
}
} |
Partager