Classes constructeurs et ArrayList

package hotelClasses;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DataClass {
		
	private String driver;
	private String url;
	private String user;
	private String password;
	public Statement st;
	public ResultSet rs;
	Connection connexion;
	
	public DataClass(){
		this.driver="com.mysql.jdbc.Driver";
		this.url="jdbc:mysql://localhost:3306/basehotel";
		this.user="root";
		this.password="";
		
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
			connexion=DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void reqUpdate(String req){
		
		try {
			st=connexion.createStatement();
			st.executeUpdate(req);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}			
		
	}
	
	public ResultSet reqSelect(String req){
		try {
			//st=connexion.createStatement();
			st = connexion.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
		} catch (SQLException e) { }
		
		try {
			rs=st.executeQuery(req);
		} catch (SQLException e) { }
			
		return rs;	
	
	}
	
}

package hotelClasses;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

import javax.swing.JFrame;
import javax.swing.JOptionPane;

public class Reservation {

private int numReservation;
private Date dateReservation;
private Date dateArrivee;
private Date dateSortie;
private int nbrNuits;
private int nbrChambre;
private String cniClient;
private Chambre chbre;

DataClass dc=new DataClass();


public int getNumReservation() {
	return numReservation;
}
public void setNumReservation(int numReservation) {
	this.numReservation = numReservation;
}
public Date getDateReservation() {
	return dateReservation;
}
public void setDateReservation(Date dateReservation) {
	this.dateReservation = dateReservation;
}
public Date getDateArrivee() {
	return dateArrivee;
}
public void setDateArrivee(Date dateArrivee) {
	this.dateArrivee = dateArrivee;
}
public Date getDateSortie() {
	return dateSortie;
}
public void setDateSortie(Date dateSortie) {
	this.dateSortie = dateSortie;
}
public int getNbrNuits() {
	return nbrNuits;
}
public void setNbrNuits(int nbrNuits) {
	this.nbrNuits = nbrNuits;
}
public int getNbrChambre() {
	return nbrChambre;
}
public void setNbrChambre(int nombreChambre) {
	this.nbrChambre = nombreChambre;
}
public String getCniClient() {
	return cniClient;
}
public void setCniClient(String cniClient) {
	this.cniClient = cniClient;
}

public Chambre getChbre() {
	return chbre;
}
public void setChbre(Chambre chbre) {
	this.chbre = chbre;
}

public Reservation() {
	super();

}
public Reservation(Date dateReservation, Date dateArrivee,
		Date dateSortie, int nbrNuits,int nbrChambre,String cniClient) {
	super();
//	this.numReservation = numRes++;
	this.dateReservation = dateReservation;
	this.dateArrivee = dateArrivee;
	this.dateSortie = dateSortie;
	this.nbrNuits = nbrNuits;
	this.nbrChambre=nbrChambre;
	this.cniClient=cniClient;
}

public void ajouterReservation(Date dateReservation,Date dateArrivee,Date dateSortie,int nbrNuits,int nbrChambre,String cniClient){
	SimpleDateFormat sdf=new SimpleDateFormat("dd/MM/yyyy");
	
	dc.reqUpdate("insert into 'reservation'('dateReservation','dateArrivee','dateSortie','nbrNuits','nbrchambre','cniClient') " +
			"values ('"+sdf.format(dateReservation)+"','"+sdf.format(dateArrivee)+"','"+sdf.format(dateSortie)+"','"+nbrNuits+"','"+nbrChambre+"','"+cniClient+"')");
	
}

public int dernierNumRes() throws SQLException{
	int numRes=0;
	dc.reqSelect("select numReservation from reservation order by numReservation desc limit 1");
	dc.rs.first();
	if(dc.rs.getRow()>0){
			 numRes=dc.rs.getInt("numReservation");
			 }
	
	return numRes;
}

public void modifierReservation(int numReservation,Date dateReservation,Date dateArrivee,Date dateSortie,int nbrNuits,int nbrChambre,String cniClient) throws SQLException{
String msg;
dc.reqSelect("select * from reservation where numReservation='"+numReservation+"'");
dc.rs.first();
if(dc.rs.getRow()>0){
  dc.rs.updateDate("dateReservation", (java.sql.Date) dateReservation);
  dc.rs.updateDate("dateArrivee", (java.sql.Date) dateArrivee);
  dc.rs.updateDate("dateSortie", (java.sql.Date) dateSortie);
  dc.rs.updateInt("nbrNuits", nbrNuits);
  dc.rs.updateInt("nbrChambre", nbrChambre);
  dc.rs.updateString("cniClient", cniClient);
   
  dc.rs.updateRow();
  msg="La modification a été réalisée avec succès";
}
else{
	   msg="Cette reservation n'existe pas";	  
}

JFrame msgDial=new JFrame();
JOptionPane.showMessageDialog(msgDial, msg);

  dc.rs.close();
  dc.st.close();

}

package hotelClasses;

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.swing.JFrame;
import javax.swing.JOptionPane;

public class Chambre {
	private int idChambre;
	private String typeChambre;
	private String disponibilite;
	private int etage;
	private double prix;
	private int numReservation;

	
	DataClass dc=new DataClass();
	public String msg;
	
	public String typeCh;
	public String disp;
	public int etag;
	public double pr;
	public int numRes;
	
	public int getIdChambre() {
		return idChambre;
	}
	public void setIdChambre(int idChambre) {
		this.idChambre = idChambre;
	}
	public String getTypeChambre() {
		return typeChambre;
	}
	public void setTypeChambre(String typeChambre) {
		this.typeChambre = typeChambre;
	}
	public String isDisponibilite() {
		return disponibilite;
	}
	public void setDisponibilite(String disponibilite) {
		this.disponibilite = disponibilite;
	}
	public int getEtage() {
		return etage;
	}
	public void setEtage(int etage) {
		this.etage = etage;
	}
	public double getPrix() {
		return prix;
	}
	public void setPrix(double prix) {
		this.prix = prix;
	}

	public int getNumReservation() {
		return numReservation;
	}
	public void setNumReservation(int numReservation) {
		this.numReservation = numReservation;
	}
	
	
	public Chambre() {
		super();
		// TODO Auto-generated constructor stub
	}
	
	public Chambre(int idChambre, String typeChambre, String disponibilite,
			int etage,double prix, int numReservation) {
		super();
		this.idChambre = idChambre;
		this.typeChambre = typeChambre;
		this.disponibilite = disponibilite;
		this.etage = etage;
		this.prix=prix;
		this.numReservation = numReservation;
	}
	
	public void ajouterChambre(int idChambre,String typeChambre,int etage,double prix){
			
		dc.reqUpdate("insert into 'chambre'('idChambre','typeChambre','etage','prix') " +
				"values ('"+idChambre+"','"+typeChambre+"','"+etage+"','"+prix+"')");
	}
	
	public void modifierChambre(int idChambre,String typeChambre,int etage,double prix) throws SQLException{

		dc.reqSelect("select * from chambre where idChambre='"+idChambre+"'");
		dc.rs.first();
		if(dc.rs.getRow()>0){
		  dc.rs.updateInt("idChambre", idChambre);
		  dc.rs.updateString("typeChambre", typeChambre);
		  dc.rs.updateInt("etage", etage);
		  dc.rs.updateDouble("prix", prix);
				 
		  dc.rs.updateRow();
		  msg="La modification a été réalisée avec succès";
		}
		else{
			   msg="Cette chambre n'existe pas";	  
		}

		JFrame msgDial=new JFrame();
		JOptionPane.showMessageDialog(msgDial, msg);

		  dc.rs.close();
		  dc.st.close();

		}
	
	public void supprimerChambre(int idChambre){
		dc.reqUpdate("delete from 'chambre' where idChambre='"+idChambre+"'");
	}
	
	public void rechercherChambre(int idChambre) throws SQLException{
		dc.reqSelect("select * from chambre where idChambre='"+idChambre+"'");
		dc.rs.first();
		if(dc.rs.getRow()>0){
				 typeCh=dc.rs.getString("typeChambre");
				 etag=dc.rs.getInt("etage");
				 pr = dc.rs.getDouble("prix");
				 }
		else{
			msg="Cette chambre n'existe pas";
			JFrame msgDial=new JFrame();
			JOptionPane.showMessageDialog(msgDial, msg);		
		}
	}
	
}

DataClass dc=new DataClass();

package hotelIHM;

import hotelClasses.DataClass;

public class GestionReservation extends JFrame {
	
	Reservation res=new Reservation();
	DataClass dc=new DataClass();
	JButton btnAjouter;
	JButton btnNouveau;
	private JPanel contentPane;
	private JTextField numResText;
	private JTextField dateResText;
	private JTextField dateArrText;
	private JTextField dateSorText;
	private JTextField nbrNuitsText;
	public JComboBox  cniCombo;
	private JTextField nbrChambreText;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					GestionReservation frame = new GestionReservation();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public GestionReservation() {
		addWindowListener(new WindowAdapter() {
			@Override
			public void windowOpened(WindowEvent arg0) {
				String num;
				try {
					num = String.valueOf(res.dernierNumRes()+1);
					numResText.setText(num);
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				
				
				dc.reqSelect("select cniClient from reservation");
					try {
						dc.rs.last();
						int rowCount = dc.rs.getRow();
						String[] data = new String[rowCount];
						
						dc.rs.beforeFirst();
						int i=1;
						while(dc.rs.next()){
							
								data[i-1] = dc.rs.getString("cniClient");
								cniCombo.addItem(data[i-1]);
								i++; 
						
						}
						
						dc.rs.close();
						dc.st.close();						
					
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					
			}
		});
		setTitle("Gestion r\u00E9servations");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 613, 466);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		
		btnNouveau = new JButton("Nouveau");
		btnNouveau.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {				
				btnAjouter.setEnabled(true);
				//btnNouveau.setEnabled(false);
				btnAjouter.setEnabled(true);
				String num;
				try {
					num = String.valueOf(res.dernierNumRes()+1);
					numResText.setText(num);
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				dateResText.setText(null);
				dateArrText.setText(null);
				dateSorText.setText(null);
				nbrNuitsText.setText(null);
			}
		});
		btnNouveau.setBackground(SystemColor.controlHighlight);
		btnNouveau.setBounds(74, 278, 97, 35);
		contentPane.add(btnNouveau);
		
		btnAjouter = new JButton("Ajouter");
		
		
		btnAjouter.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				SimpleDateFormat sdf=new SimpleDateFormat("dd/MM/yyyy");
				try {
					btnAjouter.setEnabled(false);
					res.ajouterReservation(sdf.parse(dateResText.getText()), sdf.parse(dateArrText.getText()), sdf.parse(dateSorText.getText()),Integer.parseInt(nbrNuitsText.getText()),Integer.parseInt(nbrChambreText.getText()), (String)cniCombo.getSelectedItem());
				} catch (NumberFormatException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				JFrame msgDial=new JFrame();
				JOptionPane.showMessageDialog(msgDial, "Ajout effectué avec succès ");
			}
		});
		btnAjouter.setBackground(SystemColor.controlHighlight);
		btnAjouter.setBounds(175, 278, 97, 35);
		contentPane.add(btnAjouter);
		
		JButton btnRechercher = new JButton("Liste de reservation du client");
		btnRechercher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				DataClass dc=new DataClass();
				dc.reqSelect("select * from reservation where cniClient='"+(String)cniCombo.getSelectedItem()+"'");
				try {
					ResultSetMetaData meta=dc.rs.getMetaData();
					Object[] column = new Object[meta.getColumnCount()];
					
					for(int i=1;i<=meta.getColumnCount();i++){
						column[i-1]=meta.getColumnName(i);
					}
					
					dc.rs.last();
					int rowCount = dc.rs.getRow();
					Object[][] data = new Object[rowCount][meta.getColumnCount()];
				
					dc.rs.beforeFirst();
					int j = 1;
					
					while(dc.rs.next()){
						for(int i = 1 ; i <= meta.getColumnCount(); i++){
							data[j-1][i-1] = dc.rs.getObject(i);
						}								
						j++;				
					}
					
					dc.rs.close();
					dc.st.close();
					contentPane.setLayout(new BorderLayout(0, 0));
					
					ListeReservation lr=new ListeReservation();
					 lr.setVisible(true);
					JTable table = new JTable(data,column);
					table.setBounds(0, 0, 434, 262);
					
					JScrollPane scrollPane = new JScrollPane(table);
					//contentPane.add(scrollPane);
				    lr.contentPane.add(scrollPane);
				   
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			}
		});
		btnRechercher.setBackground(SystemColor.controlHighlight);
		btnRechercher.setBounds(282, 278, 171, 35);
		contentPane.add(btnRechercher);
		
		JButton btnListeReservation = new JButton("Liste Reservations");
		btnListeReservation.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				ListeReservation lr=new ListeReservation();
				lr.setVisible(true);
			}
		});
		btnListeReservation.setBackground(SystemColor.controlHighlight);
		btnListeReservation.setBounds(282, 332, 171, 32);
		contentPane.add(btnListeReservation);
		
		JButton btnModifier = new JButton("Modifier");
		btnModifier.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				SimpleDateFormat sdf=new SimpleDateFormat("dd/MM/yyyy");
				try {
					res.modifierReservation(Integer.parseInt(numResText.getText()), sdf.parse(dateResText.getText()), sdf.parse(dateArrText.getText()), sdf.parse(dateSorText.getText()), Integer.parseInt(nbrNuitsText.getText()),Integer.parseInt(nbrChambreText.getText()), (String)cniCombo.getSelectedItem());
				} catch (NumberFormatException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		});
		btnModifier.setBackground(SystemColor.controlHighlight);
		btnModifier.setBounds(175, 332, 97, 32);
		contentPane.add(btnModifier);
		
		JButton btnSupprimer = new JButton("Supprimer");
		btnSupprimer.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				JFrame suppFrame=new JFrame();
				String txt=JOptionPane.showInputDialog (suppFrame, "Entrer le numéro de réservation") ;				
				
				res.supprimerReservation(Integer.parseInt(txt));					
				
			}
		});
		btnSupprimer.setBackground(SystemColor.controlHighlight);
		btnSupprimer.setBounds(74, 332, 97, 32);
		contentPane.add(btnSupprimer);
		
		JPanel panel = new JPanel();
		panel.setBounds(10, 0, 577, 243);
		contentPane.add(panel);
		panel.setLayout(null);
		
		JLabel label = new JLabel("CNI client         :");
		label.setBounds(326, 33, 88, 14);
		panel.add(label);
		
		numResText = new JTextField();
		numResText.setColumns(10);
		numResText.setBounds(197, 33, 119, 20);
		panel.add(numResText);
		
		dateResText = new JTextField();
		dateResText.setColumns(10);
		dateResText.setBounds(197, 72, 119, 20);
		panel.add(dateResText);
		
		dateArrText = new JTextField();
		dateArrText.setColumns(10);
		dateArrText.setBounds(197, 110, 119, 20);
		panel.add(dateArrText);
		
		dateSorText = new JTextField();
		dateSorText.setColumns(10);
		dateSorText.setBounds(197, 143, 119, 20);
		panel.add(dateSorText);
		
		nbrNuitsText = new JTextField();
		nbrNuitsText.setColumns(10);
		nbrNuitsText.setBounds(197, 181, 119, 20);
		panel.add(nbrNuitsText);
		
		JLabel label_1 = new JLabel("Nombre de nuits                       :");
		label_1.setBounds(10, 184, 159, 14);
		panel.add(label_1);
		
		JLabel label_2 = new JLabel("Date sortie client                      :");
		label_2.setBounds(10, 141, 159, 14);
		panel.add(label_2);
		
		JLabel label_3 = new JLabel("Date arriv\u00E9e client                    :");
		label_3.setBounds(10, 113, 159, 14);
		panel.add(label_3);
		
		JLabel label_4 = new JLabel("Date de r\u00E9servation                 :");
		label_4.setBounds(10, 75, 159, 14);
		panel.add(label_4);
		
		JLabel label_5 = new JLabel("Numero de reservation            :");
		label_5.setBounds(10, 36, 159, 14);
		panel.add(label_5);
		
		cniCombo = new JComboBox();
		cniCombo.setBounds(420, 30, 102, 20);
		panel.add(cniCombo);
		
		JLabel lblNombreDeChambres = new JLabel("Nombre de chambres               :");
		lblNombreDeChambres.setBounds(10, 215, 159, 14);
		panel.add(lblNombreDeChambres);
		
		nbrChambreText = new JTextField();
		nbrChambreText.setBounds(197, 212, 119, 20);
		panel.add(nbrChambreText);
		nbrChambreText.setColumns(10);
		
		JPanel panel_1 = new JPanel();
		panel_1.setBounds(10, 254, 577, 163);
		contentPane.add(panel_1);
		panel_1.setLayout(null);
		
		JButton button = new JButton("Afficher les chambres disponibles");
		button.setBounds(178, 118, 196, 34);
		panel_1.add(button);
	}
}

