mysql connection in jsp

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

Leave a Comment