通过SQLPLUS 执行数据批处理
1、如addAutoData.sql文件的内容。

@"E:\workspace\naas\dbscript\transsystem\datasql\equipment.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\equipframe.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\equipslot.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\equippack.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\equiplogicport.sql" @"E:\workspace\naas\dbscript\transsystem\datasql\cc.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\en_topolink.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\re_sys_equip.sql"
@"E:\workspace\naas\dbscript\transsystem\datasql\domain_equip.sql"
2、如deleteAutoData.sql文件的内容
delete from cc;
delete from en_topolink;
delete from domain_equip;
delete from re_sys_equip;
delete from equiplogicport;
delete from equippack;
delete from equipslot;
delete from equipframe;
delete from equipment;
commit;
3、如deplay.sql文件的内容
@"E:\workspace\naas\dbscript\transsystem\datasql\deleteAutoData.sql" @"E:\workspace\naas\dbscript\transsystem\datasql\addAutoData.sql"
4、如文件的内容更
sqlplus naascs/naascs@naasdb10 @"E:\workspace\naas\dbscript\transsystem\datasql\deplay.sql"
5、在服务器上执行文件4，便可将上面表中的数据先清空后在比处理式的插入。