package action;

import java.io.IOException;
import java.sql.Connection;
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.loginform;

public class login extends Action {

	static Connection conn = null;

	static String sql;

	PreparedStatement psmt = null;

	ResultSet res = null;

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {
		loginform myForm = (loginform) form;
		// ////////////////////////////////////////////////
		String sflag = request.getParameter("flag");
		String wareid = myForm.getWareid();
		String warename = myForm.getWarename();
		System.out.println("flag="+sflag);
		// /////////////////////////////////////////////////////////////////////////////////////////

		HttpSession session = request.getSession(true);
		if(!session.getAttribute("numrecord").equals("1"))
		{
		session.setAttribute("numrecord","1");
		int m=1;
		session.setAttribute("num",m);
		}
		if (sflag != null && sflag.equals("del")) {
			String C2[] = request.getParameterValues("C1");
			if (C2 != null) {
				for (int i = 0; i < C2.length; i++) {

					sql = "select *  from repertory where wareid='" + C2[i]
							+ "'";
					System.out.println("sql=" + sql);
					Connection con = conn();
					try {
						psmt = con.prepareStatement(sql);
						ResultSet rs = psmt.executeQuery();
						if (rs.next()) {
							session.setAttribute("message", "搴撳瓨涓