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

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;
import org.hibernate.Query;
import org.hibernate.Session;

import com.test.HibernateUtil;
import com.test.Users;
import yy.jdbc;
import com.test.form.RegisterForm;

/** 
 * MyEclipse Struts
 * Creation date: 05-08-2009
 * 
 * XDoclet definition:
 * @struts.action path="/register" name="registerForm" input="/form/register.jsp" scope="request" validate="true"
 */
public class RegisterAction 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) {
		RegisterForm registerForm = (RegisterForm) form;// TODO Auto-generated method stub
	       
	        try {
	            // 檢查用戶名是否已經(jīng)被使用
	            //if (!checkUserName(registerForm.getUserName())) {
	                //errors.add("usedUsername", new ActionMessage(
	                       // "register.usedUsername"));
	                //this.saveErrors(request, errors);
	               // return mapping.getInputForward();
	            //}
	            // 注冊(cè)新用戶
	            Users user = new Users();
	            user.setUserName(new String(registerForm.getUserName().getBytes("ISO-8859-1"), "GB2312"));
	            user.setPwd(registerForm.getPwd());
	            user.setSex(new String(registerForm.getSex().getBytes("ISO-8859-1"), "GB2312"));
	            user.setEmail(registerForm.getEmail());
	            user.setQq(registerForm.getQq());
	            user.setAddress(new String(registerForm.getAddress().getBytes("ISO-8859-1"), "GB2312"));
	            user.setPhone(registerForm.getPhone());
	            user.setPower("會(huì)員");
	            Session session = HibernateUtil.currentSession();
	            HibernateUtil.beginTransaction();
	            session.save(user);
	            HibernateUtil.commitTransaction();
	            request.getSession().setAttribute("user", user);
	        } catch (Exception e) {
	            // 如果數(shù)據(jù)庫(kù)出現(xiàn)錯(cuò)誤則返回上一頁(yè)并給出提示
	            System.out.println(e.getMessage());
	            return mapping.getInputForward();
	        }
	        // 成功后返回首頁(yè)
	        return mapping.findForward("frontPage");
	}
	private boolean checkUserName(String username) {
        Session session = HibernateUtil.currentSession();
        HibernateUtil.beginTransaction();
        List result;
        try{
           Query query = session.createQuery(
                "from Users as u where u.userName=:username").setString(
                "username", username).setMaxResults(1);
           result = query.list();
           HibernateUtil.commitTransaction();
           return result.size() == 0;
        }
        catch(org.hibernate.exception.SQLGrammarException e)
        {
           System.out.println(e.getMessage());
           return false;
        }
    }
}