JDBC Error : No database selected

[Arati nargide]

Here is my code :

package dbdemo;
import java.sql.*;

public class DBDemo 
{

    public static void main(String[] args) throws Exception
    {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/","root","password");
        String sql = "select * from emp";
        Statement st = con.createStatement();
        ResultSet rst = st.executeQuery(sql);
        while(rst.next())
        {
            System.out.println(rst.getString(1)+" "+rst.getString(2));
        }
    }
}

I have added JDBC driver "mysql-connector-java-5.1.20-bin.jar".
Still its saying no Database selected.
Please help...

[Nicola Garofalo]

the problem should be here

jdbc:mysql://localhost:3306/

let's say you created a schema named mydb, the connection string must be

jdbc:mysql://localhost:3306/mydb

[Arati nargide]

Nicola Garofalo wrote:the problem should be here

jdbc:mysql://localhost:3306/

let's say you created a schema named mydb, the connection string must be

jdbc:mysql://localhost:3306/mydb

Oh, Thank you very much.

[Nicola Garofalo]

Let me know if it works.

Anyway that's mysql tutorial link on connecting to mySql using DriverManager

http://dev.mysql.com/doc/refman/5.6/en/connector-j-usagenotes-connect-drivermanager.html