package hotelIHM;

import hotelClasses.Chambre;

public class GestionChambre extends JFrame {

	private JPanel contentPane;
	private JTextField numChText;
	private JTextField typeChText;
	private JComboBox etageCombo;
	private JRadioButton rdbtnOui;
	private JRadioButton rdbtnNon;
	DataClass dc=new DataClass();
	Chambre ch=new Chambre();
	private JTextField prixText;
	private JTextField numResText;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					GestionChambre frame = new GestionChambre();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public GestionChambre() {
		addWindowListener(new WindowAdapter() {
			@Override
			public void windowOpened(WindowEvent arg0) {
				
			}
		});
		setTitle("Gestion des chambres");
		
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 601, 417);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		
		JPanel panel = new JPanel();
		panel.setLayout(null);
		panel.setBounds(10, 21, 565, 250);
		contentPane.add(panel);
		
		numChText = new JTextField();
		numChText.setColumns(10);
		numChText.setBounds(197, 33, 119, 20);
		panel.add(numChText);
		
		typeChText = new JTextField();
		typeChText.setColumns(10);
		typeChText.setBounds(197, 77, 119, 20);
		panel.add(typeChText);
		
		JLabel lblEtage = new JLabel("Etage                                        :");
		lblEtage.setBounds(10, 149, 159, 14);
		panel.add(lblEtage);
		
