@Test
public void dblist() throws SQLException {
String sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
List beans = null;
SQLExecutor.insert(sql, beans);
sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
SQLExecutor.update("bspf", sql, beans);
sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
SQLExecutor.delete("bspf", sql, beans);
}
@Test
public void dbobject() throws SQLException {
String sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
//
Object bean = null;
SQLExecutor.insert("bspf", sql, bean);
//
sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
//
SQLExecutor.update("bspf", sql, bean);
sql = "insert into xxxx(f1,f2,f3) values(#[f1],#[f2],#[f2])";
SQLExecutor.delete("bspf", sql, bean);
}
public void deletefiles() throws Exception {
SQLExecutor.delete("delete from filetable ");
SQLExecutor.delete("delete from CLOBFILE ");
}