package database.migration.etape3.encaissement;

import java.math.BigDecimal;
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.Encaissement;

public class ReadEncaissement {
	
	public static List<Encaissement> from(Connection connection) throws SQLException{
		System.out.println("import encaissement");
		List<Encaissement> lst = new ArrayList<>();
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM encaissement");
		while(rs.next()){
			int id = rs.getInt("ID");
			int id_facture = rs.getInt("ID_facture");
			int id_methode = rs.getInt("methode");
			BigDecimal montant = rs.getBigDecimal("montant");
			
			lst.add(new Encaissement(id, 
					  				 id_facture, 
					                 id_methode, 
					                 montant));
		}
		return lst;
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}