1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| public static void Enregistre (String[] resScanQr) throws SQLException {
int nOf = Integer.parseInt(resScanQr[0]);
int nArticleSap = Integer.parseInt(resScanQr[1]);
int nOt = Integer.parseInt(resScanQr[2]);
int nOfPere = Integer.parseInt(resScanQr[6]);
String sql = "INSERT INTO t_moulage ( OF , ARTICLE_SAP , OT , OF_PERE ) VALUES (?, ?, ?, ?)";
Connection con = Connexion.seConnecterALaBaseProd();
PreparedStatement preparedStmt = con.prepareStatement(sql);
preparedStmt.setInt (1, nOf);
preparedStmt.setInt (2, nArticleSap);
//preparedStmt.setDate (3, startDate);
preparedStmt.setInt (3, nOt);
preparedStmt.setInt (4, nOfPere);
preparedStmt.executeUpdate();
} |
Partager