The outer loop doesnt stop running

[Bulelakes]

if (userid.getText().equalsIgnoreCase("")) {
JOptionPane.showMessageDialog(null, "Type in your user id please!!");
userid.requestFocus();
} else {

try {

ps = connection.connection.prepareStatement("SELECT u.user_code, r.user_code FROM usr_pln_rghts r,users u");

String user = "";

ResultSet rs = ps.executeQuery();
while (rs.next()) {
x = userid.getText();
user = rs.getString("user_code");
usr = user.trim();
if (x.equals(usr)) {

ps = connection.connection.prepareStatement("Select U.user_code , P.plan_code , P.pln_prd_TCDE , U.PLN_BOT_LVL , U.DIM_CODE FROM PLAN_DETAIL P,USR_PLN_RGHTS U ");

ResultSet rec = ps.executeQuery();

while (rec.next()) {
String usercd = rec.getString("user_code");
String plancd = rec.getString("plan_code");
String plnprd = rec.getString("pln_prd_TCDE");
String plnbotlvl = rec.getString("PLN_BOT_LVL");
String dimcode = rec.getString("DIM_CODE");
model.addElement(usercd);
model.addElement(plancd);
model.addElement(plnprd);
model.addElement(plnbotlvl);
model.addElement(dimcode);

chooseplannameCmb.addItem(plancd);
queryResltList.add(usercd +";"+ plancd+";" + plnprd+";" + plnbotlvl+";" + dimcode);


}
connection.connection.close();
ps.close();

}

}


} catch (SQLException ex) {
Logger.getLogger(userAccessUI.class.getName()).log (Level.SEVERE, null, ex);
}

}

[Bulelakes]

i dont know what i did wrong in this code about. i need help plz

[Norm]

Have you tried debugging the code by printing out the variables to see what is being read at each place in the loop?

[Bulelakes]

oh the problem was that there were lot of records in the database that means it was still reading those records and after sometime it does stop.

[Bulelakes]

List queryResltList = new List();
List actionListList= new List();


//i can transfer one item :
//transfering from queryResltList to actionListList.

but now i want all items to be moved from one List to another by clicking the button.


if (e.getSource()==Btnname)
{
queryResltList.add(actionListList.getSelectedItem( ));
actionListList.remove(actionListList.getSelectedIn dex());

}
else if(e.getSource==Btnname)
{

// i need help here to transfer all items without selection.


}

[Norm]

A problem with your code as shown is the getSource() method returns a reference to the object sensing the event.
If your button were defined as follows:
Button buttonLabel = new Button(" a butn");

Then getSource would return a reference to the object pointed to by buttonLabel when the button was clicked.
e.getSource() == buttonLabel // the same values
This can be used in an actionPerformed method to determine which button was pressed.

[Bulelakes]

Norm

I need to know how to transfer all items from one List to another

i need the else if code leave the first if statement.

[Norm]

Does your first "if" statement work?

[Bulelakes]

Yes indeed but im using statement like this
Btnname is a button name
if (e.getSource()==Btnname)
{

}

[Norm]

if (e.getSource()==">")
{

That's not what you posted???
Wastes everyones time posting code that you are NOT using.

[Bulelakes]

im sorry i thought that was gona do the same thing
so can u plz help me with the second "if" statement.

[Bulelakes]

my user interface looks like this

[Norm]

Copy the code to the forum putting it inside of code tags to preserve the formatting.

[Bulelakes]

:confused:here is my code below:

//get the user code from the user and compare it with the one in database
                if (userid.getText().equalsIgnoreCase("")) {
                    JOptionPane.showMessageDialog(null, "Type in your user id please!!");
                    userid.requestFocus();
                } else {
                try {
                 reslts   ="SELECT u.user_code, r.user_code FROM usr_pln_rghts r,users u";
                    String user = "";
                     rs = statement.executeQuery(reslts);
                      while (rs.next()) {
                        x = userid.getText();
                        user = rs.getString("user_code");
                        usr = user.trim();
                        String usrcode=  x.trim();

         //if the user code matches the one in database display data where usercode is equal to the one entered by the user
                        if (x.equals(usr)) {
                             
                             userids = "select user_code , plan_code,pln_bot_lvl, dim_code from usr_pln_rghts "+
                                    " where user_code ="+"'"+usrcode+"'";
                                   
                            rec = statement.executeQuery(userids);                            
                             while (rec.next()) {
                               
                                String usercd = rec.getString("user_code");
                                String plancd = rec.getString("plan_code");
                                String plnbotlvl = rec.getString("PLN_BOT_LVL");
                                String dimcode = rec.getString("DIM_CODE");
                                model.addElement(usercd);
                                model.addElement(plancd);
                                model.addElement(plnbotlvl);
                                model.addElement(dimcode);
                                chooseplannameCmb.addItem(plancd);
                                
                   //display the the details in queryResultList.
                                queryResltList.add(usercd + ";" + plancd + ";"+ plnbotlvl + ";" + dimcode);
                              
                          

        }
                         
   }
//move selected item from queryResultList to  actionListList
      if (e.getSource()==cpyrytBtn)
        {     
             queryResltList.add(actionListList.getSelectedItem());
              actionListList.remove(actionListList.getSelectedIndex());

        }

//move all items from queryList to actionList
  if (e.getSource()==cpyallrytBtn)
            {

            // i need this code here please!!
           //i need the statement to copy all items
            

            }

[Norm]

The code you've posted looks like random bits and pieces copied from your program that left out a lot of things.
For example where are the variables: e, queryResltList, actionListList defined?

Where is the "outer loop that doesn't stop running?

A comment asks: //i need the statement to copy all items

Copy from where to where?

[Norm]

See post at http://www.java-forums.org/database/...tml#post139561

[Bulelakes]

Thank u so much for trying to help me ,finally i got it working below is my code:

 int i =actionListList.getSelectedIndex();
             String items[];
             while(i==-1)
              {

                   items =(String[]) actionListList.getItems();

                for(int j=0;j<items.length;j++){

                      queryResltList.add(items[j]);
                      actionListList.removeAll();
                }
                      break;

               }