oracle和sql数据库批量数据处理方法

1、SQL数据库批量数据处理方法

StringBuilder sb=new StringBuilder();
sb.Append("exec('update tb_TestVR set t_VolC =''" + volcVal + "'' where t_Battcode = ''" + battcodeVal + "''')");

2、ORACLE数据库批量数据处理方法

StringBuilder sb=new StringBuilder();
sb.Append("begin ");
sb.Append("execute immediate 'insert into T_DXZP01_CHILD (PALLETCODE,GUIDCODE,CELLCODE,CELLLOCATION) values (''{0}'',''{1}'',''{2}'',''{3}'')';");
sb.Append(" end;");