The database file is locked (database is locked)
Bonsoir,
j'ai deux classes (combo, et AJOUTER ), j'appelle une méthode qui rempli un combobBox (se trouve dans combo) depuis AJOUTER. En éxécutant le code de AJOUTER j'ai un erreur : "the database file is locked (database is locked) java" et c'est dans la ligne qui fait appel à ma méthode.
voicile code de la classe combo
Code:
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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
| public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
combo frame = new combo();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
public void fillProjectCombo(JComboBox<String> comboBox) {
Connection connection ;
PreparedStatement statement;
try {
try {
Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch bloc
e.printStackTrace();
}
connection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\tosiba\\eclipse-workspace\\training1\\src\\training1\\BDD.db");
statement= connection.prepareStatement("SELECT DISTINCT Nom_projet FROM Projet ORDER BY Nom_projet ");
ResultSet rs= statement.executeQuery();
while(rs.next()) {
comboBox.addItem(rs.getString("Nom_projet"));
}
statement.close();
statement.close();
statement.close();
connection.close();
//dispose();
} catch (Exception e1) {
e1.printStackTrace();
JOptionPane.showMessageDialog(null, "erreur");
}
}
public combo() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 450, 300);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
contentPane.setLayout(new BorderLayout(0, 0));
setContentPane(contentPane);
}
public void fillListeCombo( JComboBox < String> comboBox ) {
try {
try {
Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection connection1=null;
java.sql.Statement statement1=null;
connection1 = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\tosiba\\eclipse-workspace\\training1\\src\\training1\\BDD.db");
statement1 = connection1.createStatement();
ResultSet rs= statement1.executeQuery("SELECT DISTINCT Nom_projet FROM Projet ORDER BY Nom_projet");
while(rs.next()) {
comboBox.addItem(rs.getString("Nom_projet"));
}
statement1.close();
statement1.close();
statement1.close();
connection1.close();
//dispose();
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null, "erreur");
}
}
public void fillClientCombo ( JComboBox<String > comboBox , JComboBox <String> comboBox_1) {
Connection connection ;
Statement statement;
try {
try {
Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
connection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\tosiba\\eclipse-workspace\\training1\\src\\training1\\BDD.db");
statement= connection.createStatement();
ResultSet rs=statement.executeQuery("SELECT DISTINCT Nom_projet FROM Projet ");
while (rs.next()) {
comboBox.addItem(rs.getString("Nom_projet"));
}
ResultSet rs1= statement.executeQuery("SELECT DISTINCT Type FROM Client " );
while (rs1.next()) {
comboBox_1.addItem(rs1.getString("Type"));
}
statement.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null, "erreur");
}
}
public void fillversementCombo( JComboBox < String> comboBox_1 ) {
try {
try {
Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection connection1=null;
PreparedStatement statement1=null;
connection1 = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\tosiba\\eclipse-workspace\\training1\\src\\training1\\BDD.db");
statement1= connection1.prepareStatement("SELECT Nom FROM Client ORDER BY Nom ASC ");
ResultSet rs= statement1.executeQuery();
while (rs.next()) {
comboBox_1.addItem(rs.getString("Nom"));
}
statement1.close();
statement1.close();
connection1.close();
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null, "erreur");
}
} |
