for some reasons i couldn't use the CORD Layout
Will it take more memory and process speed if i pass the object like shown below
class DATAClass{
private
String dbName;
private String dbconn;
private Resultset rs;
public DATAClass(String databaseName, Connection conn) {
dbconn = conn;
dbName = databaseName);
}
public ResultSet GetMethod1(Connection conn, String id) throws SQLException {
CallableStatement sproc_stmt = conn.prepareCall("{call " + dbName + ".." + "PROC1" + " (?)}");
ResultSet sproc_result = DatabaseProxy.toResultSet(sproc_stmt);
return sproc_result;
}
public ResultSet GetMethod2(Connection conn, String id) throws SQLException {
}
..more methods here for each stored proc
}
class MAINClass {
public MAINClass(){
jbInit();
}
jbInit() {
DATAClass d1 = new DATAClass("dbname","conndetails");
//Invoke the first class and load components
Class1 c1 = new Class1(d1);
c1.load_components1();
}
}
import com.samples.DATAClass;
Class1 {
private DATAClass data1;
public Class1(DATAClass d1){
data1 = d1;
}
load_components1() {
EXECUTE data1.GetMethod1;
//Paint components
}
button_click() {
Class2 c2 = new Class2(data1, this);
}
}
import com.samples.DATAClass;
Class2 {
private DATAClass data2;
private Class1 c1;
public Class2(DATAClass data, Class1 class1 ){
data2 = data;
c1 = class1;
}
load_components2() {
data2.GetMethod2();
}
go_back() {
c1.load_components1();
}
}