@Override
	public Company find(long id) {
		
		String query = "SELECT * FROM company WHERE id="+id;
		ResultSet results = null;
		
		Connection connect = ConnectionMySql.getInstance();
		Company company = null;
		try (Statement stmt = connect.createStatement()){
			
			results = stmt.executeQuery(query);
			company = new Company();
			while (results.next())
			{
				company.setId(results.getLong("id"));
				company.setName(results.getString("name"));
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		} finally {
			if (connect!=null) {
				try {
					connect.close();
				} catch (SQLException e) {}
			}
			
			if (results!=null) {
				try {
					results.close();
				} catch (SQLException e) {}
			}
		}
		
		

		
		return company;
	}