public void limpar() throws SQLException {
        String sql = "truncate pedidos";
        PreparedStatement stmt = this.conexao.prepareStatement(sql);
        stmt.execute();
        stmt.close();
    }