/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.sonic.struts.action;

import java.util.Iterator;

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

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 org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.Hibernate.SessionFactory;
import com.sonic.Userlist;
import com.sonic.struts.form.LogonForm;

/** 
 * MyEclipse Struts
 * Creation date: 11-20-2006
 * 
 * XDoclet definition:
 * @struts.action path="/logon" name="logonForm" input="/logon.jsp" scope="request" validate="true"
 */
public class LogonAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		@SuppressWarnings("unused")
		LogonForm logonForm = (LogonForm) form;// TODO Auto-generated method stub
//		獲取提交的用戶名稱和密碼
		String userName=request.getParameter("userName");
		String userPwd=request.getParameter("userPwd");
		
		String mUserPwd=null;
		Userlist ul=null;
		//創(chuàng)建連接
		Session session=SessionFactory.currentSession();
		//創(chuàng)建事務(wù)
		Transaction tx=session.beginTransaction();
		//創(chuàng)建對話
		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());
		}
		//事務(wù)提交
		tx.commit();
		//關(guān)閉連接
		SessionFactory.closeSession();
		HttpSession session1=request.getSession();  //加入
		if(userPwd.equals(mUserPwd)){
			session1.setAttribute("userName",userName);  //加入，保存Session
			return (mapping.findForward("gomainMenu"));
		}
		else {
			session1.setAttribute("userName",null);  //加入，清除Session
			return (mapping.findForward("rLogon"));
		}
	}
}