public void cargarProductos() {
        try {
            String sql = "SELECT * FROM productos";
            Connection conn = Conexion.GetConnection();
            PreparedStatement ps = conn.prepareStatement(sql);

            pro = ps.executeQuery();

            while (pro.next()) {
                String[] row = {pro.getString(1), pro.getString(2), pro.getString(3), pro.getString(4), pro.getString(5), pro.getString(6)};
                tmprod.addRow(row);
            }
            jTableProductos.setModel(tmprod);

        } catch (SQLException e) {
            JOptionPane.showMessageDialog(this, e.getErrorCode() + ": " + e.getMessage());
        }
    }