How to get data from MySQL using Jcombo Box

[Amillia89]

hye...I'm having a problem to retrieve data from Jcombo Box...
the combo box have a list from A-Z..for example when the user pick 'A' from the list,it will get all the A% data from MySQL

this is the code that i have right now.

JButton Edit = new JButton ("EDIT SYNONYM");
                Edit.setMnemonic('d');
		Edit.addActionListener(
                new ActionListener()
		{   JButton BACK;

                    public void actionPerformed(ActionEvent e)
			{

                         JFrame alphabet=new JFrame("Malay Synonym Word Checker - EDIT WORD");
                         alphabet.getContentPane().setLayout(null);
                         JLabel lbl1 = new JLabel("Select alphabet");
                         final String [] alpha = {"a","b","c","d","e","f","g","h","i","j","k","l","m" ,"n","o","p","q","r","s","t","u","v","w","x","y","z"};
                         JComboBox huruf= new JComboBox(alpha);
                         JLabel lbl2 = new JLabel("Words");
                         final JTextField jt1=new JTextField(15);
                         huruf.setSelectedIndex(0);
                         lbl1.setBounds(50,50,100,20);
                         huruf.setBounds(170,50,100,20);
                         lbl2.setBounds(50,80,70,20);
                         jt1.setBounds(170,80,100,20);
                         
                         huruf.addActionListener(new ActionListener() {                         
                          public void actionPerformed(ActionEvent e) {
                              ItemSelectable is = (ItemSelectable)e.getSource();
                               String st= selectedString(is);
                               try{
                                   
                                 Class.forName("com.mysql.jdbc.Driver");
                                 Connection con = DriverManager.getConnection("jdbc:mysql://localhost/finalproject", "root", "pwd");
                                 Statement st=con.createStatement();
                                 String pick = "select * from synonym where words like =%'"+st+"'";
                                 
                                 }
                              

                          

                        }

                    });

                    
                }

                alphabet.setLayout(new BorderLayout());
                BACK = new JButton("Back");
                BACK.setBounds(340, 170, 83, 28);

                alphabet.add(BACK, BorderLayout.SOUTH);
                
                alphabet.add(BACK, BorderLayout.SOUTH);
                
                alphabet.setVisible(true);
                alphabet.setSize(450,250);
                    }
                }
                );

[masijade]

That statement reads as follows

= %'A'

you wanted

= 'A%'

correct?

[mKorbel]

there are completed infos about that

http://download.oracle.com/javase/tutorial/jdbc/index.html

some expamples on

http://www.java2s.com/Code/Java/Database-SQL-JDBC/CatalogDatabase-SQL-JDBC.htm

and there is MySql tutorial also

http://www.java2s.com/Code/SQL/CatalogSQL.htm

[Amillia89]

That statement reads as follows

= %'A'

you wanted

= 'A%'

correct?

no,what i mean is the system will get the input from the user...

[stultuske]

masjiade was referring to this:

String pick = "select * from synonym where words like =%'"+st+"'";

are you sure you don't need to place the % behind the user selected String?

[Amillia89]

masjiade was referring to this:

String pick = "select * from synonym where words like =%'"+st+"'";

are you sure you don't need to place the % behind the user selected String?

yup2...what i want is A%....sorry2..i get confused..huhu~