package database.migration.etape0.status_chambre;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import database.dataset.Status_chambre;

public class ReadStatusChambre {

	public static List<Status_chambre> from(Connection connection) throws SQLException{
		System.out.println("import status chambre");
		List<Status_chambre> lst = new ArrayList<>();
		
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM statut");
		while(rs.next()){
			int id = rs.getInt("ID");
			String status = rs.getString("statut");
			
			Status_chambre stch = new Status_chambre(id, status);
			lst.add(stch);
		}
		lst.add(new Status_chambre(10, "EN REPARATION"));
		lst.add(new Status_chambre(11, "CACHE"));
		
		return lst;
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}