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
| @WebMethod(operationName = "operation")
public JTable operation(@WebParam(name = "key")
String key) {
JTable table=null;
try {
//TODO write your implementation code here:
String[] columnNames = {"Videos", "Information"};
//---------Cconnexion à la base de données:----------------------
String username = "root";
String password = "0000";
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost:3306/mabase";
Connection conn = null;
conn = (Connection) DriverManager.getConnection(url, username, password);
System.out.println("OK connexion réussie...");
stmt = (Statement) conn.createStatement();
rs = stmt.executeQuery("select * from videos where nomVideo='" + key + "'");
// String name=rs.getString("nomVideo");
// ResultSetMetaData md = (ResultSetMetaData) rs.getMetaData();
rs.last();
int NbreResultats = rs.getRow();
System.out.println("Le nombre des résultats vaut " + NbreResultats); // to del
Object[][] data = new Object[NbreResultats][columnNames.length];
rs.beforeFirst();
String NEWLINE = System.getProperty("line.separator");
while (rs.next()) {
String inf = "";
inf = inf + " Nom de la vidèo :" + rs.getString("nomVideo") + NEWLINE + " Catégorie :" + rs.getString("categorie") + NEWLINE + " Durée :" + rs.getString("duree") + NEWLINE;
String Ligne1 = " Nom de la vidèo :" + rs.getString("nomVideo");
String Ligne2 = " Catégorie :" + rs.getString("categorie");
String Ligne3 = " Durée :" + rs.getString("duree");
String im = rs.getString("lien");
System.out.println(im); // to del
JLabel label = new JLabel("<html>" + Ligne1 + "<br>" + Ligne2 + "<br>" + Ligne3 + "</html>");
System.out.println(inf);
data[0][0] = null;
data[0][1] = label.getText();
System.out.println(data[0][1].toString());
rs.close();
stmt.close();
table = new JTable(data, columnNames);
table.setPreferredScrollableViewportSize(new Dimension(958, 581));
table.setFillsViewportHeight(true);
//table.setDefaultRenderer(null, this);
ImageIcon iconv = new ImageIcon(im);
// table.getColumnModel().getColumn(0).setCellRenderer((TableCellRenderer) new ImageRenderer());//importanteeeeee
table.setRowHeight(300);
JScrollPane scrollPane = new JScrollPane(table); //Create the scroll pane and add the table to it.
table.add(scrollPane); //Add the scroll pane to this panel.
}
} catch (SQLException ex) {
Logger.getLogger(NewWebService.class.getName()).log(Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
Logger.getLogger(NewWebService.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(NewWebService.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(NewWebService.class.getName()).log(Level.SEVERE, null, ex);
}return table;
} |
Débutante web service Java avec NetBeans
Répondre avec citation
... 
Partager