		JLabel lblTypeDeChambre = new JLabel("Type de chambre                     :");
		lblTypeDeChambre.setBounds(10, 80, 159, 14);
		panel.add(lblTypeDeChambre);
		
		JLabel lblNumeroDeChambre = new JLabel("Num\u00E9ro de chambre                 :");
		lblNumeroDeChambre.setBounds(10, 36, 159, 14);
		panel.add(lblNumeroDeChambre);
		
		etageCombo = new JComboBox();
		String[] et={"1","2","3","4","5","6","7","8","9","10","11"};
		etageCombo=new JComboBox(et);
		etageCombo.setBounds(197, 146, 52, 20);	
		panel.add(etageCombo);
		
		prixText = new JTextField();
		prixText.setColumns(10);
		prixText.setBounds(197, 177, 119, 20);
		panel.add(prixText);
		
		JLabel lblPrix = new JLabel("Prix                                           :");
		lblPrix.setBounds(10, 180, 159, 14);
		panel.add(lblPrix);
		
		JLabel lblOccupee = new JLabel("Occup\u00E9e                                   :");
		lblOccupee.setBounds(10, 116, 159, 14);
		panel.add(lblOccupee);
		
		rdbtnOui = new JRadioButton("Oui");
		rdbtnOui.setBounds(197, 116, 52, 23);
		rdbtnOui.setEnabled(false);
		panel.add(rdbtnOui);
		
