实例讲解Java批量插入、更新数据
Java的批量添加数据，多个字段同时添加多条数据，我不知道你遇到过没有。今天我们就以一个具体的实例来说一下Java的批量添加数据，面向的是Oracle数据库。
前台页面：
<spanstyle="font-size:14px;"><bodyclass="main_body"scroll="no">
<divclass="employee_gun_dong">
<formname="webform"method="post">
<divclass="main_content_bg">
<divclass="main_content_title">
<divid="baseinfo"onclick="activeTabPanel(1)"style="margin-right:2px;"class="tab1">基本信息</div>
<divid="semsinfo"onclick="activeTabPanel(2)"style="margin-right:2px;"class="tab1">页签1</div>
<divid="changeinfo"onclick="activeTabPanel(3)"style="margin-right:2px;"class="tab1">页签2</div>
<divid="familyinfo"onclick="activeTabPanel(4)"style="margin-right:2px;"class="tab1">页签3</div>
<divid="changeinfo"onclick="activeTabPanel(5)"style="margin-right:2px;"class="tab1">页签4</div>
<divid="familyinfo"onclick="activeTabPanel(6)"style="margin-right:2px;"class="tab1">页签5</div>
<divid="familyinfo"onclick="activeTabPanel(7)"style="margin-right:2px;"class="tab2">页签6</div>
</div>
</div>
<divclass="main_content_bg"id="bankCardDiv">
<divclass="main_middle_bg">
<divclass="main_content_title">信息展示
<inputid="addBank"type="button"value="新增一行"class="modul_button_operate"onclick="addNewRow();"/>
</div>
<divclass="main_table_bg">
<tableid="parttable"width='100%'border='0'cellspacing='1'cellpadding='0'class='content_table_list'>
<tr>
<thclass='content_table_number'>序号</th>
<thclass='content_table_thnowarp'>属性1</th>
<thclass='content_table_thnowarp'>属性2</th>
<thclass='content_table_thnowarp'>属性3</th>
<thclass='content_table_thnowarp'>属性4</th>
<thclass='content_table_thnowarp'>属性5</th>
<thclass='content_table_thnowarp'>属性6</th>
<thclass='content_table_thnowarp'>属性7</th>
<thclass='content_table_thnowarp'>属性8</th>
<thclass='content_table_thnowarp'>属性9</th>
<thclass='content_table_thnowarp'>操作</th>
</tr>
<c:iftest="${fn:length(personFamilyInfoList)>0}">
<c:forEachitems="${personFamilyInfoList}"var="personFamilyInfoList"varStatus="st">
<tr>
<!--序号-->
<tdclass="content_table_number">${st.count}
<inputtype="hidden"name="personFamilyInfoList[${st.count-1}].SGuid"value="${personFamilyInfoList.SGuid}"/>
<inputtype="hidden"name="personFamilyInfoList[${st.count-1}].SPersonGuid"value="${personFamilyInfoList.SPersonGuid}"/>
<inputtype="hidden"name="personFamilyInfoList[${st.count-1}].SUnitGuid"value="${personFamilyInfoList.SUnitGuid}">
<inputtype="hidden"name="personFamilyInfoList[${st.count-1}].isEnable"value="${personFamilyInfoList.isEnable}">
</td>
<!--属性1-->
<tdclass="content_table_td_centernowrap">
<inputid="sFamilyName${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].SFamilyName"class="content_content_input"maxlength="20"value="${personFamilyInfoList.SFamilyName}">
</td>
<!--属性2-->
<tdclass="content_table_td_centernowrap">
<inputid="sFamilyIdcardNo${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].SFamilyIdcardNo"class="content_content_input"maxlength="20"value="${personFamilyInfoList.SFamilyIdcardNo}">
</td>
<!--属性3-->
<tdclass="content_table_td_centernowrap">
<selectid="iFamilySex${st.count-1}"name="personFamilyInfoList[${st.count-1}].IFamilySex">
<zw:basedictlistitemCode="<%=Constants.I_PERSON_SEX%>"selectValue="${personFamilyInfoList.IFamilySex}"></zw:basedictlist>
</select><fontcolor="red">*</font>
</td>
<!--属性4-->
<tdclass="content_table_td_centernowrap">
<selectid="sFamilyRelation${st.count-1}"name="personFamilyInfoList[${st.count-1}].SFamilyRelation">
<zw:basedictlistitemCode="<%=Constants.S_FAMILY_RELATION%>"selectValue="${personFamilyInfoList.SFamilyRelation}"></zw:basedictlist>
</select><fontcolor="red">*</font>
</td>
<!--属性5-->
<tdclass="content_table_td_centernowrap">
<inputid="sFamilyInsurancePlace${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].SFamilyInsurancePlace"class="content_content_input"maxlength="20"value="${personFamilyInfoList.SFamilyInsurancePlace}">
</td>
<!--属性6-->
<tdclass='content_table_td_centernowrap'>
<inputid="sFamilyResidencePalce${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].SFamilyResidencePalce"class="content_content_input"maxlength="20"value="${personFamilyInfoList.SFamilyResidencePalce}">
</td>
<!--属性7-->
<tdclass="content_table_td_centernowrap">
<inputid="sFamilyPhone${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].SFamilyPhone"class="content_content_input"maxlength="20"value="${personFamilyInfoList.SFamilyPhone}">
</td>
<!--属性8-->
<tdclass="content_table_td_centernowrap">
<inputid="dDentifySucessDate${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].DDentifySucessDate"value="${personFamilyInfoList.DDentifySucessDate}"onfocus="WdatePicker()"notnull="true"vdisp="首次参保时间"class="content_content_input"size="18"maxlength="18"style="width:70px;"/>
<fontcolor="red">*</font>
</td>
<!--属性9-->
<tdclass="content_table_td_centernowrap">
<inputid="dDentifyLostDate${st.count-1}"type="text"name="personFamilyInfoList[${st.count-1}].DDentifyLostDate"value="${personFamilyInfoList.DDentifyLostDate}"onfocus="WdatePicker()"notnull="true"vdisp="首次参保时间"class="content_content_input"size="18"maxlength="18"style="width:70px;"/>
</td>
<tdclass='content_table_td_centernowrap'>取消</td>
</tr>
</c:forEach>
</c:if>
</table>
</div>
</div>
</div>
<divclass="main_content_bg">
<divclass="main_content_title">
<tablestyle="width:100%">
<tr>
<tdwidth="100%"align="center">
<inputid="btnNextstep"type="button"value="上一步"class="modul_button_operate"onclick=""/>
<inputid="btnAdd"type="button"value="保存"class="modul_button_operate"onclick="saveOrUpdate()"/>
<inputid=""type="button"value="完成"class="modul_button_operate"onclick=""/>
<inputid="btnReturn"type="button"value="返回"class="modul_button_operate"onclick=""/>
</td>
</tr>
</table>
</div>
</div>
</form>
</div>
</body></span>
javascript函数：
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;"><scripttype="text/javascript">
$(function(){
loadCheck();
});
functionloadCheck(){
vartrs=$('#parttabletr').length;
if(trs==1){
addNewRow();
}
}
//初始变量
varnum=0;//页面计数变量
varrow=1;//行增加计数变量
varindex=2;//List列表计数变量
functionaddNewRow(){
vartrNum=$('#parttabletr').length;
if(trNum>1){
row=trNum;
num=trNum-1;
}
varhtmlText='<tr>'
+'<tdclass="content_table_number">'+row+'</td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="sFamilyName'+num+'"type="text"name="personFamilyInfoList['+num+'].SFamilyName"class="content_content_input"maxlength="20"></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="sFamilyIdcardNo'+num+'"type="text"name="personFamilyInfoList['+num+'].SFamilyIdcardNo"class="content_content_input"maxlength="20"></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<selectid="iFamilySex'+num+'"name="personFamilyInfoList['+num+'].IFamilySex">'
+'<zw:basedictlistitemCode="2000"selectValue="personFamilyInfoList['+num+'].IFamilySex"></zw:basedictlist>'
+'</select><fontcolor="red">*</font></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<selectid="sFamilyRelation'+num+'"name="personFamilyInfoList['+num+'].SFamilyRelation">'
+'<zw:basedictlistitemCode="135"selectValue="personFamilyInfoList['+num+'].SFamilyRelation"></zw:basedictlist>'
+'</select><fontcolor="red">*</font></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="sFamilyInsurancePlace'+num+'"type="text"name="personFamilyInfoList['+num+'].SFamilyInsurancePlace"class="content_content_input"maxlength="20"></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="sFamilyResidencePalce'+num+'"type="text"name="personFamilyInfoList['+num+'].SFamilyResidencePalce"class="content_content_input"maxlength="20"></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="sFamilyPhone'+num+'"type="text"name="personFamilyInfoList['+num+'].SFamilyPhone"class="content_content_input"maxlength="20"></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="dDentifySucessDate'+num+'"type="text"name="personFamilyInfoList['+num+'].DDentifySucessDate"onfocus="WdatePicker()"notnull="true"vdisp="首次参保时间"class="content_content_input"size="18"maxlength="18"style="width:70px;"/><fontcolor="red">*</font></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<inputid="dDentifyLostDate'+num+'"type="text"name="personFamilyInfoList['+num+'].DDentifyLostDate"onfocus="WdatePicker()"notnull="true"vdisp="首次参保时间"class="content_content_input"size="18"maxlength="18"style="width:70px;"/></td>'
+'<tdclass="content_table_td_centernowrap">'
+'<aonclick="delInsuranceInfo(this);">取消</a>'
+'</td>'
+'</tr>';
$("#parttable").append(htmlText);
num=num+1;
row+=1;
}
//删除动态列表
functiondelInsuranceInfo(t){
if(row>0){row=row-1}else{returnfalse;}
$(t).parent().parent().remove();
}
//保存或修改
functionsaveOrUpdate(){
$.ajax({
url:"personFamilyInfo_addOrUpdatePersonFamilyInfo_include_json.action",
type:"POST",
data:jQuery(document.forms[0]).serializeArray(),
success:function(resObj){
//判断返回值
if(resObj.trim()=='true'){
Ext.MessageBox.alert("提示","保存成功",function(){
});
}elseif(resObj.trim()=='update'){
Ext.MessageBox.alert("提示","更新成功",function(){
});
}else{
Ext.MessageBox.alert("提示","保存失败");
}
}
});
}</span>
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;"></script></span>
后台添加方法:
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;">/**
*<p>Description:批量添加多条信息</p>
*@parampersonFamilyInfoList实体列表
*@return布尔值，true为添加成功，否则为添加失败
*@throwsException
*@author:gaoying
*@update:
*@date:2015-7-20
*/
publicbooleanaddPersonFamilyInfo(List<PersonFamilyInfo>personFamilyInfoList)throwsException{
booleanbool=false;
if(personFamilyInfoList.size()>0&&personFamilyInfoList!=null){
for(inti=0;i<personFamilyInfoList.size();i++){
StringpersonFamilyID=UUIDHexGenerator.getUUID();
StringsunitGuid="11111111";
StringspersonGuid="0000000";
if(personFamilyInfoList.get(i)!=null){
personFamilyInfoList.get(i).setSGuid(personFamilyID);
personFamilyInfoList.get(i).setSUnitGuid(sunitGuid);
personFamilyInfoList.get(i).setSPersonGuid(spersonGuid);
personFamilyInfoList.get(i).setIsEnable(0);
personFamilyInfoList.get(i).setDOperateDate(newDate());
//设置系统的当前时间为生效时间，失效时间置为空
personFamilyInfoList.get(i).setDDentifySucessDate(newDate());
personFamilyInfoList.get(i).setDDentifyLostDate(null);
try{
StringsGuidString=personFamilyInfoService.saveNeedPk(personFamilyInfoList.get(i)).toString();
if(!"".equals(sGuidString)&&sGuidString.length()>0){
bool=true;
}else{
System.out.println("供养亲属信息表第"+i+"条信息存储失败！");
bool=false;
returnbool;
}
}catch(Exceptione){
e.printStackTrace();
}
}
}
}
returnbool;
}</span>
后台更新方法：
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;">/**
*<p>Description:批量更新信息</p>
*@parampersonFamilyInfolist实体列表
*@parampersonId人员id
*@return布尔值，true代表更新成功，否则更新失败
*@throwsException
*@author:gaoying
*@update:
*@date:2015-7-20
*/
publicvoidupdatePersonFamilyInfo(List<PersonFamilyInfo>personFamilyInfolist,StringpersonId)throwsException{
//根据人员id查询页面有多少条数据
List<PersonFamilyInfo>oldPersonFamilyInfolist=personFamilyInfoService.getPersonFamilyInfoByPersonId(personId);
intnum=oldPersonFamilyInfolist.size();
if(personFamilyInfolist!=null&&personFamilyInfolist.size()>0){
//检查页面的信息是否有修改，然后更新到数据库
for(inti=0;i<num;i++){
try{
//设置一个布尔值，如果变动字段设置为false,如果不变动则设置为true
booleanbool=true;
//判断哪些字段更改过
if(!oldPersonFamilyInfolist.get(i).getSFamilyName().equals(personFamilyInfolist.get(i).getSFamilyName())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getSFamilyIdcardNo().equals(personFamilyInfolist.get(i).getSFamilyIdcardNo())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getIFamilySex().equals(personFamilyInfolist.get(i).getIFamilySex())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getSFamilyRelation().equals(personFamilyInfolist.get(i).getSFamilyRelation())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getSFamilyInsurancePlace().equals(personFamilyInfolist.get(i).getSFamilyInsurancePlace())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getSFamilyResidencePalce().equals(personFamilyInfolist.get(i).getSFamilyResidencePalce())){
bool=false;
}
if(!oldPersonFamilyInfolist.get(i).getSFamilyPhone().equals(personFamilyInfolist.get(i).getSFamilyPhone())){
bool=false;
}
System.out.println("未更改前时间："+oldPersonFamilyInfolist.get(i).getDDentifySucessDate().getTime());
System.out.println("更改后的时间："+personFamilyInfolist.get(i).getDDentifySucessDate().getTime());
if(oldPersonFamilyInfolist.get(i).getDDentifySucessDate().getTime()!=personFamilyInfolist.get(i).getDDentifySucessDate().getTime()){
bool=false;
}
if(bool==false){//证明字段更改过
//更新数据前，要把原来没改动的数据复制一条，添加进数据库，把系统的当前时间设为该条数据的失效时间
PersonFamilyInfopersonFamilyInfo=newPersonFamilyInfo();
BeanUtils.copyProperties(oldPersonFamilyInfolist.get(i),personFamilyInfo);
System.out.println("该条数据主键："+personFamilyInfo.getSGuid());
personFamilyInfo.setSGuid(UUIDHexGenerator.getUUID());
System.out.println("设置主键："+personFamilyInfo.getSGuid());
personFamilyInfo.setDOperateDate(newDate());
//将当前保存数据库的是否有效置为1：无效
personFamilyInfo.setIsEnable(1);
personFamilyInfo.setDDentifyLostDate(newDate());
personFamilyInfoService.save(personFamilyInfo);
//更新该条数据，把系统的当前时间设为系统的生效时间和操作时间，是否有效设为0：有效，失效时间为空
personFamilyInfolist.get(i).setIsEnable(0);
personFamilyInfolist.get(i).setDDentifySucessDate(newDate());
personFamilyInfolist.get(i).setDOperateDate(newDate());
personFamilyInfolist.get(i).setDDentifyLostDate(null);
personFamilyInfoService.merge(personFamilyInfolist.get(i));
}
}catch(Exceptione){
e.printStackTrace();
}
}
}</span>
这样，java多字段、多条数据批量添加的例子就完成了，主要要注意前台页面叠加出现多行的js函数和后台的添加和更新方法，用list接收，循环遍历进行添加。除此之外这里我想说一下下面这段代码：
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;">$(function(){
loadCheck();
});</span>
它就是如下代码的缩写：
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;">$(document).ready(function(){
loadCheck();
});</span> 其实这个代码和下面的代码是一个意思：
<spanstyle="font-family:KaiTi_GB2312;font-size:14px;">window.onload=function(){
loadCheck();
}</span>
这样就不用在body的onload事件里面调用，只需要在js程序段里面编写就可以了。虽然下面的代码可以和上面两个互换，但他们之间又有不同。首先是执行时间不同，$(document).ready在页面框架下载完毕后就执行，而window.onload必须在页面全部加载完毕（包含图片下载）后才能执行。很明显前者的执行效率高于后者。再就是执行数量的不同，$(document).ready可以重复写多个，而且每次执行结果不同；而window.onload尽管可以执行多个，但仅输出最后一个执行结果，无法完成多个结果的输出。
以上就是本文的全部内容，希望对大家的学习有所帮助。