JSP→Servlet→Beanでの配列の受渡し

::::JSP::::

function setDelData(rcnt){

	// 削除行データ取得

	i = 0;

	PprojectId_h = document.form1.projectId.value;

		

	// 削除対象データ数取得

	for(k=0; k<rcnt; k++){

		if(document.form2.delBox[k].Checked == true){

			i++;

		}

	}

	// プロジェクトＩＤと予算�ｂﾌ配列作成

	delprjId = new Array(i);

	delyosanNo = new Array(i);

		

	// 削除対象データキー項目取得

	cnt = 0;

	for(k=0; k<rcnt; k++){

		if(document.form2.delBox[k].checked == true){

			delprjId[cnt] = document.form2.hiprjId[k].value;

			delyosanNo[cnt] = document.form2.hiyosanNo[k].value;

			cnt++;

		}

	}

	for(b=0; b<cnt; b++){

		alert(delprjId[b]);

		alert(delyosanNo[b]);

	}

	document.form1.action="YosanDel?mode=DEL" + "&projectId=" + delprjId + "&yosanNo=" + delyosanNo + "&projectId_h=" + PprojectId_h;

	document.form1.submit();

}



::::Servlet::::

if (mode.equals("DEL")){

	// 削除

	session.removeAttribute("ydelbean");

					

	YosanDelBean Ydelbean = new YosanDelBean();

					

	Ydelbean.setprojectid(request.getParameterValues("projectId"));



	Ydelbean.setyosanno(request.getParameterValues("yosanNo"));

					

	Ydelbean.execute();

	

}



::::bean::::　(コンストラクタ等省略)

public class YosanDelBean implements Serializable{



private String[] projectid;

private String[] yosanno;





public void execute(){

	try{

		Class.forName("oracle.jdbc.driver.OracleDriver");

				

		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@******:1521:*****","*****","*****n");

				

		Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

				

		// DBからデータ削除

							

		for(int i=0; i<projectid.length; i++){

			strSql = "";

			strSql += "DELETE FROM PRM_M_YOSANKOUMOKU ";

			strSql += " WHERE PRJ_ID = " + projectid[i];

			strSql += " AND YOSAN_NO = " + yosanno[i];



			stmt.execute(strSql);

		}

				 

		conn.close();



	}catch(Exception e){

			e.printStackTrace();

	}

}

// 配列1

public void setprojectid(String[] prjarr){

	this.projectid = prjarr;

}

	

// 配列2

public void setyosanno(String[] yosanarr){

	this.yosanno = yosanarr;

}

Pattern ptn = Pattern.compile("[,]+");
String[] PrjAry = ptn.split(request.getParameter("projectId"));
String[] YosanAry =ptn.split(request.getParameter("yosanNo"));