public static void insertActionCom( int idactiontype,int idutilisateur, Date dateaction, String actioncommercial ) throws SQLException {

          String query="";     
         

        try {
            query = "INSERT INTO ACTION_COM (ID_ACTION_TYPE,ID_INTERLOCUTEUR,ACTDATE,ACTCOMM) VALUES (?,?,?,?); " ;

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1,idactiontype);
            pStatement.setInt(2, idutilisateur);
            pStatement.setObject(3, dateaction);
            pStatement.setString(4, actioncommercial.toLowerCase());
            pStatement.executeUpdate();

        } catch (SQLException ex) {
            Logger.getLogger(RequetesActionCom.class.getName()).log(Level.SEVERE, null, ex);

        }
      }