@Override
	public boolean create(Hotelier x) 
	{
          
                String req = "INSERT INTO hotelier ( email, motdepasse, siteweb, nomentreprise)\n" 
                    +"select \""+x.getEmail()+"\", \""+x.getMotDePasse()+"\", \""+x.getSiteweb()+"\", \""+x.getNomEntreprise()+"\" from dual\n" 
                    +"where not exists (select * from particulier where email = \""+x.getEmail()+"\")\n" 
                    +"and not exists (select * from hotelier where email = \""+x.getEmail()+"\")";
		Statement stm = null;
		try 
		{
			stm = cnx.createStatement(); 
			int n= stm.executeUpdate(req,Statement.RETURN_GENERATED_KEYS);
			if (n>0)
			{
                                x.setHotelierId(n);
				stm.close();
				return true;
			}
		}
		catch (SQLException exp)
		{
		}
		finally
		{
			if (stm!=null)
			try {
				stm.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}			
		}

		return false;
	}