public long insert(Passageiro pass) {
		try {
			connection = Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();
			System.out.println(new SimpleDateFormat("yyyy/MM/dd").format(pass
					.getDataNascimento()));
			statement
					.executeUpdate("INSERT INTO TB_PASSAGEIRO ("
							+ "" + pass.getEndereco().getId() + ", "
							+ "'"+ pass.getNome() + "', "
							+ "'"+ pass.getEmail() + "', "
							+ "'"+ pass.getTelefone() + "', "
							+ "" + new SimpleDateFormat("yyyy/MM/dd").format(pass.getDataNascimento()) + ", "
							+ "'"+ pass.getNumeroCartao() + "', "
							+ "'"+ pass.getDocumento() + "')");
			connection.commit();
			System.out.println("INSERT COM SUCESSO.");

		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
			try {
				if (connection != null && !connection.isClosed()) {
					connection.rollback();
				}
			} catch (SQLException e2) {
				// TODO: handle exception
				e2.printStackTrace();
			} finally {
				try {
					if (resultSet != null) {
						resultSet.close();
					}
					if (statement != null) {
						statement.close();
					}
					if (connection != null) {
						connection.close();
					}
				} catch (Exception e3) {
					// TODO: handle exception
				}
			}
		}
		return pass.getId();

	}