		rdbtnNon = new JRadioButton("Non");
		rdbtnNon.setBounds(264, 116, 109, 23);
		rdbtnNon.setEnabled(false);
		rdbtnNon.setSelected(true);
		panel.add(rdbtnNon);
		
		JLabel lblNumroDeRservation = new JLabel("Num\u00E9ro de r\u00E9servation             :");
		lblNumroDeRservation.setBounds(10, 211, 159, 14);
		panel.add(lblNumroDeRservation);
		
		numResText = new JTextField();
		numResText.setBounds(197, 208, 57, 20);
		numResText.setEnabled(false);
		panel.add(numResText);
		numResText.setColumns(10);
		
		JPanel panel_1 = new JPanel();
		panel_1.setBounds(10, 272, 565, 96);
		contentPane.add(panel_1);
		panel_1.setLayout(null);
		
		JButton btnNouveau = new JButton("Nouveau");
		btnNouveau.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				numChText.setText(null);
				typeChText.setText(null);
						
			}
		});
		btnNouveau.setBounds(78, 11, 114, 32);
		panel_1.add(btnNouveau);
		
		JButton btnAjouter = new JButton("Ajouter");
		btnAjouter.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				JFrame msgDial=new JFrame();
				boolean occup=false;
				if(rdbtnNon.isSelected()==true){
					
					occup=false;
				}
								
				if(numChText.getText().equals("") || typeChText.getText().equals("") || (rdbtnOui.isSelected()==false && rdbtnNon.isSelected()==false) || prixText.getText().equals("")){
				       JOptionPane.showMessageDialog(msgDial, "Un ou plusieurs champs ne sont pas remplis","Message d'avertissement",JOptionPane.ERROR_MESSAGE);
						}					
						else{
				ch.ajouterChambre(Integer.parseInt(numChText.getText()), typeChText.getText(),occup,Integer.parseInt((String)etageCombo.getSelectedItem()),Double.parseDouble(prixText.getText()));
				JOptionPane.showMessageDialog(msgDial, "Ajout effectué avec succès ");
						}
				}
		});
		btnAjouter.setBounds(220, 11, 114, 32);
		panel_1.add(btnAjouter);
		
		JButton btnModifier = new JButton("Modifier");
		btnModifier.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				try {
					ch.modifierChambre(Integer.parseInt(numChText.getText()), typeChText.getText(), Integer.parseInt((String)etageCombo.getSelectedItem()),Double.parseDouble(prixText.getText()));
				} catch (NumberFormatException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		btnModifier.setBounds(365, 11, 114, 32);
		panel_1.add(btnModifier);
		
		JButton btnSupprimer = new JButton("Supprimer");
		btnSupprimer.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				ch.supprimerChambre(Integer.parseInt(numChText.getText()));
			}
		});
		btnSupprimer.setBounds(78, 54, 114, 32);
		panel_1.add(btnSupprimer);
		
		JButton btnRechercher = new JButton("Rechercher");
		btnRechercher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					ch.rechercherChambre(Integer.parseInt(numChText.getText()));
					if(ch.disp==true){
						rdbtnOui.setSelected(true);
						rdbtnNon.setSelected(false);
					}
					else if(ch.disp==false){
						rdbtnNon.setSelected(true);
						rdbtnOui.setSelected(false);
					}
					
					typeChText.setText(ch.typeCh);
					etageCombo.setSelectedItem(ch.etag);
					numResText.setText(ch.numRes);
					
				} catch (NumberFormatException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		btnRechercher.setBounds(220, 54, 114, 32);
		panel_1.add(btnRechercher);
		
		JButton btnAfficherTousLes = new JButton("Afficher tous les chambres");
		btnAfficherTousLes.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				ListeChambre lc=new ListeChambre();
				lc.setVisible(true);
			}
		});
		btnAfficherTousLes.setBounds(365, 54, 177, 32);
		panel_1.add(btnAfficherTousLes);
	}
}

