JSP Insert Bean and multiple tables

1. JavaBean is a Java Class that follows certain naming convention. so whatever a Java Class can do, JavaBean can do.
2. in jsp, you can access any java object, you are not just limited to the beans.

>> Can i create a JavaBean that insert records in any table (saving time in future jsp's)?
theoretically yes. but practically no because the column count and data type is different.

>> Can i insert in more than one table within the JavaBean like i want to do?
of course, you can, just as you do in any regular java class.

you can try this

Build bean class by table b

public class MyBeanB {
  int id;
  int parentId;

  public MyBeanB () {
  }
 
  public void setId(int id) {
    this.id = id;
  }
  public int getId() {
    return this.id;
  }

  // same for parentId, alert for naming conventions for Beans
}

Build bean class by table a

public class MyBeanA {
  int id;
  int field;
  ArrayList childs; //this is list of childs of type MyBeanB

  public MyBeanA () {
  }
 
  public void setId(int id) {
    this.id = id;
  }
  public int getId() {
    return this.id;
  }

  // same for parentId, alert for naming conventions for Beans

  public MyBeanB getChild(int index) {
    return (MyBeanB) childs.get(index);
  }

  and so on...
}

BTW:
it's (by me) not good idea insert database operations in bean
better is write special object (in fact, this object will be a part of bussines logic, bean is mostly used for describing format of data and sending them)

public class DBHandler {
  public MyBeanA getObjectA(int id) {
    select from table a where Field_id_a = id
    MyBeanA bean = // create from db record
    select from table b where Field_id_a = id
    while records {
      MyBeanB beanb = // create from db record
      bean.addChild(beanb);
    }
  }
}

P.S> it's writed in "ultra" pseudo code, but maybe it helps you

Hi,

kennethxu first of all thanks for your comments.
Brcko your object DBHandler. Is it available from a JSP? Or is not necessary?