import java.sql.*;
import java.util.ArrayList;
class  Retrieve{
public static void main(String[] args){
    try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from employee");

           ArrayList<String> list=new ArrayList<String>();
             while(rs.next()){
             list.add(rs.getString("name"));
              }
           for(int i=0;i<list.size();i++){
           System.out.println(list.get(i).toString());
           }
    }
    catch(Exception e){
    System.out.println(e);
    }

    }
}