Java SQLExecutor.delete Examples

Example #1

File: SimpleApiTest.java Project: GitHub9527/bbossgroups-3.5

  @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);
  }

Example #2

File: SimpleApiTest.java Project: GitHub9527/bbossgroups-3.5

  @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);
  }

Example #3

File: TestLob.java Project: sedricd/bbossgroups-3.5

  public void deletefiles() throws Exception {

    SQLExecutor.delete("delete from filetable ");
    SQLExecutor.delete("delete from CLOBFILE ");
  }