예제 #1
0
  @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);
  }
예제 #2
0
  @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);
  }
예제 #3
0
  public void deletefiles() throws Exception {

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