1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| private void initData() {
try{
Connection conn = ConnectionDB.getInstance();
Statement state = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet result = state.executeQuery("SELECT * FROM operation INNER JOIN utilisateur ON operation.opeuti = '"+userActuel.getCode()+"' ORDER BY opedate");
result.last();
Object[][] data;
int nbLignes = result.getRow();
int ligne=0;
data = new Object[nbLignes][5];
result.beforeFirst();
if(result.next()){
do{
data[ligne][0] = result.getDate(1);
if(result.getBoolean(2)){
data[ligne][1] = String.valueOf(result.getFloat(3))+" ";
data[ligne][2] = "";
}else{
data[ligne][2] = String.valueOf(result.getFloat(3))+" ";
data[ligne][1] = "";
}
data[ligne][3] = result.getString(4);
data[ligne][4] = new BoutonTable("Supprimer",ligne);
ligne++;
}while(result.next());
}
else{
data = new Object[1][5];
JOptionPane jop = new JOptionPane();
data[ligne][1] = String.valueOf(Float.parseFloat(jop.showInputDialog(null,"Entrez le solde de départ du compte : ","Solde du compte",JOptionPane.QUESTION_MESSAGE)))+" ";
data[ligne][2] = "";
data[ligne][0] = new SimpleDateFormat("dd/MM/yy").format(new Date());
data[ligne][3] = "SOLDE DE DEPART";
data[ligne][4] = new BoutonTable("Supprimer",ligne);
state.executeUpdate("INSERT INTO OPERATION(opedate,opecredit,opemontant,opelibele,opeuti) VALUES('"+data[ligne][0]+"',true,'"+data[ligne][1]+"','"+data[ligne][3]+"','"+userActuel.getCode()+"')");
}
result.close();
state.close();
this.data = new DataModel(data);
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
} |
Partager