Click to See Complete Forum and Search --> : calling application by menu and deploying application on internet


amitchitre
September 26th, 2000, 05:24 PM
I am developing a small application(like making
Forms and accessing it thru menus, same as in Oracle Forms 4.5)
in Java using Jbuilder3.5. I have created the menu and a simple
form(application) having insert, update and delete.
Both are working fine and also the JDBC connection for the data.

After doing this, I am having a few difficulties.

1. How to call this form(application) thru the menu?
2. Make the connection to the database globally.
That is I have made a class for connection

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("Jdbc:Odbc:sagro", "sagro", "sagro");

and I call this class when the menu is executed,
and the database is up. When I run the form, again I am giving
the above two statements and

SCode = FCode.getText();
SName = FName.getText();

String SInsert = "Insert into personal values('"+SCode+"', '"+SName+"')";

st= con.createStatement();
st.executeUpdate(SInsert);


same connect string that is used in createStatement().
Is this okay, cause I'll have to give the same in every form.
3. How to make a set of buttons like Insert, Update, Delete, as common.
So that, I need to create once and use it in all the forms?
4. How can I deploy the form and menu in the internet explorer or any browser?


thanks,

Amit