Problem With Solutions

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());
 	}
=================================