1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| String sql="insert into Acte (nom, prenom,nom_Acte,depot,rdv,redactrice) values('"+nom1+"', '"+prenom1+"','"+Type+"','"+depot+"','"+rdv+"','"+redactrice+"')";
//System.out.println(sql);
Connection con=ConnectionManager.getConnection();
try {
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
sql="SELECT MAX(id) as max FROM Acte;";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
String id=rs.getString(1);
sql="insert into location (idActe,duree,montant,banque,pret) values('"+id+"','"+duree+"','"+montant+"','"+banque+"','"+pret+"')";
stmt.executeUpdate(sql);
sql="insert into partie values('"+id+"','"+nom1+"','"+prenom1+"','1')";
stmt.executeUpdate(sql);
sql="insert into partie values('"+id+"','"+nom2+"','"+prenom2+"','2')";
stmt.executeUpdate(sql);
//System.out.println(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} |
Partager