1 2 3 4 5 6 7 8 9 10 11 12 13 14
| ...
try{
InitialContext initContext = new InitialContext();
DataSource ds = (DataSource) initContext.lookup("jdbc/MaDataSource");
Connection conn = (Connection) ds.getConnection();
String requete = "INSERT INTO DOSREC(NUMDOSSIER,DATEREC,HEUREREC,NOMREC,NUMBR,NFOUFO,RSOCFO)"+""
+" VALUE('"+numDossier+"', '"+TxtDate.getText()+"', '"+TxtHeure.getText()+"','"
+TxtNomReceptio.getText()+"','"+TxtNumBRCentrale.getText()+"','"+NFOUFO+"','"
+ComboFournisseur.getSelectedItem()+"')";
Statement state = conn.createStatement();
int res = state.executeUpdate(requete);
conn.close();
state.close();
... |
Partager