package com.sample;

import java.sql.*;

public class DbRetriveOperation {

public static void main(String[] args) throws SQLException {

// TODO Auto-generated method stub

Connection con = null;

try{

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","root");

System.out.println("Connected Successfully........!");

}

catch(Exception e)

{

System.out.println(e);

}

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select * from user_data;");

while(rs.next()) {

System.out.print("Name:"+rs.getString(1)+"\t");

System.out.print("Eamil:"+rs.getString(2)+"\t");

System.out.print("Phone:"+rs.getInt(3)+"\t");

System.out.println(" ");

}

con.close();

}

}