Database Connection by using jsp page .
The URL based mysql connection is
=================================
jdbc:mysql://serverip address/DATABASENAME?user=USERNAME&password=PASSWORD
=================================
OR
=================================
<!– Database connection settings –>
<property name=”connection.driver_class”>com.mysql.jdbc.Driver</property>
<property name=”connection.url”>jdbc:mysql://localhost/database_name</property>
<property name=”connection.username”>databses_user</property>
<property name=”connection.password”>password</property>
<!– configuration pool via c3p0–>
=================================
OR
=================================
try { Class.forName("com.mysql.jdbc.Driver").newInstance(); // here we are connecting to localhost, port 3306. Change it to your db server address:port con = DriverManager.getConnection("jdbc:mysql://localhost:3306/databaseName", "root", "secret"); //or con = DriverManager.getConnection("jdbc:mysql://localhost:3306/databaseName?user= root&password=secret"; } catch(Exception e){ System.out.println(e.getMessage()); } =================================