how can I have multiple return from this method?

[sahar sa]

hi,
I want the select method to select some data from DB and then return it . but i dont know how can I return multiple or a row of data ?
can you give me an idea how can i do it?

here is the code which i used for my select query:

 public static void delete(final String Name,final String Manfac, final double Pmax,final double Pmin,final double Pw,final double Qmax,final double Qmin,final double Qw,final double Deadline,final double Tw) 
    {   
        Connection con=null;
        PreparedStatement pstmt = null;
        
        try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        con= DriverManager.getConnection("jdbc:mysql://localhost/booktrading?"+"user=root&password=444");

             pstmt = con.prepareStatement("delete from tseller"+" where name=? and manfac=? and pmax=? and pmin=? and pw=? and qmax=? and qmin=? and qw=? and deadline=? and tw=?");
             pstmt.setString(1,Name);
             pstmt.setString(2,Manfac);
             pstmt.setDouble(3,Pmax);
             pstmt.setDouble(4,Pmin);
             pstmt.setDouble(5,Pw);
             pstmt.setDouble(6,Qmax);
             pstmt.setDouble(7,Qmin);
             pstmt.setDouble(8,Qw);
             pstmt.setDouble(9,Deadline);
             pstmt.setDouble(10,Tw);
             int row = pstmt.executeUpdate();
             System.out.println(row+" rows was effected");
             System.out.println("Good is deleted from DB: Name: "+Name +", "+Manfac+", "+"Quality:"+Qmax+", "+Qmin+", "+Qw+" Price:"+Pmax+", "+Pmin+", "+Pw+" Deadline:"+Deadline+", "+Tw);    
             pstmt.close();
             con.close();
        }
    
        catch (ClassNotFoundException e) 
        { 
        System.out.println(e.getMessage()); 
        e.printStackTrace();
        System.out.println("failed to connect to DB"); 
        System.exit(0);
        } 
        catch(SQLException ex)
        {
        System.out.println("SQLException: " + ex.getMessage());
        System.out.println("SQLState: " + ex.getSQLState());
        System.out.println("VendorError: " + ex.getErrorCode());
        }
        catch(Exception ex){ex.printStackTrace();}

    }}

thnx,
Sahar.

[Paul Sturrock]

You will need to go through your ResultSet and assign its values to a Collection of objects.

(And you've probably already noticed, but that is a delete statement, not a select query)