public final class DatabaseConfig {

 private static final String DRIVER = "com.mysql.jdbc.Driver";
 private static final String URL = "jdbc:mysql://localhost:3306/basehotel";
 private static final String USER = "root";
 private static final String PASSWORD = "";

 static{
  try {
   Class.forName(DRIVER);
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   throw new IllegalArgumentException("Database configuration issue: " + e.getMessage());
  }
 }

 public static Connection getConnection() throws SQLException {
  return DriverManager.getConnection(URL, USER, PASSWORD);
 }

}

public abstract class AbstractDBOperations {


 public void execute(String query) {
  Connection connection = null;
  Statement st = null;
  try {
   // Get connection
   connection = DatabaseConfig.getConnection();
   // Prepare statement
   st = connection.createStatement();
   // Execute statement
   st.executeUpdate(query);
  } catch (SQLException e) {
   // Handle exception
   e.printStackTrace();
  } finally {
   // Close connection before exit if any exception occur
   try{
    if (st != null) {
     st.close();
    }
   }catch(SQLException e){
    e.printStackTrace();
   }
   try{
    if (connection != null) {
     connection.close();
    }
   }catch(SQLException e){
    e.printStackTrace();
   }
  }
 }

 public ResultSet select(Connection connection, String query) throws SQLException {
  // Prepare statement
  Statement st = connection.createStatement();
  // Execute statement
  return st.executeQuery(query);
 }


}

