Java: MYSQL -JDBC connection

To connect Java with MYSQL you can use bellow code but before using this code you have to download MYSQL-java Connector
Download MYSQL-JAVA Connector
Put this jar file in lib directory of your project


Port="3306";Host="root";Pw="";Db="database";
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url ="jdbc:mysql://localhost:"+Port+"/"+Db;
cn =DriverManager.getConnection(url,Host,Pw);
}
catch(Exception e)
{
return e+": Error in Connection";
}
return "OK";
}