Below is my sql query I used... When I click on dropdown on my jsp webpage, and selec

[vinayshirish]

String sql1 = "select Products from [09RE]where RecName='Roasted Turkey Sandwich' and UU='uma'";
        Connection connection = getConnection();
        StringBuilder builder = new StringBuilder();
                try{
                    PreparedStatement statement = connection.prepareStatement(sql1);
 
                    ResultSet results = statement.executeQuery();
                    while(results.next()){
                        String Products = results.getString("Products");
                        String Product_list[] = Products.split(",");
 
 
                        String sql = "select id from [09PR] where ProdName=? and UU='uma'";
                        PreparedStatement statement1 = connection.prepareStatement(sql);
                        //statement1.setString(1, rc2.getProdName());
                        ResultSet results1 = statement1.executeQuery();
                        while(results1.next()){
                            String displaysql = sql;
                            String id = results1.getString("id");   
                                builder.append(Products+","+id);
                                String totalProducts = builder.toString();
                                String sql2 = "update [09RE] set Products ='" + totalProducts +"' where UU='uma'";
                                PreparedStatement statement2 = connection.prepareStatement(sql2);
 
                                statement2.executeQuery();
                            }
                    }
 
 
                    }catch (SQLException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    } finally {
                        closeConnection(connection);
                    }
 
        }

**
1.I have a jsp file which has dropdown containing product names which are fetched from the sql table. 2. My problem is, when i click the product name from the drop down, it should fetch the productID associated with the product name from the database and that product ID should be updated in another table. So everytime I select product name, it's product ID must be updated in another SQL table**

[chaarmann]

Why is line 15 commented out?
You are supposed to set the argument here which replaces the question mark in your sql in line 13.
You got all products in a list at line 10. So you must loop through this list one by one and each time call your sql.
There is a better way: you use the "in" statement if your DB supports it. Then you can fetch all IDs with one statement. I mean for example you can call:

select id from [09PR] where ProdName in ('myProduct1', 'product2', 'prod3') and UU='uma'

That means you must first transform you product array in a single string that represents a comma separated and single-quoted list of products, and then concatenate this string with your query string