Creating JDBC Connection in Java

Following are the steps to create JDBC connection in Java.

1. Register driver class.
2. Create connection object.
3. Create statement object.
4. Executing queriesoswd
5. Close connection.

Below are the code :

import java.sql.*;
class MysqlCon{
    public static void main(String args[]){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection(

                           "jdbc:mysql://localhost:3306/test","root","admin");
           //here test is database name, root is username and admin is  password 

            Statement stmt=con.createStatement();
            ResultSet rs=stmt.executeQuery("select * from emp");
            while(rs.next()) {
                System.out.println(rs.getInt(1) + ":" + rs.getString(2) + ":" + rs.getString(3));
            }
            con.close();

        }catch(Exception e){ System.out.println(e);}

    }
}