How can I resolve Database connection error with mysql?

1

Hello everyone,I don’t know why i am getting this error infact i write code write and also add java connector in my project. Please any one resolve my issue.
I have written this code for my project.
Thanks In Advance.
Regards: Michel John

import java.sql.*;
public class jbdcdemo {

    public static void main(String[] args) {

        try{
            //1. Get Connection to DB
            Connection myConn = DriverManager.getConnection("jbdc:msql://localhost:3306/world","root","1234");
            //2. Create a statement
            Statement myStmt = myConn.createStatement();
            //3. Execute sql query
            ResultSet myRs = myStmt.executeQuery("SELECT * FROM world.city;");      
            //4. Process the results
            while(myRs.next()){
                System.out.println(myRs.getString("Name")+", "+myRs.getString("District"));

            }
        }
        catch(Exception exc){

            exc.printStackTrace();
        }
    }
}
2

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.