<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ include file="/connection.jsp" %>
<%
request.setCharacterEncoding("EUC-KR");
%>
<%
int flag=Integer.parseInt(request.getParameter("flag"));
System.out.println("flag="+flag);
String product_No = null;
String product_name = null;
String product_quality = null;
String product_unit = null;
String product_pri = null;
String DM_D =null;
String quatation_D = null;
String DM_q = null;
String sell_pri = null;
int corp_regist_No = 0;
String Quatation_No =null;
for(int i=1 ; i < flag ; i++)
{
String quotation_no=request.getParameter("quotation_no");
System.out.println(quotation_no);
String quotation_D=request.getParameter("quotation_D");
System.out.println(quotation_D);
String corp_name=request.getParameter("corp_name");
System.out.println(corp_name);
corp_regist_No=Integer.parseInt(request.getParameter("corp_regist_No"));
System.out.println(corp_regist_No);
String corp_addr=request.getParameter("corp_addr");
System.out.println(corp_addr);
String employee_name="김영준";
System.out.println(employee_name);
String Quatation_con=request.getParameter("Quatation_con");
System.out.println(Quatation_con);
String Q_D=request.getParameter("Q_D");
System.out.println(Q_D);
String theDate=request.getParameter("theDate");
System.out.println(theDate);
product_No=request.getParameter("product_No"+i);
System.out.println(product_No);
product_name=request.getParameter("product_name"+i);
System.out.println(product_name);
product_quality=request.getParameter("product_quality"+i);
System.out.println(product_quality);
product_unit=request.getParameter("product_unit"+i);
System.out.println(product_unit);
product_pri=request.getParameter("product_pri"+i);
System.out.println(product_pri);
DM_q=request.getParameter("DM_q"+i);
System.out.println(DM_q);
sell_pri=request.getParameter("sell_pri"+i);
System.out.println(sell_pri);
pstmt=null;
String sql = null;
%>
<%
try{
sql="update Quantation_infor set quatation_D='"+quotation_D+"', corp_name ='"+corp_name+"', corp_regist_No='"+corp_regist_No+"',corp_addr='"+corp_addr+"',employee_name='"+employee_name+"',Quatation_con='"+Quatation_con+"',exp_date='"+Q_D+"',DM_D='"+theDate+"',product_No='"+product_No+"',product_name='"+product_name+"',product_quality='"+product_quality+"',product_unit='"+product_unit+"',product_pri='"+product_pri+"',DM_q='"+DM_q+"',sell_pri='"+sell_pri+"' where Quatation_No='"+quotation_no+"'";
pstmt=conn.prepareStatement(sql);
pstmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}
}
%>
Insert title here