August 15th, 2002, 04:12 AM
Connection to server using another jsp page
Currently, i have hardcoded the server connection in every page and is very tedious if there are any changes to it.
Therefore, i need to know how to connect to the server by calling up a page that contains the server information.
The coding i have now is:
String connectionURL = "jdbc:mysql://servername/databaseName?user=username to enter the server & password=password to enter the server";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();
August 15th, 2002, 01:36 PM
You can use the <%@ include file="" %> tag to include a file into your jsp's. Take whatever code you have duplicated in many jsp files, put it in a single file, and then replace the code in your pages with the include tag.
August 15th, 2002, 08:38 PM
Thanks preaney for ur help....
i have another question, it is to display retrieved data in certain number of rows.
if possible, pls help....