java - 将多个选定值插入表中(oracle)

Question

这是我的index.jsp页面

<form action="addCountry.jsp" method="get">
    <select id="countries" class="multiselect" multiple="multiple" name="countries">
      <option value="AFG">Afghanistan</option>
      <option value="ALB">Albania</option>
      <option value="DZA">Algeria</option>
      <option value="AND">Andorra</option>
      <option value="ARG">Argentina</option>
      <option value="ARM">Armenia</option>
      <option value="ABW">Aruba</option>
      <option value="AUS">Australia</option>
      <option value="AUT" selected="selected">Austria</option>
      <option value="AZE">Azerbaijan</option>
      <option value="BGD">Bangladesh</option>
      <option value="BLR">Belarus</option>
      <option value="BEL">Belgium</option>
      <option value="BIH">Bosnia and Herzegovina</option>
      <option value="BRA">Brazil</option>
      <option value="BRN">Brunei</option>
      <option value="BGR">Bulgaria</option>
      <option value="CAN">Canada</option>
      <option value="CHN">China</option>
      <option value="COL">Colombia</option>
      <option value="HRV">Croatia</option>
      <option value="CYP">Cyprus</option>
      <option value="CZE">Czech Republic</option>
</select>
<br/>
      <input type="submit" value="Submit Form"/>
    </form>

这将是我的addCountry.jsp页面代码

<% 
try{
String[] country=request.getParameterValues("countries");
int count=0;
while(country[count]!=null)
out.println(country[count++]);
}catch(Exception ex)
{
//out.print(ex);
}
%>

但是，我很困惑同时将多个值插入表中。我应该使用循环进行多次插入吗？任何帮助表示赞赏!预先感谢!

Answer 1

看看javadoc对于 java.sql.Statement 特别是 addBatch(String sql) 和 executeBatch() 方法对语句进行排队并稍后一起执行。