package action;

import java.io.IOException;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import javax.servlet.ServletException;
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 actionform.logactform;

public class clientsearchact extends Action {
	static Connection con = null;

	static PreparedStatement ps = null;

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {
		logactform myForm = (logactform) form;
		// request.setCharacterEncoding("utf-8");
		// response.setCharacterEncoding("utf-8");
		String dong = myForm.getSearchid();
		System.out.println("run");
		String flag = (String) request.getParameter("flag");
		System.out.println(flag);

		String gbox = myForm.getSet();

		if (!gbox.equals("") && gbox != null && flag != null&& flag.equals("delete")) {
			System.out.println("delete run!");
			// ##############################################################
			// 錕斤拷錕斤拷刪錕斤拷
			// String arraybox[]=request.getParameterValues("set");
			// int a=arraybox.length;
			// while(a>0){
			// String id=arraybox[a-1];
			// if (id != null) {
			// id = new String(id.getBytes("ISO8859-1"));
			// }
			// System.out.println("id="+id);
			// String sql="delete from client where clientid='"+id+"'";
			// System.out.println(sql);
			//					 
			// Connection con=conn();
			//					
			// try {
			// ps = con.prepareStatement(sql);
			// ps.executeUpdate();
			//						
			// } catch (SQLException e1) {
			// System.out.print("some is wrong!");
			// e1.printStackTrace();
			// }
			// a--;
			// }
			// #################################################### 錕斤拷錕繳撅拷錕