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
|
try {
ResultSet rs = null; ResultSet res = null;
Connection cx = null;
Statement st = null;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/sonabd";
cx = DriverManager.getConnection(url, "root", "");
st = cx.createStatement();
rs = st.executeQuery("SELECT C.codeContrat, C.annee, C.nomContrat, "
+ "A.nomSoumissionnaire, C.montant, C.dtNotification, C.delaiExecution, C.dtLivraison "
+ "FROM Contrat C, Attributaire A "
+ "WHERE C.codeContrat=A.codeContrat AND C.annee =A.annee");
while (rs.next()) {
st = cx.prepareStatement("INSERT INTO suiviMarche(numOrdre, codeContrat, annee, nomContrat, attributaire, montant"
+ "dtNotification, delaiExecution, dtLivraison, observation) values(2, '"+rs.getString(1)+"','"+rs.getString(2)+"',"
+ "'"+rs.getString(3)+"', '"+rs.getString(4)+"', '"+rs.getString(5)+"', '"+rs.getString(6)+"', '"+rs.getString(7)+"', '"+rs.getString(8)+"'"
+ "Null");
}
} catch (Exception e) {
throw new RuntimeException(e);
} |
Partager