Java

How 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);}

    }
}