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 46 47 48 49 50 51 52 53
|
Database rDB = this.DB;
try {
DataTable R = new DataTable(rDB,"select * from DRT");
for(int i = 0 ; i < R.rowsCount();i++)
{
DefaultTreeModel model = (DefaultTreeModel) this.jTree1.getModel();
DefaultMutableTreeNode root = (DefaultMutableTreeNode) model.getRoot();
DefaultMutableTreeNode n = new DefaultMutableTreeNode(R.getRow(i).GetColumn(1)+"");
model.insertNodeInto(n, root, root.getChildCount());
DataTable R2 = new DataTable(rDB,"select * from DOT where DRT='"+R.getRow(i).GetColumn(0)+"'");
for(int j = 0 ; j < R2.rowsCount();j++)
{
DefaultTreeModel m = (DefaultTreeModel) this.jTree1.getModel();
DefaultMutableTreeNode n2 = new DefaultMutableTreeNode(R2.getRow(j).GetColumn(2)+"");
model.insertNodeInto(n2, n, n.getChildCount());
DataTable R3 = new DataTable(rDB,"select * from CENTRE where DOT='"+R2.getRow(j).GetColumn(0)+"'");
for(int K = 0 ; K < R3.rowsCount();K++)
{
DefaultMutableTreeNode n3 = new DefaultMutableTreeNode(R3.getRow(K).GetColumn(2)+"");
model.insertNodeInto(n3, n2, n2.getChildCount());
DataTable R4 = new DataTable(rDB,"select * from fiche where CEN='"+R3.getRow(K).GetColumn(0)+"'");
for(int L = 0 ; L< R4.rowsCount();L++)
{
// Fiche Load
model.insertNodeInto(new DefaultMutableTreeNode(R4.getRow(L).GetColumn(0)+""), n3, n3.getChildCount());
//model.insertNodeInto(new DefaultMutableTreeNode(R4.getRow(L).GetColumn(0)+""), n3, n3.getChildCount());
}
}
}
}
} catch (SQLException ex) {
Logger.getLogger(resultat.class.getName()).log(Level.SEVERE, null, ex);
}
} |
Partager