Recherche dans une bdd (java)

package fou.tuto;
import java.sql.*;
 

public class FirstWebService {
	
	public String AddTwoNumbers (String Compare) throws Exception{
		
	//accedivate er au driver par le jar file 
Class.forName("com.mysql.jdbc.Driver"); 
		
	//creation d'une variable de connection appelé con
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost/names","root","");
		
	//creation de notre query 
		PreparedStatement stat = con.prepareStatement("Select * from noms Where nom='"+Compare+"'");
		
	//creation d'une variable pour executer le query
		
		ResultSet result = stat.executeQuery();
		 
		 String find = null;
		 
		 while (result.next()){
			 find = result.getString(1);
			 find=""+find+" ";
		 }

		return find;
		
		}}

PreparedStatement stat = con.prepareStatement("Select * from noms Where lieu='"+Compare+"'");

Compare = "lieu='Paris' ";
Compare = "nom='Machine' "; /* là où tu récupères ta variable */

PreparedStatement stat = con.prepareStatement("Select * from noms Where "+Compare);

package fou.tuto;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JButton;
import fou.tuto.FirstWebServiceStub.AddTwoNumbers;
import fou.tuto.FirstWebServiceStub.AddTwoNumbersResponse;
import java.awt.Color;
import java.rmi.RemoteException;



public class Interface_test extends JFrame {

	private static final long serialVersionUID = 1L;
	private JPanel jContentPane = null;
	private JTextField jTextField = null;
	private JTextField jTextField1 = null;
	private JButton jButton = null;
	/**
	 * This is the default constructor
	 */
	public Interface_test() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(627, 312);
		this.setContentPane(getJContentPane());
		this.setTitle("Recherche medecin");
		this.setBackground(Color.YELLOW);
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.setBackground(Color.magenta);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(59, 85, 158, 27));
			jTextField.setText("");
			jTextField.setBackground(Color.cyan);
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(328, 85, 166, 27));
			jTextField1.setText("");
			jTextField1.setBackground(Color.cyan);
		}
		return jTextField1;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(215, 168, 156, 34));
			jButton.setText("RECHERCHE");
			jButton.setBackground(Color.cyan);
			jButton.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked (java.awt.event.MouseEvent e) {
					FirstWebServiceStub stub;
					AddTwoNumbers atn = new AddTwoNumbers();
					String affich =	jTextField.getText();
					atn.setCompare(affich);
					  
					try {AddTwoNumbersResponse res;
					stub = new FirstWebServiceStub();
						res = stub.addTwoNumbers(atn);
						String cmp = res.get_return();
						SuccesDialog dialog1 = new SuccesDialog(null);
						
							dialog1.getjTextArea().setText(cmp);
							dialog1.setVisible(true);
						
					} catch (RemoteException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					} catch (FirstWebServiceExceptionException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
					   // TODO Auto-generated Event stub mouseClicked()
				}
			});
		}
		return jButton;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"

package fou.tuto;

import javax.swing.JPanel;

import java.awt.Color;
import java.awt.Font;
import java.awt.Frame;
import javax.swing.JDialog;
import javax.swing.JTextArea;
import java.awt.Rectangle;

public class SuccesDialog extends JDialog {

	private static final long serialVersionUID = 1L;
	private JPanel jContentPane = null;
	private JTextArea jTextArea = null;
	/**
	 * @param owner
	 */
	public SuccesDialog(Frame owner) {
		super(owner);
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(456, 200);
		this.setContentPane(getJContentPane());
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJTextArea(), null);
			jContentPane.setBackground(Color.YELLOW);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextArea	
	 * 	
	 * @return javax.swing.JTextArea	
	 */
	private JTextArea getJTextArea() {
		if (getjTextArea() == null) {
			Font f = new Font("Serif", Font.PLAIN, 25); 
			
			setjTextArea(new JTextArea());
			getjTextArea().setBounds(new Rectangle(57, 68, 324, 100));
			getjTextArea().setText(" Ce nom existe dans notre bdd!!!");
			getjTextArea().setForeground(Color.RED);
			getjTextArea().setBackground(Color.YELLOW);
			getjTextArea().setFont(f);
			
		}
		return getjTextArea();
	}

	public void setjTextArea(JTextArea jTextArea) {
		this.jTextArea = jTextArea;
	}

	public JTextArea getjTextArea() {
		return jTextArea;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"

package fou.tuto;
import java.rmi.RemoteException;

 
public class TestClient {
 
 public static void main(String[] args) throws RemoteException, FirstWebServiceExceptionException {
   
  
  Interface_test inter = new Interface_test();
	inter.setVisible(true);
  
  
 }


}