insert multiple values using prepared statement using loop java

Question

I'm trying to insert multiple values in a mysql database using the iterative (for) but it always insert the first line and stops.

String rq="insert into seance values (?, ?, ?,?,?,?);";

try (Connection cnx = Connecteur1.getConnection(); PreparedStatement pst = cnx.prepareStatement(rq)) {

    for(Etudiant var:liste1)
    {
        if(!(listEntier.contains(var.getCode_etudiant())))
        { 
            pst.setString(1,DateCourant.format(date));
        pst.setString(2,temps.format(date) );
        pst.setInt(3,codeMatiere);
        pst.setInt(4, 0);
        pst.setInt(5,var.getCode_etudiant());
        pst.setInt(6, codeGroupe);

        pst.addBatch();

        }
        else
        {
            pst.setString(1,DateCourant.format(date));
            pst.setString(2,temps.format(date) );
            pst.setInt(3,codeMatiere);
            pst.setInt(4, 1);
            pst.setInt(5,var.getCode_etudiant());
            pst.setInt(6, codeGroupe);

           pst.addBatch();

        }

    }

    pst.executeBatch();
    pst.close();

}

Gerard Rozsavolgyi · Accepted Answer · 2015-01-17 18:50:49Z

1

You need :

cnx.setAutoCommit(false)

at the beginning

and

cnx.commit();

at the end

answered Jan 17, 2015 at 18:50

Gerard Rozsavolgyi

5,0944 gold badges34 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert multiple values using prepared statement using loop java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related