changepw.java

struts hibernate框架 商场买卖

package com.shopping.bo.user;

import java.util.Iterator;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.shopping.util.HibernateSessionFactory;

public class ChangePW {
	public boolean checkPW(String username,String pw) {
		Session session = HibernateSessionFactory.getSession();
		boolean flag = false;
		String hql = "from User u where u.username=:un and u.password=:pw";
		Query q = session.createQuery(hql);
		q.setString("un", username);
		q.setString("pw", pw);
		System.out.println("checking");
		Iterator iter = q.list().iterator();
		if(iter.hasNext()) {
			flag = true;
			System.out.println("checked");
		}
		HibernateSessionFactory.closeSession();
		return flag;
	}
	
	public boolean updatePw(String username,String pw){
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = null;
		boolean flag = false;
		tx = session.beginTransaction();
		String hql = "update User as u set u.password=:pw where u.username=:un";
		Query q = session.createQuery(hql);
		q.setString("pw", pw);
		q.setString("un", username);
		q.executeUpdate();
		tx.commit();
		System.out.println("updating");
		flag = true;
		HibernateSessionFactory.closeSession();
		return flag;
	}
}