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

import java.sql.SQLException;

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

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.hacker.struts.form.LogonForm;
import com.hacker.web.service.UserinfoService;
/** 
 * MyEclipse Struts
 * Creation date: 08-29-2008
 * 
 * XDoclet definition:
 * @struts.action path="/logon" name="logonForm" input="/logon/logon.jsp" scope="request" validate="true"
 */
public class LogonAction extends DispatchAction {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward isLogon(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		LogonForm logonForm = (LogonForm) form;// TODO Auto-generated method stub
		UserinfoService userinfo = new UserinfoService();
		if(userinfo.isLogon(logonForm)){
			return mapping.findForward("ok");
		}else{
			request.setAttribute("error", "用戶名密碼錯(cuò)誤");
			return mapping.findForward("error");
		}
		
	}
	public ActionForward add(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		LogonForm logonForm = (LogonForm) form;// TODO Auto-generated method stub
		UserinfoService userinfo = new UserinfoService();
		try {
			userinfo.save(logonForm);
			return mapping.findForward("welcome");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			request.setAttribute("error", e.toString());
			return mapping.findForward("error");
		}
	}
	public ActionForward delete(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String id = request.getParameter("id");
		System.out.println(id);
		UserinfoService userinfo = new UserinfoService();
		
		try {
			userinfo.delete(id);
			return mapping.findForward("ok");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			request.setAttribute("error", e.toString());
			return mapping.findForward("error");
		}
	}
	public ActionForward deleteSelect(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String ids[] = request.getParameterValues("ids");
		UserinfoService userinfo = new UserinfoService();
		try {
			userinfo.deleteSelect(ids);
			//System.out.println("1111111");
			return mapping.findForward("ok");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			request.setAttribute("error", e.toString());
			return mapping.findForward("error");
		}
		
	}
	public ActionForward findByKey(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		int id = Integer.parseInt(request.getParameter("id"));// TODO Auto-generated method stub
		LogonForm logonForm = new LogonForm();
		logonForm.setId(id);
		System.out.println(logonForm.getId());
		UserinfoService userinfo = new UserinfoService();
		LogonForm logon = (LogonForm)userinfo.findByKey(logonForm);
		System.out.println(logon);
		request.setAttribute("logon", logon);
		return mapping.findForward("find");
	}
	public ActionForward update(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		LogonForm logonForm = (LogonForm) form;// TODO Auto-generated method stub
		UserinfoService userinfo = new UserinfoService();
		try {
			userinfo.update(logonForm);
			return mapping.findForward("ok");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			request.setAttribute("error", e.toString());
			return mapping.findForward("error");
		}
	}
	
	
		
}