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

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;


import?javabean.CardBean;
import?javabean.PageBean;

import?javax.mail.Session;
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?com.yourcompany.struts.form.CardForm;

import?dao.CardDao;

/**?
?*?MyEclipse?Struts
?*?Creation?date:?07-29-2010
?*?
?*?XDoclet?definition:
?*?@struts.action?path=“/card“?name=“cardForm“?input=“/insert.jsp“?scope=“request“?validate=“true“
?*/
public?class?CardAction?extends?Action?{
	/*
	?*?Generated?Methods
	?*/

	/**?
	?*?Method?execute
	?*?@param?mapping
	?*?@param?form
	?*?@param?request
	?*?@param?response
	?*?@return?ActionForward
	?*/
	@SuppressWarnings（“unchecked“）
	public?ActionForward?execute（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?throws?IOException?{
		CardForm?cardForm?=?（CardForm）?form;//?TODO?Auto-generated?method?stub
		String?name=cardForm.getName（）;
		String?sex=cardForm.getSex（）;
		String?title=cardForm.gettitle（）;
		String?mobile=cardForm.getMobile（）;
		String?phone=cardForm.getPhone（）;
		String?email=cardForm.getEmail（）;
		String?address=cardForm.getAddress（）;
		String?comd=cardForm.getComd（）;
		PrintWriter?out=response.getWriter（）;
		HttpSession?session=request.getSession（）;
		
		ArrayList?arr=new?ArrayList（）;
		arr.add（name）;
		arr.add（sex）;
		arr.add（title）;
		arr.add（mobile）;
		arr.add（phone）;
		arr.add（email）;
		arr.add（address）;
		
		CardDao?card=new?CardDao（）;
		//添加名片
		if（comd.equals（“insert“））
		{
			if（card.insert（arr））
			{
				//只能用println不能使用print
				out.println（“ript?language=javascript>“）;
				out.println（“alert（‘添加成功！‘）“）;
				out.println（“l(fā)ocation.href=‘card.do?comd=query‘“）;
				out.println（“ript>“）;
				out.close（）;
			}
			else
			{
				out.println（“ript?language=javascript>“）;
				out.println（“alert（‘添加失敗！‘）“）;
				out.println（“l(fā)ocation.href=‘card.do?comd=query‘“）;
				out.println（“ript>“）;
				out.close（）;
			}
		}
		
		//瀏覽查詢?nèi)棵?br/>		if（comd.equals（“query“））
		{
			String?condition=cardForm.getCondition（）;
			if（condition==null）
				???condition=““;?
			session.setAttribute（“condition“?condition）;
			return?mapping.findForward（“query“）;
		}
		
		//鏈接到修改頁面
		if（comd.equals（“xiugai“））
		{
			String?id=request.getParameter（“id“）;
			request.setAttribute（“id“?id）;
			Integer?integer=new?Integer（id）;
			ResultSet?rs=card.showById（integer）;
			try?{
				rs.next（）;