Bdtjtk

i have been trying to retrive data from mysql in the list and that is working fine but the problem is i'm not able to select the name of the list..
i want to select name (not index or value) so that i can complete my where clause

Here is my Code :-

private void proceed(){



    PreparedStatement stmt = null;

    Connection conn = null;

    ResultSet rs=null;



    String i = jList1.getSelectedValue();









    try    {



     Class.forName("java.sql.DriverManager");



     conn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/hotel","root","root");



      stmt = conn.prepareStatement("select * from hotelbookings where GuestName = '"+i+"'");



    rs = stmt.executeQuery();



    if (rs.next()){



    String BN = rs.getString("BookNo");

    String GN = rs.getString("GuestName");

    String AD = rs.getString("Address");

    String NOD = rs.getString("No_of_Days");

    String PN = rs.getString("PhoneNo");

    String ID = rs.getString("ID_Proof");

    String CN = rs.getString("Country");

    String ARD = rs.getString("Arival_Date");

    String DRD = rs.getString("Departure_Date");



    NewJFrame1_1 second = new NewJFrame1_1(BN,GN,AD,NOD,PN,ID,CN,ARD,DRD);

    second.setVisible(true);



    }



} catch(Exception e){

 JOptionPane.showMessageDialog(null, e);

}





}

Here is the image of my list ..Show List retreives the data from mysql ..and proceed button is used to take the selected name for modification

Here is The code for Show List Button:-

private void fillList(){



        PreparedStatement stmt = null;

        Connection conn = null;





         try    {

         Class.forName("java.sql.DriverManager");



         conn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/hotel","root","root");



          stmt = conn.prepareStatement("select GuestName from hotelbookings");



         stmt.executeQuery();



             ResultSet rs = stmt.getResultSet();

             int i =0;

             DefaultListModel info = new DefaultListModel();



             while (rs.next()){

                 String data = new String[100];

                 data[i] = rs.getString("GuestName");

                 jList1.setModel(info);

                 info.addElement(data[i]);

                 i = i + 1;

                 jList1 = new JList(info);

             }



}

      catch(Exception e){



                JOptionPane.showMessageDialog (this, e.getMessage());

}









    }

fillList class:-

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

     fillList();

}

private void fillList(){



PreparedStatement stmt = null;

Connection conn = null;



try    {

    Class.forName("java.sql.DriverManager");

    conn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/hotel","root","root");

    stmt = conn.prepareStatement("select GuestName from hotelbookings");

    stmt.executeQuery();

    ResultSet rs = stmt.getResultSet();

    int i =0;

    DefaultListModel info = new DefaultListModel();



    while (rs.next()){

        String data = new String[100];

        data[i] = rs.getString("GuestName");

        info.addElement(data[i]);

        i = i + 1;

    }

    jList1 = new JList(info);

} catch(Exception e){

    JOptionPane.showMessageDialog (this, e.getMessage());

}



}