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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
import java.awt.BorderLayout;
public class test extends JFrame {
private JPanel contentPane;
ArrayList<String> elements=new ArrayList<String>();
ArrayList<String> elementsIn=new ArrayList<String>();
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
test frame = new test();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
* @throws SQLException
*/
public test() throws SQLException {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 1200, 600);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
elements.add("product 1");
elements.add("product 2");
elements.add("product 3");
elementsIn.add("in 1");
elementsIn.add("in 2");
elementsIn.add("in 3");
JTabbedPane paneTop=new JTabbedPane();
paneTop.setBounds(31, 52, 1140, 510);
Connection con=ConnectDataBaseGeneric("jdbc:jtds:sybase://xxx/kplus","xxx","xxx ,"net.sourceforge.jtds.jdbc.Driver");
ResultSet rs= GetResultFromQuery(con,"select * from Branches");
//on repace le curseur avant la première ligne
DefaultTableModel model = buildTableModel(rs);
con.close();
for(int i=0;i<elements.size();i++){
System.out.println("je suis dans la phase I "+ i );
JPanel panelTop=new JPanel();
panelTop.setBounds(40,60,1130,500);
JTabbedPane paneIn=new JTabbedPane();
paneIn.setBounds(50,100,1125,450);
for(int y=0;y<elementsIn.size();y++){
JScrollPane scroll=createJScrollPane(model);
JPanel panel=createJPanelIn(scroll);
paneIn.add(elementsIn.get(y),panel);
}
panelTop.add(paneIn);
paneTop.add(elements.get(i),panelTop);
}
contentPane.add(paneTop);
}
public static Connection ConnectDataBaseGeneric(String url,String login, String mdp,String driver){
try {
Class.forName(driver);
}
catch(ClassNotFoundException ex) {
System.out.println("Error: unable to load driver class!");
}
try {
return DriverManager.getConnection(url, login, mdp);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public static ResultSet GetResultFromQuery(Connection conn,String query,String ...args){
Statement stmt ;
//String newQuery=TransformQuery(query,args);
try {
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY,ResultSet.HOLD_CURSORS_OVER_COMMIT);
//stmt = conn.createStatement();
return stmt.executeQuery(query);
} catch (SQLException e) {
//traitement de l'exception
e.printStackTrace();
return null;
}
}
public static DefaultTableModel buildTableModel(ResultSet rs) throws SQLException {
ResultSetMetaData metaData = rs.getMetaData();
// names of columns
Vector<String> columnNames = new Vector<String>();
int columnCount = metaData.getColumnCount();
for (int column = 1; column <= columnCount; column++) {
columnNames.add(metaData.getColumnName(column));
}
// data of the table
Vector<Vector<Object>> data = new Vector<Vector<Object>>();
while (rs.next()) {
Vector<Object> vector = new Vector<Object>();
for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {
vector.add(rs.getObject(columnIndex));
}
data.add(vector);
}
return new DefaultTableModel(data, columnNames);
}
public static JScrollPane createJScrollPane(DefaultTableModel defaultTableModel){
JScrollPane scrollPane_dataTable = new JScrollPane();
scrollPane_dataTable.setBounds(63,130,1108,432);
scrollPane_dataTable.setViewportBorder(null);
JXTable datatable = new JXTable(defaultTableModel);
scrollPane_dataTable.setViewportView(datatable);
return scrollPane_dataTable;
}
public static JPanel createJPanelIn(JScrollPane jScrollPane){
JPanel panel= new JPanel();
panel.setBounds(55,120,1115,440);
panel.add(jScrollPane);
return panel;
}
} |
