changepw.java

struts hibernate框架 商场买卖

package com.shopping.bo.admin;

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(int id,String pw) {
		Session session = HibernateSessionFactory.getSession();
		boolean flag = false;
		String hql = "from Admin u where u.id=:id and u.password=:pw";
		Query q = session.createQuery(hql);
		q.setInteger("id", id);
		q.setString("pw", pw);
		Iterator iter = q.list().iterator();
		if(iter.hasNext()) {
			flag = true;
			System.out.println("checked");
		}
		HibernateSessionFactory.closeSession();
		return flag;
	}
	
	public boolean updatePw(int id,String username,String pw){
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = null;
		boolean flag = false;
		tx = session.beginTransaction();
		String hql = "update Admin as u set u.password=:pw,u.name=:un where u.id=:id";
		Query q = session.createQuery(hql);
		q.setInteger("id", id);
		q.setString("pw", pw);
		q.setString("un", username);
		q.executeUpdate();
		tx.commit();
		System.out.println("updating");
		flag = true;
		HibernateSessionFactory.closeSession();
		return flag;
	}
}