//Created by MyEclipse Struts
//XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.4/xslt/JavaClass.xsl

package com.sonic.struts.action;

import java.util.Iterator;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.sonic.HibernateUtil;
import com.sonic.Userlist;

/** 
* MyEclipse Struts
* Creation date: 04-10-2005
* 
* XDoclet definition:
* @struts:action validate="true"
*/
public class LoginAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws HibernateException
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) throws HibernateException {
		//獲取提交的用戶名稱和密碼
		String userName=request.getParameter("userName");
		String userPwd=request.getParameter("userPwd");
		
		String mUserPwd=null;
		Userlist ul=null;
		//創建連接
		Session session=HibernateUtil.Session();
		//創建事務
		Transaction tx=session.beginTransaction();
		//創建對話
		Query query=session.createQuery("select u from Userlist as u where username='" +
				userName + "'");
		try{
			Iterator it = query.iterate();
			ul = (Userlist) it.next();
			mUserPwd=ul.getUserpwd();
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		if(userPwd.equals(mUserPwd))
			request.setAttribute("loginOk","Hello  " + ul.getUsername());
		else
			request.setAttribute("loginOk","Login Error!");
		//事務提交
		tx.commit();
		//關閉連接
		HibernateUtil.closeSession();
		return (new ActionForward("/index.jsp"));
	}

}