Finally realized the Ibatis BULK INSERT, this method inserts 3,000 pieces of data, can save half the time than the single insert
XML code:
<InsertID= "Insertbatch"ParameterType= "ArrayList">Insert Intouser (id,account,password,active,status,name,gender,active_date,expiry_date,type,remark,group_id, Disable,exam_number,mobile) Values<foreachCollection= "List"Item= "obj"Index= "Index"Separator="," >(#{obj.id},#{obj.account},#{obj.password},#{obj.active},#{obj.status},#{obj.name},#{obj.gender},#{ Obj.active_date},#{obj.expiry_date},#{obj.type},#{obj.remark},#{obj.group_id},#{obj.disable},#{obj.exam_number },#{obj.mobile})</foreach></Insert>
In Java, you just need to pass the list over.
That's what I wrote:
Privatearraylist<map<string, string>>userlist =NewArraylist<map<string,string>>(); Map<string,string>usermap=NewHashmap<string,string>(); Usermap.put ("id", userId); Usermap.put ("Account", arr[0]); Usermap.put ("Password", PAS); Usermap.put ("Active", string.valueof (1)); Usermap.put ("Status", String.valueof (1)); Usermap.put ("Name", arr[1]); Usermap.put ("Gender", string.valueof (gender)); Usermap.put ("Active_date", active_date); Usermap.put ("Expiry_date", expiry_date); Usermap.put ("Type", String.valueof (3)); Usermap.put ("Remark",NULL); Usermap.put ("Group_id", string.valueof (1)); Usermap.put ("Disable", string.valueof (0)); Usermap.put ("Exam_number", arr[15]); Usermap.put ("PhoneNumber", arr[14]); Userlist.add (UserMap);
The data is added to the list by looping, and finally the list is passed.
Mybatis-spring Bulk implementation of data import database