스프링

[Spring] ibatis 에서 insert all 할 때

배고파요 2023. 12. 8. 16:52
728x90

[VO]
public class TestVO{
private Integer idx;
private java.lang.String name;
private java.lang.String makeDate;
getter ~ setter~
}

[controller]
List<TestVO> testVOList = new ArrayList<>();
String retStr = testService.addInsertAll(testVOList);
// System.out.println(retStr); // null 로 나옴.

[DAO]
public String addInsertAll(List<TestVO> testVOList) throws Exception{
return (String) insert(“testDAO.addInsertAll”, testVOList);
}


[XML]
<sqlMap>
<insert id=“testDAO.addInsertAll” parameterClass=“java.util.List”>
INSERT ALL
<iterate conjunction= “ “>
INTO TB_TEST (IDX, NAME, MAKE_DATE)
VALUES (
#[].idx#
, #[].name#
, SYSDATE
)
</iterate>
SELECT 1 FROM DUAL
</insert>
</sqlMap>

728x90