calling application by menu and deploying application on internet
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