关于JAVA解析文本的问题
文本文件为
set serveroutput on
spool c:\exchange.logs
begin
begin
savepoint sp113413097532810000;
update tbl_new_part set new_part_no='3406Z07-001-A',new_part_name='液力转向
泵',new_part_serial='',new_part_origin=0,new_part_amount=1,new_part_amount1=1,new_part_money=0.0,new_part_money1=0.0,new_part_manager=0.0,new_part_manager1=0.0,new_part_provider='81DL002',new_part_pname='大连液压件厂',new_part_price=421.57,ck_serial=2000008383,ck_number='' where new_part_id=2000007172;
commit;
DBMS_OUTPUT.PUT_LINE('执行成功—sp113413097532810000');
exception
when others then
rollback to sp113413097532810000;
DBMS_OUTPUT.PUT_LINE('执行失败—sp113413097532810000');
end;
begin
savepoint sp113413102387510000;
update tbl_new_part set new_part_no='3406Z07-001-A',new_part_name='液力;
转向泵',new_part_serial='',new_part_origin=0,new_part_amount=1,new_part_amount1=1,new_part_money=0.0,new_part_money1=0.0,new_part_manager=0.0,new_part_manager1=0.0,new_part_provider='81DL002',new_part_pname='大连液压件厂',new_part_price=421.57,ck_serial=2000008383,ck_number='' where new_part_id=2000007172;
commit;
DBMS_OUTPUT.PUT_LINE('执行成功—sp113413102387510000');
exception
when others then
rollback to sp113413102387510000;
DBMS_OUTPUT.PUT_LINE('执行失败—sp113413102387510000');
end;
begin
savepoint sp113413107653110000;
update tbl_new_part set new_part_no='3406Z07-001-A',new_part_name='液力;
转向泵',new_part_serial='',new_part_origin=0,new_part_amount=1,new_part_amount1=1,new_part_money=0.0,new_part_money1=0.0,new_part_manager=0.0,new_part_manager1=0.0,new_part_provider='81DL002',new_part_pname='大连液压件厂',new_part_price=421.57,ck_serial=2000008383,ck_number='' where new_part_id=2000007172;
update tbl_new_part set new_part_no='3406Z07-001-A',new_part_name='液力转向泵',new_part_serial='',new_part_origin=0,new_part_amount=1,new_part_amount1=1,new_part_money=0.0,new_part_money1=0.0,new_part_manager=0.0,new_part_manager1=0.0,new_part_provider='81DL002',new_part_pname='大连液压件厂',new_part_price=421.57,ck_serial=2000008383,ck_number='' where new_part_id=2000007172;
commit;
DBMS_OUTPUT.PUT_LINE('执行成功—sp113413107653110000');
exception
when others then
rollback to sp113413107653110000;
DBMS_OUTPUT.PUT_LINE('执行失败—sp113413107653110000');
end;
等等。
我需要逐行读取,并把其中的SQL语句解析出。放入stm.addbatch(sql);
有没有哪位能给个解决方案?
这里的读取已经没有问题。只需要把SQL分解出来。