How to fix "java.net.connectexception" exception in java using netbeans IDE...?

See more:

Java

SQL

i am trying to connect login page and sql database but it throws an exception that "com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception.
**BEGIN NESTED EXCEPTION**
java.net.ConnectException
MESSAGE: Connection refused:connect
STACKTRACE
..........."

Code:
String sql = "select * from login where username=? and password = ?";
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://MANOSHRI/testsql", "manoshri", "wamanbaba");
pst = con.prepareStatement(sql);
pst.setString(1, user.getText());
pst.setString(2, pass.getText());
rs = pst.executeQuery();
if(rs.next())
{
JOptionPane.showMessageDialog(null, "Username and password matched..");
}
else
{
JOptionPane.showMessageDialog(null, "Not matched");
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, ex);
}

What I have tried:

I am just a beginner so i didn't try anything...
Plzz help me in a simple way...