PDA

View Full Version : Connection to server using another jsp page



hongyi
08-15-2002, 08:44 AM
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;

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();



pls help....

LZS
08-15-2002, 09:08 AM
jia lac..don't know lei.Hope gt some more ppl visit lo..btw..mayb those ppl in tis website r foreigners in other country which is night time.jia u!