Confinement and chromoelectric flux tubes in lattice QCD