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();
} |
