public void insert(Endereco end){
		try {
			connection = Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();
			statement.executeUpdate("INSERT INTO TB_ENDERECO VALUES (" +
									""  +end.getId()+", "+
									"'" +end.getRua() + "', " +
									""  +end.getNumero() + ", " +
									"'" +end.getComplemento() +"', " +
									"'" +end.getBairro() +"', " +
									"'" +end.getCidade() +"', " +
									"'" +end.getEstado() +"', " +
									"'" +end.getPais() +"')");
			connection.commit();
			System.out.println("INSERT TB_ENDERECO FEITO 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
				}
			}
			}
		}