???DBUnit?????????

?????????????????????ò?????????????????????????????????????????????????????????????????????????prepareData??????κ????DBUnit????????????????????????????????????????????????????????е???????????????????????????????????????е????????????????仯????????????prepareData??????????д?????????????????????????????????????

??????????????·????????????????Table??

create table YouTableName_1( filed_1 int?? filed_2 varchar2(50)?? filed_3 varchar2(50) )

?????????????????

<?xml version='1.0' encoding='UTF-8'?> <dataset> <YouTableName_1 Filed_1="1" Filed_2="f2" Filed_3="f3"/> <YouTableName_1 Filed_1="2" Filed_2="f2_1" Filed_3="f3_1"/> </dataset>

????????????????????????

<?xml version='1.0' encoding='UTF-8'?> <dataset> <YouTableName_1 Filed_1="1" Filed_2="a" Filed_3="a1"/> <YouTableName_1 Filed_1="2" Filed_2="b" Filed_3="b1"/> </dataset>

????????????????????????Filed_1?1???????Filed_2??Filed_3????ε????????"a"??"a1"????Filed_1?2???????Filed_2??Filed_3????ε????????"b"??"b1"???????????????????????????????????????????

?????????????UpdateTest????????????

import java.sql.Connection; import java.sql.SQLException; public class UpdateTest { private static boolean commit = true; public UpdateTest() { } private void commit(Connection conn) throws SQLException { if (commit) { conn.commit(); } } public void updateFiled(Connection conn) throws SQLException { conn.createStatement().execute("update YouTableName_1 set filed_2='a'??filed_3='a1' where filed_1=1"); conn.createStatement().execute("update YouTableName_1 set filed_2='b'??filed_3='b1' where filed_1=2"); commit(conn); } }