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;
}
} |
Partager