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
|
package dictionary;
import java.sql.*;m,type
import javax.swing.JOptionPane;
/**
*
* @author my ordy
*/
public class Design extends javax.swing.JFrame {
ResultSet rs;
Statement st;
PreparedStatement ps;
Connection con;
public Design() {
initComponents();
try{
Class.forName("org.postgresql.Driver");
System.out.println("Driver O.K");
String url="jdbc:postgresql://localhost:5432/Dictionary";
String user="postgres";
String passwd="azer";
con=DriverManager.getConnection(url,user,passwd);
System.out.println("connexion effective");
st=con.createStatement();
ps= con.prepareStatement("SELECT * FROM dico");
rs= ps.executeQuery();
while(rs.next());
{
System.out.println(rs.getString("word"));
}
} catch(Exception ex){}
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try{
ps=con.prepareStatement("INSERT INTO dico(id,word,meaning,french,sentence,synonym,type)VALUES('?',?','?','?','?','?','?' )");
ps.setString(1,jTextField13.getText());
ps.setString(2,jTextField6.getText());
ps.setString(3,jTextField7.getText());
ps.setString(4,jTextField8.getText());
ps.setString(5,jTextField9.getText());
ps.setString(6,jTextField11.getText());
ps.setString(7,jTextField12.getText());
ps.executeUpdate();
JOptionPane.showMessageDialog(null,"a word is inserted");
}
catch(Exception ex){}
}
private void jTextField2MousePressed(java.awt.event.MouseEvent evt) {
jTextField2.setText("");
}
private void jPanel6MousePressed(java.awt.event.MouseEvent evt) {
jTextField2.setText("Enter");
}
private void jTextField6MousePressed(java.awt.event.MouseEvent evt) {
jTextField6.setText("");
}
private void jTextField7MousePressed(java.awt.event.MouseEvent evt) {
jTextField7.setText("");
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/*
* Set the Nimbus look and feel
*/
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/*
* If Nimbus (introduced in Java SE 6) is not available, stay with the
* default look and feel. For details see
* http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(Design.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(Design.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(Design.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(Design.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/*
* Create and display the form
*/
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Design().setVisible(true);
}
});
/*
* Create and display the form
*/
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Design().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel10;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JPanel jPanel6;
private javax.swing.JPanel jPanel7;
private javax.swing.JPanel jPanel8;
private javax.swing.JPanel jPanel9;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTabbedPane jTabbedPane2;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField10;
private javax.swing.JTextField jTextField11;
private javax.swing.JTextField jTextField12;
private javax.swing.JTextField jTextField13;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JTextField jTextField4;
private javax.swing.JTextField jTextField5;
private javax.swing.JTextField jTextField6;
private javax.swing.JTextField jTextField7;
private javax.swing.JTextField jTextField8;
private javax.swing.JTextField jTextField9;
// End of variables declaration
} |
Impossibilité à remplir la BD
Répondre avec citation
Partager