public class RoomService extends AbstractDBOperations {

 public RoomService() {
 }

 public void insertRoom(Room room){
  execute(
   "INSERT INTO ROOM ('number','name') VALUES('"+room.getNumber()+"','"+room.getName()+"')"
  );
 }

 public List<Room> getAllRooms(){
  Connection connection = null;
  ResultSet rs = null;
  List<Room> rooms = new ArrayList<Room>();

  try{
   connection = DatabaseConfig.getConnection();
   rs = select(connection, "SELECT * FROM ROOM");
   Room currentRoom = null;

   while(rs.next()){
    currentRoom = new Room();
    currentRoom.setNumber(rs.getInt(0));
    currentRoom.setName(rs.getString(1));
    rooms.add(currentRoom);
   }

  }catch(SQLException e){
   e.printStackTrace();
  } finally {
   // Close statement
   try{
    if (rs != null){
     rs.close();
    }
   }catch(SQLException e){
    e.printStackTrace();
   }
   // Then close connection
   try{
    if (connection != null){
     connection.close();
    }
   }catch(SQLException e){
    e.printStackTrace();
   }
  }

  return rooms;
 }


}

public class Room {

 private int number;
 private String name;

 public int getNumber() {
  return this.number;
 }
 public void setNumber(int number) {
  this.number = number;
 }
 public String getName() {
  return this.name;
 }
 public void setName(String name) {
  this.name = name;
 }
}

