user java classes

retrive

package retrive;
import java.util.Iterator;
import java.util.Set;
import java.util.LinkedHashSet;
import java.util.TreeSet;
import java.sql.*;
import beans.userdata;
import sql.connection;

public class retriveuser {
    
   public Set getuser(){
       Set user=new LinkedHashSet();
        try{
            connection conn=new connection();
        Connection con=conn.getconnection();
        Statement stat=con.createStatement();
        ResultSet rs=stat.executeQuery("Select * from usertable");
        while(rs.next()){
            String sno=rs.getString(1);
            String tiitle=rs.getString(2);
            String first_name=rs.getString(3);
            String middle_name=rs.getString(4);
            String last_name=rs.getString(5);
            String password=rs.getString(6);
            String dob=rs.getString(7);
            String gender=rs.getString(8);
            String address=rs.getString(9);
            String pin=rs.getString(10);
            String telephone=rs.getString(11);
            String mobile=rs.getString(12);
            String email=rs.getString(13);
            String city=rs.getString(14);
            String state=rs.getString(15);
            String country=rs.getString(16);
            userdata user_data=new userdata();
            user_data.setsno(sno);
            user_data.settitle(tiitle);
            user_data.setfirstname(first_name);
            user_data.setmiddlename(middle_name);
            user_data.setlastname(last_name);
            user_data.setpassword(password);
            user_data.setdob(dob);
            user_data.setgender(gender);
            user_data.setaddress(address);
            user_data.setpin(pin);
            user_data.settelephone(telephone);
            user_data.setmobile(mobile);
            user_data.setemail(email);
            user_data.setcity(city);
            user_data.setstate(state);
            user_data.setcountry(country);
            user.add(user_data);
        }}catch(Exception ex){
            
        }
        return user;
   }
   public static void main(String args[]){
       retriveuser retrive_user=new retriveuser();
       Set user=retrive_user.getuser();
       Iterator iterator=user.iterator();
       while(iterator.hasNext()){
           userdata user_data=(userdata)iterator.next();
           System.out.println(user_data.getsno());
           System.out.println(user_data.gettitle());
           System.out.println(user_data.getfirstname());
           System.out.println(user_data.getmiddlename());
           System.out.println(user_data.getlastname());
           System.out.println(user_data.getpassword());
           System.out.println(user_data.getdob());
           System.out.println(user_data.getgender());
           System.out.println(user_data.getaddress());
           System.out.println(user_data.getpin());
           System.out.println(user_data.gettelephone());
           System.out.println(user_data.getmobile());
           System.out.println(user_data.getemail());
           System.out.println(user_data.getcity());
           System.out.println(user_data.getstate());
           System.out.println(user_data.getcountry());
       }
   }
    
}

Please send comments to vgdarur.javafive@blogger.com