想做一个批量提交插入数据库,不过老是报空指针,求大神帮忙瞅瞅,下面贴代码
JSP代码:
<s:iterator value="listTmManage" status="s">
<tr class="row" onmouseover="this.className='overrow'" onmouseout="this.className='row'" align="center">
<input type="hidden" name="tmManageExs[<s:property value="#s.index" />].id" />
<td><s:property value="#s.index+1" /></td>
<td><input type="text" id="tmmanageex.tm_id" name="tmManageExs[<s:property value="#s.index" />].tm_id" value="<s:property value="id" /> "/></td>
<td><input type="text" id="tmmanageex.tz_id" name="tmManageExs[<s:property value="#s.index" />].tz_id" value="<s:property value="tz_id" />"/></td>
<td><input type="text" id="tmmanageex.record_id" name="tmManageExs[<s:property value="#s.index" />].record_id" value="${tzmanageex.record_id}" /></td>
<td align="left"><s:property value="tm_title" /></td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="1" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="2" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="3" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="4" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="5" /> </td>
</tr>
</s:iterator>
Actionpublic String subscore() throws Exception{
for(TmManageEx tmmanageex : tmManageExs){
this.tmManageExService.saveTmManageEx(tmmanageex, this.getUserInfo());
}
if (UtilAPI.isNull(tmmanageex)){throw new BusinessException("找不到该记录");}
return SUCCESS;
}
SpringMyBatisStrutsJava
JSP代码:
<s:iterator value="listTmManage" status="s">
<tr class="row" onmouseover="this.className='overrow'" onmouseout="this.className='row'" align="center">
<input type="hidden" name="tmManageExs[<s:property value="#s.index" />].id" />
<td><s:property value="#s.index+1" /></td>
<td><input type="text" id="tmmanageex.tm_id" name="tmManageExs[<s:property value="#s.index" />].tm_id" value="<s:property value="id" /> "/></td>
<td><input type="text" id="tmmanageex.tz_id" name="tmManageExs[<s:property value="#s.index" />].tz_id" value="<s:property value="tz_id" />"/></td>
<td><input type="text" id="tmmanageex.record_id" name="tmManageExs[<s:property value="#s.index" />].record_id" value="${tzmanageex.record_id}" /></td>
<td align="left"><s:property value="tm_title" /></td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="1" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="2" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="3" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="4" /> </td>
<td><input type="radio" id="tmmanageex.score" name="tmManageExs[<s:property value="#s.index" />].score" value="5" /> </td>
</tr>
</s:iterator>
Actionpublic String subscore() throws Exception{
for(TmManageEx tmmanageex : tmManageExs){
this.tmManageExService.saveTmManageEx(tmmanageex, this.getUserInfo());
}
if (UtilAPI.isNull(tmmanageex)){throw new BusinessException("找不到该记录");}
return SUCCESS;
}
SpringMyBatisStrutsJava
你既然用到Spring,那么首先你确定Mybatis对象注入成功了?
如果成功,好,再看MyBatis中所需的sql语句配置文件中是否有对应?
还没有问题的话,那么你看输入的值得类型是否匹配呢?
tmManageExs=new ArrayList<TmManageEx>();
for(int i=0;i<tmManageExs.size();i++){
tmmanageex=new TmManageEx();
tmmanageex.setTj_id(tmManageExs.get(i).getTj_id());
tmmanageex.setTm_id(tmManageExs.get(i).getTm_id());
tmmanageex.setTz_id(tmManageExs.get(i).getTz_id());
tmmanageex.setScore(tmManageExs.get(i).getScore());
this.tmManageExService.saveTmManageEx(tmmanageex, this.getUserInfo());
}
return SUCCESS;
}现在倒是不报异常了,但是数据还是没有插入
谢谢大家了,结贴散分~