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
|
File repertoire = new File("/home/test/Musique");
File[] liste = repertoire.listFiles();
String show = "";
String search ="";
String add = "(";
MP3File mp3 = null;
TagContent info = new TagContent();
for(int i=0;i<liste.length;i++){
try {
mp3 = new MP3File("/home/test/Musique/"+liste[i].getName());
info = mp3.getTitle();
} catch (ID3v2WrongCRCException e1) {
e1.printStackTrace();
} catch (ID3v2DecompressionException e1) {
e1.printStackTrace();
} catch (ID3v2IllegalVersionException e1) {
e1.printStackTrace();
} catch (IOException e1) {
e1.printStackTrace();
} catch (NoMP3FrameException e1) {
e1.printStackTrace();
} catch (FrameDamagedException e) {
e.printStackTrace();
}
search = ("title=\""+info.getTextContent().toString() + "\" AND home=\"/home/test/Musique/\"");
this.commande = ("SELECT * FROM musics WHERE "+search);
this.database.setCommand(this.commande);
this.database.execute();
if(this.database.first() == true){
show += liste[i].getName() + "\n";
}else if(this.database.first() == false){
String keep = "";
for(int j =0; j <6;j++){
try{
if(j == 0){
add = "('/home/test/Musique/',";
info = mp3.getComments();
keep = info.getTextContent();
if(keep.length() <= 32 && keep.length() != 0){
keep = keep.substring(0, keep.length()-1);
}else if(keep.length() > 32){
keep = keep.substring(0, 31);
}else if(keep.length() == 0){
keep = "unknown";
}
info.setContent(keep);
add += "'"+info.getTextContent()+"',";
}else if(j == 1){
info = mp3.getArtist();
keep = info.getTextContent();
if(keep.length() <= 32 && keep.length() != 0){
keep = keep.substring(0, keep.length()-1);
}else if(keep.length() > 32){
keep = keep.substring(0, 31);
}else if(keep.length() == 0){
keep = "unknown";
}
info.setContent(keep);
add += "'"+info.getTextContent()+"',";
}else if(j == 2){
info = mp3.getGenre();
keep = info.getTextContent();
if(keep.length() <= 32 && keep.length() != 0){
keep = keep.substring(0, keep.length()-1);
}else if(keep.length() > 32){
keep = keep.substring(0, 31);
}else if(keep.length() == 0){
keep = "unknown";
}
info.setContent(keep);
add += "'"+info.getTextContent()+"',";
}else if(j == 3){
info = mp3.getTitle();
keep = info.getTextContent();
if(keep.length() <= 32 && keep.length() != 0){
keep = keep.substring(0, keep.length()-1);
}else if(keep.length() > 32){
keep = keep.substring(0, 31);
}else if(keep.length() == 0){
keep = "unknown";
}
info.setContent(keep);
add += "'"+info.getTextContent()+"',";
}else if(j == 4){
info = mp3.getAlbum();
keep = info.getTextContent();
if(keep.length() <= 32 && keep.length() != 0){
keep = keep.substring(0, keep.length()-1);
}else if(keep.length() > 32){
keep = keep.substring(0, 31);
}else if(keep.length() == 0){
keep = "unknown";
}
info.setContent(keep);
add += "'"+info.getTextContent()+"',";
}else if(j == 5){
info = mp3.getYear();
keep = info.getTextContent();
keep = keep.substring(0, 3);
info.setContent(keep);
add += +Integer.parseInt(info.getTextContent())+")";
}
}catch(FrameDamagedException e){
e.getMessage();
}
}
this.commande = ("INSERT INTO musics VALUES "+ add);
this.database.setCommand(this.commande);
this.database.execute();
this.database.updateRow();
this.database.acceptChanges();
}
}
disconnectFromDB();
this.commande = "";
notifyObserver(show); |
Erreur avec AWT-EventQueue
Répondre avec citation
Envoyé par tiloup367
Partager