/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Vues;
import Entity.Trader;
import Model.FonctionsMetier;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Shazam
*/
public class frmGestionAchats extends javax.swing.JFrame {
DefaultTableModel dtmTraderGestionAchat;
FonctionsMetier fm;
public frmGestionAchats()
{
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tlbTraders = new javax.swing.JTable();
jScrollPane2 = new javax.swing.JScrollPane();
jTable2 = new javax.swing.JTable();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
jLabel1.setForeground(new java.awt.Color(255, 0, 0));
jLabel1.setText("Gestion des achats");
tlbTraders.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"Numéro", "Nom"
}
));
jScrollPane1.setViewportView(tlbTraders);
jTable2.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"Numéro", "Nom", "Montant", "Quantité"
}
));
jScrollPane2.setViewportView(jTable2);
jLabel2.setText("Montant des achats");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(422, 422, 422)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 369, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGap(36, 36, 36)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 382, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 134, Short.MAX_VALUE)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 679, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(25, 25, 25))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 189, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(147, 147, 147)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 162, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(57, 57, 57))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(21, 21, 21)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(41, 41, 41)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 355, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(49, 49, 49)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 355, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 57, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 56, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(29, 29, 29))
);
pack();
}// </editor-fold>
private void formWindowOpened(java.awt.event.WindowEvent evt) {
dtmTraderGestionAchat = new DefaultTableModel();
dtmTraderGestionAchat = (DefaultTableModel) tlbTraders.getModel();
fm = new FonctionsMetier();
RemplirTableauAction();
}
public void RemplirTableauAction()
{
ArrayList <Trader> lesTraders = fm.getAllTrader();
Vector v;
for (Trader T : lesTraders)
{
v = new Vector();
v.add(T.getIdTrader());
v.add(T.getNomTrader());
dtmTraderGestionAchat.addRow(v);
}
tlbTraders.setModel(dtmTraderGestionAchat);
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new frmGestionAchats().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable jTable2;
private javax.swing.JTable tlbTraders;
// End of variables declaration
}
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Entity;
/**
*
* @author Shazam
*/
public class Trader {
private int idTrader;
private String nomTrader;
public Trader()
{
}
public Trader (int unIdTrader, String unNomTrader)
{
unIdTrader = idTrader;
unNomTrader = nomTrader;
}
/**
* @return the idTrader
*/
public int getIdTrader() {
return idTrader;
}
/**
* @param idTrader the idTrader to set
*/
public void setIdTrader(int idTrader) {
this.idTrader = idTrader;
}
/**
* @return the nomTrader
*/
public String getNomTrader() {
return nomTrader;
}
/**
* @param nomTrader the nomTrader to set
*/
public void setNomTrader(String nomTrader) {
this.nomTrader = nomTrader;
}
public Object getidTrader() {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
public Object getnomTrader() {
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
}
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Model;
import Entity.Action;
import Entity.Trader;
import java.util.ArrayList;
/**
*
* @author Shazam
*/
public interface IMetier
{
public ArrayList<Action> getAllAction();
public ArrayList<Trader> getAllTrader();
}
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package Model;
import Entity.Action;
import Entity.Trader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Shazam
*/
public class FonctionsMetier implements IMetier
{
@Override
public ArrayList<Action> getAllAction() {
ArrayList<Action> mesActions = new ArrayList<>();
try {
//SQL
//Notre objet connexion
Connection cnx = ConnexionBDD.getCnx();
//Cet objet ne sert qu'a écrire la requete SQL
PreparedStatement stm = cnx.prepareStatement("SELECT * From action");
//On récupère un jeu d'enregistrement
// correspondant à notre select
// ResultSet = un jeu d'enregistrement ////ça recupère les valeurs des ligne (et grace a rs.next() pour passer a la ligne suivante aussi) d'un tableau renvoyé par SQL (le resultat de la requete envoyé)
ResultSet rs = stm.executeQuery();
while(rs.next())
{
Action monAction = new Action(rs.getInt("idAction"), rs.getString("nomAction"));
mesActions.add(monAction);
}
} catch (SQLException ex) {
Logger.getLogger(FonctionsMetier.class.getName()).log(Level.SEVERE, null, ex);
}
return mesActions;
}
@Override
public ArrayList<Trader> getAllTrader()
{
ArrayList<Trader> lesTraders = new ArrayList<>();
try {
//SQL
//Notre objet connexion
Connection cnx = ConnexionBDD.getCnx();
//Cet objet ne sert qu'a écrire la requete SQL
PreparedStatement stm = cnx.prepareStatement("SELECT idTrader, nomTrader From trader");
//On récupère un jeu d'enregistrement
// correspondant à notre select
// ResultSet = un jeu d'enregistrement ////ça recupère les valeurs des ligne (et grace a rs.next() pour passer a la ligne suivante aussi) d'un tableau renvoyé par SQL (le resultat de la requete envoyé)
ResultSet rs = stm.executeQuery();
while(rs.next())
{
Trader trad = new Trader (rs.getInt("idTrader"), rs.getString("nomTrader"));
lesTraders.add(trad);
}
} catch (SQLException ex) {
Logger.getLogger(FonctionsMetier.class.getName()).log(Level.SEVERE, null, ex);
}
return lesTraders;
}
}
Bonjour
merci déjà de prendre du temps pour moi
j'essaie de lister mes traders et du coup j'ai un retour avec des 0 sous mon tableau
× Après avoir cliqué sur "Répondre" vous serez invité à vous connecter pour que votre message soit publié.
× Attention, ce sujet est très ancien. Le déterrer n'est pas forcément approprié. Nous te conseillons de créer un nouveau sujet pour poser ta question.
“Faites quelque chose et, si ça ne réussit pas, essayez autre chose.” FdR