错误信息:
### Cause: java.sql.SQLSyntaxErrorException: Column 'sex' specified twice
问题原因如下: 当时还真没注意到多了个sex
<insert id="batchResultEntry" >
insert into result_entry
(
specimen_no,date_of_birth,
sex,id_no,pass_port_no,date_received,date_of_test,
date_of_report,type_of_specimen,type_of_specimen_one,
specimen_quantity,item_of_test, result,
value_of_reference,test_by,confirmed_by,
issued_by, test_date,confirmed_date,
issued_date,position,batch_no,name,
sex
) values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.specimenNo}, #{item.dateOfBirth},
#{item.sex},#{item.idNo},#{item.passPortNo}, #{item.dateReceived}, #{item.dateOfTest},
#{item.dateOfReport},#{item.typeOfSpecimen}, #{item.typeOfSpecimenOne} ,
#{item.specimenQuantity} ,#{item.itemOfTest} , #{item.result},
#{item.valueOfReference} ,#{item.testBy} ,#{item.confirmedBy} ,
#{item.issuedBy} ,#{item.testDate} ,#{item.confirmedDate} ,
#{item.issuedDate},#{item.position},#{item.batchNo},#{item.name},
#{item.sex}
)
</foreach>
</insert>
解决方案: 检查mapper.xml文件中的sql语句中是否出现重复的字段,多余的删除即可
注意: 还是太粗心了!!!