deleting multiple records using ibatis framework
843838Oct 12 2006 — edited Jan 18 2007The code i am using is
String deleteArray[ ] = request.getParameterValues("sel");
String selected= " " ;
if(deleteArray ! = null){
for(int i = 0; i < deleteArray.length ; i++){
selected += deleteArray [ i ];
if( i < deleteArray.length - 1){
selected += "," ;
}
}
}
I am using sqlMapClient of ibatis for connecting to database
sqlMapClient.delete("deleteMultipleRecords",selected);
In my xml file i use
<delete id="deleteMultipleRecords" parameterClass="java.lang.String">
delete from ADDRESS where id in (#value#)
</delete>
When i execute the above code , the delete query is not executing.Can anyone help me out.