problem with resultset

[seema prakash]

Hi,
I have a JTextField c_name. I have a focus listener added to this.I enter a value in this box and store this value in a variable cust_name. I pass this variable to the select statement to retrieve values from the database. The problem is I do not get all the rows. The resultset returns just one row( whichever it finds first). But when I execute the same statement in SOLPlus, the results are obtained(even duplicate rows).Please help and thanks in advance.

public void focusLost(FocusEvent e){
       myConnection theConn;
       theConn = new myConnection();
       theConn.Connect2Db();  
       cust_name = c_name.getText();
              try{
                String cmd; 
                if(cust_name.trim().length()==0){
                    clearValues();
                    return;
                }     
                cmd =  "select id, name from Customers where name =" + "'" + cust_name + "'";
                System.out.println("LINE1 "+cmd);
                
                ResultSet res;
                res = stat.executeQuery(cmd);
                
                while (res.next()) {
                 //   id.setText(res.getString(1));
                 //   name.setText(res.getString(2));
                    System.out.println("Id = "+ res.getInt(1)+"Name= "+res.getString(2) );
                } // end of while 
      
                }//end of try
                
                catch(SQLException sqle)   {
                    System.out.println("Database processing has failed.");
                    System.out.println("Reason: " + sqle.getMessage());
                    sqle.printStackTrace();
                }//end of catch
                finally {
                    theConn.disconnectDB();
                }//end of finally
      
              System.out.println("CUSTOMER name is " + cust_name);            
    }//end of focuslost
}//end of focuslistener

[seema prakash]

I got it working! I had not committed after inserting values in the table. Now the same code works fine