public List<Chambre> tousLesChambres(){
		Connection connection=null;
		ResultSet rs=null;		
		List<Chambre> chambres=new ArrayList<Chambre>();
		
		try {
			connection=databaseConfig.getConnection();
			rs=select(connection, "select * from chambre");			
			Chambre chCourant=null;
			
			while(rs.next()){				
				chCourant=new Chambre();
				
				chCourant.setIdChambre(rs.getInt("idChambre"));
				chCourant.setTypeChambre(rs.getString("typeChambre"));

				chCourant.setOccupee(rs.getBoolean("occupee"));
				chCourant.setEtage(rs.getInt("etage"));
				chCourant.setPrix(rs.getInt("prix"));
				chCourant.setNumReservation(rs.getInt("numReservation"));
				chambres.add(chCourant);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			// Close statement
			   try{
			    if (rs != null){
			     rs.close();
			    }
			   }catch(SQLException e){
			    e.printStackTrace();
			   }
			   // Then close connection
			   try{
			    if (connection != null){
			     connection.close();
			    }
			   }catch(SQLException e){
			    e.printStackTrace();
			   }

		}
		return chambres;
		
	}

				SceChambre sc=new SceChambre();
					
				DefaultTableModel model=new DefaultTableModel();
				model.setColumnIdentifiers(new String[]{"Num Chambre","Type Chambre","Occupee","Etage","Prix","Num Reservation"});
				for(Chambre t:sc.tousLesChambres()){
										
					model.addRow(new String[]{String.valueOf(t.getIdChambre()),String.valueOf(t.getTypeChambre()),String.valueOf(t.isOccupee()),String.valueOf(t.getEtage()),String.valueOf(t.getPrix()),String.valueOf(t.getNumReservation())});
				}		
								
				JFrame fen=new JFrame("Tous les chambres");
				fen.setBounds(0, 0, 500, 300);
				JPanel jp=new JPanel();
				JTable jt=new JTable();				
				jt.setModel(model);

				jp.add(new JScrollPane(jt));
				
				fen.add(jp);
				fen.setVisible(true);

public class MyCustomCellRenderer extends DefaultTableCellRenderer {  
	private static final long serialVersionUID = 1L;   
	
	public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { 
		if (value instanceof JComboBox) {               
			return (JComboBox) value;         
			}           
		if (value instanceof Boolean) {     
			JCheckBox cb = new JCheckBox();    
			cb.setSelected(((Boolean) value).booleanValue());   
			return cb;           
			}          
		if (value instanceof JCheckBox) {     
			return (JCheckBox) value;     
			}          
		return new JTextField(value.toString()); 
		}   
	}
}

jt.getColumnModel().getColumn(2).setCellRenderer(new MyCustomCellRenderer());

public class MyCustomCellRenderer extends DefaultTableCellRenderer {  
	private static final long serialVersionUID = 1L;   
	
	public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { 
		if (value instanceof JComboBox) {               
			return (JComboBox) value;         
			}           
		if (value instanceof Boolean) {     
			JCheckBox cb = new JCheckBox();    
			cb.setSelected(((Boolean) value).booleanValue());   
			return cb;           
			}          
		if (value instanceof JCheckBox) {     
			return (JCheckBox) value;     
			}          
		return new JTextField(value.toString()); 
		}   
	}

               @Override
               public boolean isCellEditable(int row, int col) {
                   return (col == 2); // True pour col 2
               }

}